Attachments in Applications



Last updated on December 21st, 2015 at 06:17 am

All of the tables which hold attachments-related data are owned by the FND
schema.

There are a number of tables which hold information determining which area of
the application can use attachments:

FND_ATTACHMENT_FUNCTIONS holds information about the forms for which the
attachments function can be enabled;

FND_ATTACHMENT_BLOCKS holds information about the blocks within those forms for
which the attachments feature can be enabled;

FND_ATTACHMENT_BLK_ENTITIES holds information on the attachments that can be
used in a particular form block.

For example FND_ATTACHMENT_FUNCTIONS contains a row for FUNCTION_NAME =
‘PERWSHRG’ ie the combined Person & Assignment form.
FND_ATTACHMENT_BLOCKS links to FND_ATTACHMENT_FUNCTIONS via the column
ATTACHMENT_FUNCTION_ID and contains a row for BLOCK_NAME = ‘PERSON’.
FND_ATTACHMENT_BLK_ENTITIES holds a row for the ‘PERSON’ block with
DATA_OBJECT_CODE = ‘PER_PEOPLE_F’ and PK1_FIELD = ‘PERSON.PERSON_ID’ and
defines whether an attachment to this block can be queried, inserted, updated
and deleted.

FND_ATTACHED_DOCUMENTS stores information relating a document to an entity and
in this example would hold ENTITY_NAME = ‘PER_PEOPLE_F’ and PK1_VALUE = 44.
PK1_VALUE is the value for FND_ATTACHMENT_BLK_ENTITIES.PK1_FIELD (ie
‘PERSON.PERSON_ID’) and so this attachment is for the person with
PER_PEOPLE_F.PERSON_ID = 44. The DOCUMENT_ID of the stored document is also
held on this table.

FND_DOCUMENTS holds language-independent information about the document
including CATEGORY_ID and DATATYPE_ID. It doesn’t hold the actual document.

DATATYPE_ID is taken from FND_DOCUMENT_DATATYPES. This table holds a row for
each supported datatype eg Short Text, File, etc.

CATEGORY_ID is taken from FND_DOCUMENT_CATEGORIES. This table holds a row for
each valid attachment category in an application. eg Comments and Resume
are all valid for APPLICATION_ID = 800 and Miscellaneous is valid for all
applications (APPLICATION_ID = 0). As each specific entity is seeded with
valid categories, there is another table, FND_DOC_CATEGORY_USAGES, which holds
a row for each CATEGORY_ID valid for an ATTACHMENT_FUNCTION_ID. It determines
which categories can be used for attachments on a particular form.

The translation table FND_DOCUMENTS_TL stores information about the documents
in FND_DOCUMENTS and links to this table by the column DOCUMENT_ID. Rows in
FND_DOCUMENTS_TL include a description of the document.


Leave a Reply