Results for “fnd_language_code”

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

Overview

CSS_DEF_LANGUAGES_VL is a translation-enabled (VL, "view language") database view that belongs to the CSS – Support product family. In Oracle EBS 12.1.1 and 12.2.2 the CSS module is documented as obsolete, and this object is catalogued accordingly in ETRM. The view presents the language definitions maintained by the CSS application, combining the base (untranslated) rows of CSS_DEF_LANGUAGES_B with the translated name and description held in CSS_DEF_LANGUAGES_TL. Because it is a VL view, it resolves the translated columns for the session language and exposes a single, flattened row per language, which makes it convenient for reporting and integration consumers that would otherwise need to join the _B and _TL tables manually. Within the EBS data model it is a descriptive/validation-style view rather than a transactional one, and it is intended to be queried read-only.

Underlying Base Objects

The ETRM metadata documents the view text as a join over two base objects:

• CSS_DEF_LANGUAGES_B – the base table in the _B suffix convention, holding non-translatable control columns such as LANGUAGE_ID, FND_LANGUAGE_CODE, sort order, date ranges, the WHO audit columns, and the DFF attributes.
• CSS_DEF_LANGUAGES_TL – the translation table in the _TL suffix convention, supplying the NAME and DESCRIPTION columns per installed language.

The join is B.LANGUAGE_ID = T.LANGUAGE_ID AND T.LANGUAGE = USERENV('LANG'). The USERENV('LANG') predicate is the standard EBS mechanism for returning only the translation row matching the run-time session language, which is why the view is suffixed _VL. Through its WHERE clause the view effectively applies the _TL language filter automatically, so callers do not repeat it.

Key Columns

• ROW_ID – the ROWID of the underlying base table row; not a stored column but a pseudo-column selected for row addressing.
• LANGUAGE_ID – the primary identifier of the language definition and the join key between the _B and _TL tables.
• FND_LANGUAGE_CODE – the Oracle Applications language code (for example US or D), the column the user searched for; it links to the FND language infrastructure.
• OBJECT_VERSION_NUMBER – the OVN column used for optimistic locking on the underlying entity.
• SORT_ORDER, START_DATE_ACTIVE, END_DATE_ACTIVE – display ordering and effective-dating controls.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – the standard WHO audit columns.
• ATTRIBUTE1–ATTRIBUTE15, CONTEXT – the Descriptive Flexfield (DFF) segment columns.
• NAME, DESCRIPTION – the translated text retrieved from CSS_DEF_LANGUAGES_TL for the session language.

Common Use Cases and Queries

Typical usage is to retrieve the language code and its current translated description for a given language identifier, or to enumerate all active language definitions ordered for display. Because CSS is obsolete in 12.2.2, the view is chiefly of interest for inventory, migration, and legacy reporting rather than new development. A representative query is:

• SELECT language_id, fnd_language_code, name, description FROM css_def_languages_vl WHERE sysdate BETWEEN start_date_active AND NVL(end_date_active, sysdate) ORDER BY sort_order;
• SELECT fnd_language_code, name FROM css_def_languages_vl WHERE language_id = :p_language_id;

Note that translated output depends on the session language, so results for NAME and DESCRIPTION will differ between sessions configured with different language settings. The ETRM metadata records no owner and no further documented base objects beyond the two tables above; it also states the object is "not implemented in this database," indicating availability is environment-dependent.