Search Results fnd_documents_long_text

Overview

The FND_DOCUMENTS_LONG_TEXT table, owned by the APPLSYS schema, is a core data repository within the Oracle E-Business Suite (EBS) Application Object Library (FND). Its primary role is to store the long text content for documents managed by the EBS document management system. This table acts as the central repository for textual document bodies, separating the potentially large text data from the transactional metadata stored in related tables. It is a critical component for features that require storage and retrieval of extensive text, such as detailed descriptions, terms and conditions, or other document-centric content across various EBS modules.

Key Information Stored

The table's structure is designed to efficiently store and reference long text data. The primary and most critical column is MEDIA_ID, which serves as the unique identifier for each long text entry. This column is the primary key and is the essential link to the document's metadata. The actual textual content is stored in a LONG or CLOB column (the specific datatype may vary by EBS version and customization). While the provided metadata does not list all columns explicitly, the table's purpose indicates it contains at least one column for the document body text, and potentially others for attributes like language or formatting, given its relationship with a translation table (FND_DOCUMENTS_TL).

Common Use Cases and Queries

A primary use case is retrieving the full text of a document for display or processing within an application. This is commonly required in reporting, data audits, or integration scenarios. Developers and administrators may query this table to extract document content for migration, archival, or troubleshooting purposes. A typical query involves joining with the FND_DOCUMENTS_TL table to get both the metadata and the long text.

Sample SQL Pattern:
SELECT dtl.document_id, dtl.document_title, dlt.media_id, dlt.long_text
FROM fnd_documents_tl dtl,
fnd_documents_long_text dlt
WHERE dtl.media_id = dlt.media_id
AND dtl.language = USERENV('LANG')
AND dtl.document_id = :p_doc_id;

Direct manipulation of data in this table via DML (INSERT, UPDATE, DELETE) is strongly discouraged outside of Oracle-provided APIs to maintain data integrity with the document management system.

Related Objects

The table maintains a direct and essential foreign key relationship with the FND_DOCUMENTS_TL table, which stores the translated titles and metadata for documents.

• Primary Key: FND_DOCUMENTS_LONG_TEXT_PK on column MEDIA_ID.
• Foreign Key Relationship (Referencing Table):
  • Table: FND_DOCUMENTS_TL
  • Foreign Key Column: FND_DOCUMENTS_TL.MEDIA_ID
  • Joins to: FND_DOCUMENTS_LONG_TEXT.MEDIA_ID

This relationship confirms that each record in FND_DOCUMENTS_TL can be associated with one long text entry via the MEDIA_ID, forming the link between a document's descriptive metadata and its substantive content.