Results for “fnd_documents_tl”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FND_DOCUMENTS_TL is the translation table for the FND_DOCUMENTS entity in the Oracle E-Business Suite Application Object Library (FND). Owned by the APPLSYS schema and shipped in a VALID state in both EBS 12.1.1 and 12.2.2, it stores language-specific descriptive content that accompanies the base document definition held in FND_DOCUMENTS. Where the base table records the structural identity of an attached document or media record, FND_DOCUMENTS_TL carries the human-readable text—title, description, short text, and file name—rendered in each installed language.

Following the standard Oracle multi-language (MLS) pattern, the translation table is keyed by the surrogate combination of DOCUMENT_ID plus LANGUAGE, meaning a single document may have one row per enabled language. This design isolates translatable attributes from language-neutral attributes, allowing the same attachment to display correctly across a global instance without duplicating its binary or structural metadata.

From a data modeling perspective, the mined foreign-key structure classifies FND_DOCUMENTS_TL heuristically as a link-style object that bridges the base document and the language dimension. It should be treated as a descriptive satellite attached to the FND_DOCUMENTS hub in any downstream warehouse or Data Vault model.

Key Information Stored

The table exposes 34 documented columns. The most significant include:

• DOCUMENT_ID — the surrogate key linking each translation row back to its parent record in FND_DOCUMENTS; part of the composite primary key FND_DOCUMENTS_TL_PK.
• LANGUAGE — the language code identifying which installed language the row represents; the second component of the primary key and a foreign key to FND_LANGUAGES.
• TITLE — the translatable display title for the document.
• DESCRIPTION — free-form descriptive text shown to end users.
• SHORT_TEXT — an abbreviated label suitable for list-of-values and menu display.
• FILE_NAME — the file name associated with the document or attachment.
• MEDIA_ID — pointer to the media storage record; foreign-keyed to FND_DOCUMENTS_LONG_RAW, FND_DOCUMENTS_LONG_TEXT, and FND_DOCUMENTS_SHORT_TEXT.
• SOURCE_LANG and APP_SOURCE_VERSION — translation provenance columns indicating source language and application version.
• DOC_ATTRIBUTE_CATEGORY and DOC_ATTRIBUTE1–15 — the standard DFF descriptor flexfield columns available for client-specific extension.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, plus REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE.

The documented unique index FND_DOCUMENTS_TL_U1 (DOCUMENT_ID, LANGUAGE) reinforces the business-key candidate: exactly one translation row per document per language.

Common Use Cases and Queries

Typical uses center on retrieving attachment text in the correct session language, audit reporting on translated content, and ETL extracts feeding an enterprise document catalog. A representative join fetches the base document plus its English translation:

• Retrieve translated document text: SELECT d.DOCUMENT_ID, t.TITLE, t.DESCRIPTION, t.FILE_NAME FROM FND_DOCUMENTS d, FND_DOCUMENTS_TL t WHERE d.DOCUMENT_ID = t.DOCUMENT_ID AND t.LANGUAGE = USERENV('LANG');
• Language coverage audit: count rows per DOCUMENT_ID to detect documents missing translations in a required language.
• Media resolution: join MEDIA_ID to FND_DOCUMENTS_LONG_TEXT or FND_DOCUMENTS_SHORT_TEXT to recover the underlying attachment body.
• Change tracking: filter on LAST_UPDATE_DATE and LAST_UPDATED_BY for audit or incremental extracts.

Related Objects

The most significant objects referencing or referenced by this table are:

• FND_DOCUMENTS — the base table; joined on DOCUMENT_ID (foreign key).
• FND_LANGUAGES — the language dimension; joined on LANGUAGE.
• FND_DOCUMENTS_LONG_RAW — media storage for long raw attachments, referenced via MEDIA_ID.
• FND_DOCUMENTS_LONG_TEXT — long text media, referenced via MEDIA_ID.
• FND_DOCUMENTS_SHORT_TEXT — short text media, referenced via MEDIA_ID.

These relationships make FND_DOCUMENTS_TL the canonical translation access point for any reporting or integration layer that surfaces EBS attachments with localized titles and descriptions.