Results for “fnd_document_categories_tl”

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

Overview

FND_DOCUMENT_CATEGORIES_TL is the translation (language-dependent) table for FND_DOCUMENT_CATEGORIES, the base table that defines document categories used throughout Oracle E-Business Suite's Application Object Library (FND). The table resides in the APPLSYS schema and stores the user-facing, language-specific text of document categories, specifically the NAME and USER_NAME attributes, keyed by CATEGORY_ID and LANGUAGE. Whereas the base table holds the language-independent definition of a category (including the source-language values), this _TL table allows each category to carry translated descriptions for every installed language, enabling multilingual presentation of category text in forms, reports, and concurrent program output.

This object participates in the standard Oracle EBS multi-language ("MLS") pattern, in which every translatable entity has a base table plus a corresponding _TL companion. The base table is the owner of the surrogate identifier (CATEGORY_ID), while the _TL table supplies the localized NAME and USER_NAME. In a Data Vault modeling sense, the provided heuristic classifies this table as satellite-leaning: it depends on FND_DOCUMENT_CATEGORIES for its key and carries descriptive, subject-oriented attributes (translations), which is characteristic of a satellite rather than a hub or link. Because its grain is defined by both CATEGORY_ID and LANGUAGE, it functions as a descriptive satellite attached to the document-category hub.

Key Information Stored

The table contains twelve documented columns. The most significant are:

• CATEGORY_ID — the surrogate key inherited from FND_DOCUMENT_CATEGORIES; identifies the category whose translation this row holds. Part of the composite primary key.
• LANGUAGE — the NLS language code for which NAME and USER_NAME are translated. Part of the composite primary key.
• NAME — the translated display name of the document category in the given language.
• USER_NAME — the translated, user-facing identifier or short name for the category.
• SOURCE_LANG — indicates the language in which the base record was originally entered; the source-language row is maintained as the canonical value.
• CREATION_DATE, CREATED_BY — standard audit columns recording when and by whom the row was inserted.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — audit columns tracking the most recent modification and originating login.
• APP_SOURCE_VERSION — the application source version associated with the record.
• ZD_EDITION_NAME — an edition-related column present in the documented 12.2.2 schema, used in the unique indexes below.

The documented primary key is FND_DOCUMENT_CATEGORIES_TL_PK on (CATEGORY_ID, LANGUAGE). Three business-key candidate unique indexes are documented: U1 on (CATEGORY_ID, LANGUAGE, ZD_EDITION_NAME), U2 on (USER_NAME, LANGUAGE, ZD_EDITION_NAME), and U3 on (NAME, LANGUAGE, ZD_EDITION_NAME). These enforce that names and user names are unique per language, distinguishing the reserved surrogate key from the alternate business keys.

Common Use Cases and Queries

Typical uses include reporting the localized names of document categories, validating that translations exist for all required languages, and joining translated text back to category definitions and their attachments. A common query retrieves the translated name for the session language with an NVL fallback to the source language:

SELECT t.category_id, t.name, t.user_name, t.language
FROM applsys.fnd_document_categories_tl t
WHERE t.category_id = :category_id
AND t.language = USERENV('LANG');

Administrators may audit missing translations by comparing the count of _TL rows per category against the set of installed languages, or identify categories lacking a translation in a target locale. Reporting queries frequently join this table to the base table to present human-readable category labels alongside language-independent attributes.

Related Objects

• FND_DOCUMENT_CATEGORIES — the base (owner) table; join on CATEGORY_ID. This is the documented foreign-key relationship and the parent of the translation row.
• FND_DOCUMENTS / FND_DOCUMENT_ENTITIES — document records that reference categories for classification and retrieval.
• FND_LANGUAGES — the language definition table; LANGUAGE values here correspond to installed language codes.
• FND_ATTACHED_DOCUMENTS — attaches documents into categories, indirectly depending on the translated category name.
• FND_DOCUMENT_CATEGORIES_VL — the MLS view that unions base and _TL rows to expose translated values as a logical view.

These relationships confirm that FND_DOCUMENT_CATEGORIES_TL is a dependent translation satellite, taking its key from FND_DOCUMENT_CATEGORIES and supplying localized descriptive text consumed by document-management and attachment features across the EBS FND layer.