Search Results fnd_iso_languages_tl




Overview
Explore in AI Chat

Overview

FND_ISO_LANGUAGES_TL is the translation table for FND_ISO_LANGUAGES in the Oracle E-Business Suite Application Object Library (FND) schema APPLSYS. It stores the language-specific, user-facing text attributes (notably NAME and DESCRIPTION) for each ISO language code registered in the base table. The _TL suffix follows the standard Oracle EBS multilingual design pattern, in which language-independent attributes reside in the base table and translated attributes are held here, keyed by a language code and a source language for translation bookkeeping. Because the table carries descriptive, attribute-level detail that changes over time, the mined Data Vault classification heuristic suggests modeling it as a satellite; the metadata labels it standalone, meaning no enforced foreign key relationships were mined from the FK structure.

Key Information Stored

The table contains 11 documented columns. The most operationally significant are:

  • ISO_LANGUAGE_3 — The three-character ISO 639-2 language code (for example, ENG, FRA, DEU). This is the primary business identifier carried from the base table and the column most frequently referenced in queries.
  • LANGUAGE — The Oracle language code identifying the translation in which NAME and DESCRIPTION are rendered. This is the second component of the composite key.
  • NAME — The translated display name of the ISO language, presented in the language identified by LANGUAGE.
  • DESCRIPTION — A longer translated description of the ISO language entry.
  • SOURCE_LANG — The language from which the row was originally translated, supporting Oracle's translation synchronization logic (for example, US).
  • ZD_EDITION_NAME — The editioning column introduced by the Oracle EBS 12.2 online patching architecture, identifying the edition to which the row belongs.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who created and last modified the row and when.

The declared primary key is FND_ISO_LANGUAGES_TL_PK, defined on the composite of ISO_LANGUAGE_3 and LANGUAGE. Two unique indexes are documented as business-key candidates: FND_ISO_LANGUAGES_TL_U1 on (ISO_LANGUAGE_3, LANGUAGE, ZD_EDITION_NAME) and FND_ISO_LANGUAGES_TL_U2 on (DESCRIPTION, LANGUAGE, ZD_EDITION_NAME). The edition-aware U1 index effectively supersedes the primary key under 12.2 editioning.

Common Use Cases and Queries

Typical uses include retrieving a language's display name in a specific locale, validating that a three-letter ISO code is registered, and building multilingual selection lists. A standard lookup filters by both the ISO code and the session language:

  • SELECT name, description FROM fnd_iso_languages_tl WHERE iso_language_3 = :p_code AND language = userenv('LANG');
  • Reporting available translations for one code: SELECT language, name FROM fnd_iso_languages_tl WHERE iso_language_3 = 'ENG' ORDER BY language;
  • Confirming translation coverage by comparing distinct LANGUAGE values against FND_LANGUAGES.

Reporting scenarios commonly join this table to the base FND_ISO_LANGUAGES to combine code-level attributes with translated text, and to FND_LANGUAGES to resolve language descriptions. Because translation rows exist only for installed or seeded languages, queries should tolerate missing rows by using outer joins and defaulting to the base-language text.

Related Objects

  • FND_ISO_LANGUAGES — The base (non-translated) table; join on ISO_LANGUAGE_3 to obtain language-independent attributes alongside translated text.
  • FND_LANGUAGES and FND_LANGUAGES_TL — Provide the description and installed-language context for the LANGUAGE column.
  • FND_TERRITORIES_TL — Parallel translation table used together with ISO languages in territory/language combination lookups.
  • FND_LANGUAGE and FND_ISO_LANGUAGES_VL — The view layer that exposes base and translated columns as a single logical entity; application code typically queries the VL view rather than the TL table directly.
  • FND_SESSION / USERENV('LANG') — The runtime source of the language code used to filter translation rows for the current session.

Writers should query the _VL view for display purposes and restrict direct DML on the _TL table to seeded data maintenance or controlled patches, respecting the ZD_EDITION_NAME editioning column in 12.2 environments.