Creating an OAF Page with FND Attachments

Sometimes clients have requirements to attach files (like invoice copy etc.), this can be achieved using FND Attachments. Oracle provides developers with a way to store files/attachments in Oracle via FND Attachments. Below Diagram shows the tables involved in the attachment functionality Diagram Source: http://oracleebspro.blogspot.com/2013/03/fnd-attachments-in-oracle-apps.html In OAF the Attachment functionality is automatically handled by the Attachment Beans, you can find more details for the same in OAF Documentation guide (<Jdev Installation path>\jdevdoc\WebHelp\devguide\feat\feat_attach.htm). Below i will demonstrate an example as to how to create an OAF Page with Fnd Attachments. 1.>    Setups needed for including Fnd Attachment to an OAF Page Attachment references are stored in FND_ATTACHED_DOCUMENTS, identified by the Entity Name, hence we will first need to create an Entity and make sure it is mapped to our Table’s primary key. Th...