Search Results fnd_document_categories_tl

Overview

The FND_DOCUMENT_CATEGORIES_TL table is a core Application Object Library (AOL) table within Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as a translation table, storing multilingual descriptions for document categories defined in its base table, FND_DOCUMENT_CATEGORIES. This table is essential for supporting the global deployment of EBS, enabling the user interface to display category names and descriptions in a user's preferred language. The table is owned by the APPLSYS schema and is a critical component for managing document categorization and attachment metadata across the application's multilingual environment.

Key Information Stored

The table's primary purpose is to hold translated text for each document category. Its structure is defined by a composite primary key consisting of CATEGORY_ID and LANGUAGE, ensuring a unique translation entry per category per language. The key columns include CATEGORY_ID, which is a foreign key to the base table, and LANGUAGE, which stores the language code (e.g., 'US' for American English). The primary data columns are NAME and USER_NAME, which hold the translated display name and a user-facing name for the category, respectively. Additional standard translation table columns, such as SOURCE_LANG, CREATION_DATE, and LAST_UPDATE_DATE, are also present to manage the translation lifecycle and audit changes.

Common Use Cases and Queries

This table is primarily accessed to retrieve localized category names for user interfaces and reports. A common use case is populating language-sensitive lists of values (LOVs) for document attachment categories within forms. Developers and support personnel query this table to verify or audit translations. A typical query to retrieve all translations for a specific category would join to the base table:

• SELECT fdc.CATEGORY_ID, fdctl.LANGUAGE, fdctl.NAME, fdctl.USER_NAME FROM FND_DOCUMENT_CATEGORIES fdc, FND_DOCUMENT_CATEGORIES_TL fdctl WHERE fdc.CATEGORY_ID = fdctl.CATEGORY_ID AND fdc.CATEGORY_ID = :category_id;

Another frequent pattern is to retrieve the category name in the current session language for reporting purposes, often using the NLS_LANGUAGE session parameter in a WHERE clause.

Related Objects

The FND_DOCUMENT_CATEGORIES_TL table has a direct and singular foreign key relationship, as documented in the provided metadata. It is dependent on the base definition table:

• FND_DOCUMENT_CATEGORIES: This is the base table where document categories are defined. The foreign key from FND_DOCUMENT_CATEGORIES_TL.CATEGORY_ID references FND_DOCUMENT_CATEGORIES, enforcing referential integrity. All translation records must correspond to a valid entry in this base table.

The table's primary keys (FND_DOCUMENT_CATEGORIES_TL_PK, _UK1, _UK2) ensure data integrity for translations and enforce uniqueness on the translated NAME and USER_NAME columns within each language.