Search Results fnd_attachment_blk_entities




Overview
Explore in AI Chat

Overview

The FND_ATTACHMENT_BLK_ENTITIES table is a core data object within the Application Object Library (FND) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as a junction table that manages the relationship between attachment blocks and the document entities to which they are assigned. This table is essential for the EBS attachment functionality, enabling the association of a single, reusable attachment block—which contains the actual file data and metadata—with multiple application entities (e.g., Purchase Orders, Invoices, Employees). This design promotes data normalization and efficient storage by allowing one uploaded document to be linked to multiple business objects without duplication.

Key Information Stored

The table's primary purpose is to store linkage records, with its key columns defining these relationships. The primary identifier is the system-generated ATTACHMENT_BLK_ENTITY_ID. The two critical foreign key columns are ATTACHMENT_BLK_ID, which references a specific attachment block in the FND_ATTACHMENT_BLOCKS table, and DATA_OBJECT_CODE, which references a valid document entity definition in the FND_DOCUMENT_ENTITIES table. This combination dictates which attachment is linked to which type of EBS entity. The table maintains a unique constraint (FND_ATTACHMENT_BLK_ENTITIES_UK) on the pair of ATTACHMENT_BLK_ID and DATA_OBJECT_CODE to prevent duplicate assignments.

Common Use Cases and Queries

A primary use case is auditing and reporting on document usage across the system. For instance, administrators may need to identify all business entities that share a common attached document. The table is also central to the underlying logic of the standard "Attachments" form interface. Common queries involve joining to related tables to retrieve meaningful information. To find all entities linked to a specific attachment block, one might use:

  • SELECT fae.DATA_OBJECT_CODE, fde.USER_NAME FROM APPLSYS.FND_ATTACHMENT_BLK_ENTITIES fae JOIN APPLSYS.FND_DOCUMENT_ENTITIES fde ON fae.DATA_OBJECT_CODE = fde.DATA_OBJECT_CODE WHERE fae.ATTACHMENT_BLK_ID = <block_id>;

Conversely, to list all attachments linked to a particular entity type (e.g., PO Headers):

  • SELECT fab.FILE_NAME, fab.CREATION_DATE FROM APPLSYS.FND_ATTACHMENT_BLK_ENTITIES fae JOIN APPLSYS.FND_ATTACHMENT_BLOCKS fab ON fae.ATTACHMENT_BLK_ID = fab.ATTACHMENT_BLK_ID WHERE fae.DATA_OBJECT_CODE = 'PO_HEADERS';

Related Objects

The table has defined foreign key relationships with two critical FND tables, forming the core of the attachment architecture:

  • FND_ATTACHMENT_BLOCKS: This relationship, via the ATTACHMENT_BLK_ID column, provides access to the physical or database-stored attachment content, file metadata (name, MIME type), and descriptive text.
  • FND_DOCUMENT_ENTITIES: This relationship, via the DATA_OBJECT_CODE column, defines the type of EBS business object (such as a transaction table or form) that the attachment block is associated with, providing context for the attachment's usage.

These relationships are fundamental for any query or program that needs to traverse from an attachment to its target entities or vice versa.