Search Results fnd_documents_tl

Overview

The FND_DOCUMENTS_TL table is a core translation table within the Application Object Library (FND) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. Owned by the APPLSYS schema, it stores the translated, language-specific versions of descriptive attributes for documents managed by the system. Its primary role is to support the multilingual capabilities of EBS by enabling the storage of document titles, descriptions, and other textual metadata in multiple languages, as defined in the FND_LANGUAGES table. This table operates in conjunction with its base table, FND_DOCUMENTS, which holds the language-independent document data.

Key Information Stored

The table's structure is designed to support the translation model common across EBS. The primary key is a composite of DOCUMENT_ID and LANGUAGE, ensuring a unique record for each document and language combination. The DOCUMENT_ID column is a foreign key to the FND_DOCUMENTS table, linking the translation to the core document entity. The LANGUAGE column is a foreign key to FND_LANGUAGES, identifying the translation's language code (e.g., 'US', 'FR'). The table typically contains translated columns for fields like TITLE and DESCRIPTION, which correspond to similar columns in the base FND_DOCUMENTS table. A critical column is MEDIA_ID, which serves as a foreign key to the actual document content stored in the specialized media tables: FND_DOCUMENTS_LONG_RAW, FND_DOCUMENTS_LONG_TEXT, and FND_DOCUMENTS_SHORT_TEXT.

Common Use Cases and Queries

This table is central to any reporting or data extraction process that requires document information in a user's session language. A common use case is generating a localized list of documents attached to business entities, such as purchase orders or invoices. A typical query joins FND_DOCUMENTS_TL with the base FND_DOCUMENTS table and filters by the desired LANGUAGE. For example, to retrieve the French titles and descriptions of all documents, one might use: SELECT dtl.title, dtl.description FROM fnd_documents_tl dtl, fnd_documents d WHERE dtl.document_id = d.document_id AND dtl.language = 'FR';. Developers also interact with this table when implementing custom programs that must display or process document metadata in a multilingual context, ensuring the correct translation is fetched based on the user's session or a specified language code.

Related Objects

FND_DOCUMENTS_TL has defined foreign key relationships with several key tables, as documented in the ETRM metadata. Its primary relationship is with the base table FND_DOCUMENTS via the DOCUMENT_ID column. It references the FND_LANGUAGES table through its LANGUAGE column to validate language codes. Crucially, it links to the tables that store the actual document content through the MEDIA_ID column. These content tables are:

• FND_DOCUMENTS_LONG_RAW (for binary data)
• FND_DOCUMENTS_LONG_TEXT (for long text)
• FND_DOCUMENTS_SHORT_TEXT (for short text)

This structure separates translated metadata in FND_DOCUMENTS_TL from the language-independent document entity in FND_DOCUMENTS and the physical content in the media-specific tables.