Attachments in Oracle Applicatins (Long Description and Short Description in Oracle apps)

Attachment in Oracle Applications:

Bu using this attachment feature we can enable users to attach images, text, spreadsheets, word process documents.

This attachment icon we can find in the oracle application tool bar. 

How to enable attachment to the form (will see in my next post)                        

Types of Attachments in Oracle Apps:

1)      Short Text 

Text will store in database which having less than 2000 characters

2)      Long Text

Text will store in database which having more than 2000 characters

3)      Image

Images which will display in Oracle Forms, including exp: bmp,jpeg,jfif….

4)      Web Page

By referencing URL we can view webpage with web browser.

5)      OLE Object 

It requires other OLE server applications to view Microsoft word or Excel.

  

Below are the tables which will involve in attachment functionality.

 

1)      FND_ATTACHED_DOCUMENTS

2)      FND_DOCUMENT_ENTITIES_TL

3)      FND_DOCUMENTS

4)      FND_DOCUMENT_CATEGORIES_TL

5)      FND_DOCUMENTS_SHORT_TEXT  ---- Long text type attachment

6)      FND_DOCUMENTS_LONG_TEXT  ---- Short text type attachment

7)      FND_DOCUMENTS_LONG_RAW

8)      FND_LOBS --- It will store file type attachments

9)      FND_DOC_CATEGORY_USAGES

10)   FND_ATTACHMENT_FUNCTIONS

Below diagram will give functionality of attachments in Oracle Apps: