Search Results fnd_descr_flex_contexts_tl




Overview
Explore in AI Chat

Overview

The FND_DESCR_FLEX_CONTEXTS_TL table is a core translation table within the Application Object Library (FND) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It stores the translated, language-specific descriptions for Descriptive Flexfield (DFF) contexts. A DFF context defines a specific set of segments and validation rules that are conditionally displayed based on a value in another field. While the base table, FND_DESCR_FLEX_CONTEXTS, stores the technical definitions, this translation table (TL) enables the multilingual display of context names and prompts within the application's user interface. This is essential for global deployments where end-users operate in different languages, ensuring that flexfield context descriptions are presented in the user's session language.

Key Information Stored

The table's structure is designed to support multilingual data with a composite primary key that uniquely identifies a translated row. The key columns, which also serve as foreign keys to the base table, are APPLICATION_ID, DESCRIPTIVE_FLEXFIELD_NAME, and DESCRIPTIVE_FLEX_CONTEXT_CODE. These columns link the translation to a specific flexfield and its context. The fourth primary key column, LANGUAGE, stores the language code (e.g., 'US' for American English, 'KO' for Korean). The most critical data column is DESCRIPTIVE_FLEX_CONTEXT_NAME, which holds the translated name of the context as it appears to users. Other columns may include LAST_UPDATE_DATE and LAST_UPDATED_BY for auditing. The presence of a LANGUAGE column and the "_TL" suffix are standard conventions for EBS translation tables.

Common Use Cases and Queries

This table is primarily accessed by the application's internal localization engine to render DFF context names in the correct language. Common administrative and reporting use cases include auditing translation coverage, troubleshooting missing translations, and generating implementation documentation. A typical query retrieves the translated context name for a specific flexfield across all installed languages, which is useful for verifying setup.

Sample Query:
SELECT t.language, t.descriptive_flex_context_name
FROM fnd_descr_flex_contexts_tl t
WHERE t.application_id = 401
AND t.descriptive_flexfield_name = 'PER_POSITIONS'
AND t.descriptive_flex_context_code = 'JOB_ROLE'
ORDER BY t.language;

Developers may also join this table with the base table and other flexfield metadata tables (like FND_DESCR_FLEX_COLUMN_USAGES_TL) to build comprehensive, user-language-aware reports on an application's flexfield structure.

Related Objects

  • FND_DESCR_FLEX_CONTEXTS (Base Table): The primary foreign key relationship. The TL table depends on this base table for its core definitional data.
  • FND_DESCRIPTIVE_FLEXS_TL: The translation table for the Descriptive Flexfield title itself, related via APPLICATION_ID and DESCRIPTIVE_FLEXFIELD_NAME.
  • FND_DESCR_FLEX_COLUMN_USAGES_TL: Stores translations for individual segment prompts within a context, sharing a similar key structure.
  • FND_LANGUAGES: Provides a reference list of installed languages that correspond to the LANGUAGE column values.