Search Results fnd_descr_flex_col_usage_tl

Overview

The FND_DESCR_FLEX_COL_USAGE_TL table is a core Application Object Library 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 the metadata that defines how descriptive flexfield (DFF) columns are presented to users. A descriptive flexfield allows organizations to add custom attributes to standard application forms. While the base configuration of these attributes, such as their prompts and enabled states, is stored in FND_DESCR_FLEX_COLUMN_USAGES, the FND_DESCR_FLEX_COL_USAGE_TL table holds the translated versions of the end-user prompt for each configured column across different installed languages. This enables a single EBS installation to support a global user base with localized interface text for custom fields.

Key Information Stored

The table's structure is designed to support multilingual data linked to a specific DFF column usage. Its primary key uniquely identifies a translation record through a composite of the base usage's identifiers and the language code. Critical columns include APPLICATION_ID, DESCRIPTIVE_FLEXFIELD_NAME, DESCRIPTIVE_FLEX_CONTEXT_CODE, and APPLICATION_COLUMN_NAME, which together form a foreign key to the base FND_DESCR_FLEX_COLUMN_USAGES table. The LANGUAGE column stores the language code (e.g., 'US' for American English). The most significant user-facing column is FORM_LEFT_PROMPT, which contains the translated text for the field's prompt as it appears on the form. Additional columns like DESCRIPTION and LAST_UPDATE_DATE support documentation and maintenance tracking for the translation records.

Common Use Cases and Queries

This table is primarily queried for reporting on DFF configurations in multilingual environments, troubleshooting missing translations, and during data migrations or upgrades. A common scenario is identifying DFF prompts that lack a translation for a specific language, which can be achieved by joining to the base table and filtering for a target language. For example, to find all translated prompts for the 'PER_ADD_FLEX' flexfield in French, one might use a query joining on the key columns and filtering for LANGUAGE = 'F'. Developers may also query this table programmatically via the FND_FLEX_DESC_API package to retrieve prompts dynamically for form rendering. Direct data manipulation (INSERT, UPDATE) on this table should be performed using the standard Oracle Application Object Library APIs to maintain data integrity.

Related Objects

The table has a direct and critical foreign key relationship with the base configuration table, as documented in the provided metadata. The relationship is defined as follows:

• Foreign Key to FND_DESCR_FLEX_COLUMN_USAGES: This is the principal relationship. The columns APPLICATION_ID, DESCRIPTIVE_FLEXFIELD_NAME, DESCRIPTIVE_FLEX_CONTEXT_CODE, and APPLICATION_COLUMN_NAME in FND_DESCR_FLEX_COL_USAGE_TL reference the primary key of the FND_DESCR_FLEX_COLUMN_USAGES table. Every translation record must correspond to a single, existing DFF column usage definition.

Other related objects include the FND_DESCRIPTIVE_FLEXS_TL and FND_DESCR_FLEX_CONTEXTS_TL tables, which store translations for the flexfield title and context prompts, respectively. The FND_FLEX_DESC_API package provides the supported interface for accessing and maintaining this translation data.