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:
