Search Results fnd_document_entities




Overview
Explore in AI Chat

Overview

The FND_DOCUMENT_ENTITIES table is a core Application Object Library (FND) table within the Oracle E-Business Suite (EBS) architecture. It serves as the central registry for document entities, which are the fundamental data objects or business entities to which documents and attachments can be linked. Every table or view in EBS that is enabled for document attachment functionality must be registered as a document entity in this table. Its primary role is to define and manage the metadata for these attachable entities, enabling the unified document management and attachment features across all EBS modules, such as Oracle Web Applications Desktop Integrator and the generic attachment interface.

Key Information Stored

The table stores metadata that uniquely identifies and describes each attachable entity. The primary columns include DOCUMENT_ENTITY_ID, which is the unique numeric identifier and primary key. The DATA_OBJECT_CODE column is a critical unique key that stores the internal code name for the entity, typically corresponding to the underlying database table or view. The APPLICATION_ID column links the entity to its owning application via a foreign key to FND_APPLICATION. Other significant columns likely include entity names, descriptions, and flags controlling entity behavior, though the specific column list is not detailed in the provided metadata. The structure ensures each attachable data object is uniquely identifiable within the EBS instance.

Common Use Cases and Queries

This table is primarily queried by the attachment framework to validate and resolve attachment references. Common use cases include identifying all registered attachable entities for a specific application, troubleshooting attachment configuration issues, or generating reports on document-enabled objects. A typical query would join FND_DOCUMENT_ENTITIES with FND_APPLICATION to get a readable list. For example:
SELECT fe.DATA_OBJECT_CODE, fa.APPLICATION_NAME, fe.DOCUMENT_ENTITY_ID FROM APPLSYS.FND_DOCUMENT_ENTITIES fe, FND_APPLICATION fa WHERE fe.APPLICATION_ID = fa.APPLICATION_ID ORDER BY fa.APPLICATION_NAME;
Another common pattern is to check if a specific table is registered as a document entity before implementing custom attachment logic, ensuring compatibility with EBS standards.

Related Objects

As indicated by the foreign key relationships, FND_DOCUMENT_ENTITIES is integral to several key attachment structures. FND_APPLICATION provides the master list of applications. The FND_DOCUMENT_ENTITIES_TL table holds translated descriptions for the entities. FND_ATTACHMENT_BLK_ENTITIES references it, linking document entities to the blocks used in the attachment user interface. Furthermore, integration with other modules is shown through the foreign key from OE_AK_OBJECTS_EXT in the Order Management (ONT) product, which leverages this registry for its object definitions. These relationships underscore its role as a master source for attachable object metadata consumed by the broader document management infrastructure.