Results for “css_def_languages_tl”

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

Overview

CSS_DEF_LANGUAGES_TL is a translatable (TL) table within the CSS – Support module of Oracle E-Business Suite. Its documented description is simply "Translatable table for Languages." The "_TL" suffix follows the standard Oracle EBS multilingual convention, indicating that this table stores language-dependent descriptive attributes for a base (non-translated) entity, with one row per language installed in the Applications instance. In this case, the base entity is the language definition itself, so the table stores the translated names or display descriptions associated with each language record.

The metadata classifies the object under CSS – Support and explicitly flags the product as obsolete. Critically, the DBA implementation data states "Not implemented in this database," meaning the table is not populated or actively used in the referenced EBS 12.1.1 / 12.2.2 instance. It should therefore be treated as a legacy or dormant artifact rather than an operational dependency.

From a data modeling perspective, the metadata's heuristic Data Vault classification is standalone. This suggests the table is best modeled as an independent satellite-like structure, with no mined foreign-key relationships linking it to other hubs or links. Its translatable nature means the true attribute-descriptive payload lives here, while the surrogate key pair drives uniqueness.

Key Information Stored

The documented columns are limited, reflecting the table's narrow purpose as a language-description store. The principal columns are:

• LANGUAGE_ID – The identifier for the language entity. This is a component of the composite primary key and serves as the linguistically neutral surrogate reference to the underlying language definition.
• LANGUAGE – The language code (for example, the installed language abbreviation). This column participates in the primary key and, in standard EBS TL design, is also the discriminator that distinguishes rows belonging to different installed languages.

The primary key is documented as CSS_DEF_LANGUAGES_TL_PK, defined over the composite of (LANGUAGE_ID, LANGUAGE). In this pattern, LANGUAGE_ID functions as the surrogate key linking back to the base language table, while LANGUAGE acts as the language-context component required by the EBS translation framework. No separate unique index beyond the primary key is documented. Because the extract does not expose translated-descriptive columns such as NAME or DESCRIPTION, the visible metadata emphasizes the key structure over the attribute payload.

Common Use Cases and Queries

In instances where this table was implemented, typical usage centered on resolving the translated display name of a language for user-interface and reporting purposes. A representative query joins the TL table to its base counterpart on LANGUAGE_ID and filters by the session's language:

• SELECT language_id, language FROM css_def_languages_tl WHERE language = :p_lang; – retrieves the language-context rows for a specific installed language.
• Joining to the base language definition on LANGUAGE_ID to obtain whichever descriptive attribute exists in the base table alongside the translated context.
• Reporting use cases would surface language labels in administrative setup screens or LOVs. Given the "obsolete" and "not implemented" status, any such query should be validated against a live instance before reliance, and migration or decommissioning analysis is the more probable practical scenario. Analysts auditing legacy CSS setup often query this table to confirm whether residual configuration exists.

Related Objects

The mined relationship data classifies CSS_DEF_LANGUAGES_TL as standalone, meaning no foreign keys are documented from this table. Consequently, the most significant related objects are inferred from the standard EBS translation pattern rather than from explicit FK evidence:

• The base language definition table sharing the LANGUAGE_ID surrogate key, which the TL table translates (joined on LANGUAGE_ID).
• FND_LANGUAGES – the standard EBS language repository, whose LANGUAGE codes align with the LANGUAGE column.
• Other CSS_DEF_* base and _TL pairs within the CSS – Support module, which follow the same multilingual key convention.
• NLS and translation-related views that consume TL tables generically.

Because the table is not implemented and the module is obsolete, no application programming interfaces are documented as dependent upon it. Any integration referencing CSS_DEF_LANGUAGES_TL should be considered at risk and reviewed for removal.