Search Results fnd_documents_short_text

Overview

The FND_DOCUMENTS_SHORT_TEXT 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. Owned by the APPLSYS schema, this table serves as the primary repository for storing the textual content of "short text" documents. In the EBS architecture, the Document Management System (DMS) leverages this table to manage document entities where the primary content is character-based text, as opposed to long text (CLOBs) or binary media. Its role is integral to the structured storage and retrieval of descriptive or detailed text associated with various application entities, enabling consistent document handling across the suite.

Key Information Stored

The table's structure is designed to link document metadata with its textual content. The primary key column, MEDIA_ID, is the critical identifier that uniquely associates a row in this table with a specific document record. This MEDIA_ID directly corresponds to the MEDIA_ID column in the FND_DOCUMENTS_TL table, which holds the translatable metadata (like title and description) for the document. The table's main content column, typically named SHORT_TEXT or a similar variant (though not explicitly listed in the provided metadata), stores the actual character data of the document. The presence of a primary key constraint (FND_DOCUMENTS_SHORT_TEXT_PK) on MEDIA_ID ensures data integrity for this core relationship.

Common Use Cases and Queries

This table is primarily accessed when an application needs to display or process the full text of a short document. Common scenarios include generating reports that combine document descriptions with their full content, or serving text for display in EBS forms. A typical query involves joining with the FND_DOCUMENTS_TL table to retrieve both the document's metadata and its text body. For example:

• SELECT dtl.title, dtl.description, dst.short_text FROM fnd_documents_short_text dst, fnd_documents_tl dtl WHERE dst.media_id = dtl.media_id AND dtl.language = USERENV('LANG');

Data maintenance tasks, such as identifying documents with empty text or purging specific document content, would also query this table directly using the MEDIA_ID.

Related Objects

The FND_DOCUMENTS_SHORT_TEXT table has a fundamental relationship with the FND_DOCUMENTS_TL table, as defined by the documented foreign key where FND_DOCUMENTS_TL.MEDIA_ID references FND_DOCUMENTS_SHORT_TEXT.MEDIA_ID. This establishes a one-to-one relationship between a document's translatable title and its short text content. It is part of a larger document management hierarchy that likely includes the base table FND_DOCUMENTS (for non-translatable data) and other media-specific tables like FND_DOCUMENTS_LONG_TEXT. Access to data in this table is typically managed through standard Oracle Application Object Library APIs rather than via direct DML operations.