Last updated on December 21st, 2015 at 06:17 am
All of the tables which hold attachments-related data are owned by the FND
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
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.