Search Results fnd_iso_languages_tl_u1

Overview

APPLSYS.FND_ISO_LANGUAGES_TL is the translation (TL) table for the FND_ISO_LANGUAGES entity within the Oracle E-Business Suite APPLSYS schema. It stores the language-dependent display attributes — the language name and description text — for each ISO-639-2 alpha-3 language code registered in the base table. The table resides in the APPS_TS_SEED tablespace, reflecting its role as seeded reference data shipped with the EBS installation rather than transactional or user-entered content. Its FND design data identifier is FND.FND_ISO_LANGUAGES_TL, and its status is VALID.

Because the base FND_ISO_LANGUAGES row is language-neutral, this table exists to hold the translatable text columns keyed by both the ISO language code and the runtime language of the EBS session. The ETRM relationship metadata classifies the object heuristically as standalone, which suggests that, under a Data Vault modeling approach, the table would be treated as a standalone satellite-like structure rather than a hub or link: its natural key is compounded from the parent code plus a language discriminator, and it carries descriptive attributes rather than relationships to other entities.

Key Information Stored

The table's documented physical schema comprises 11 columns. The most significant are:

• ISO_LANGUAGE_3 — the language code based on ISO-639-2 alpha-3 codes (Terminology). This is the core business identifier inherited from the base table.
• LANGUAGE — the EBS language code, corresponding to FND_LANGUAGES.LANGUAGE_CODE; it determines which translation row is returned for a given session language.
• NAME — VARCHAR2(80); the language name presented for display purposes.
• DESCRIPTION — VARCHAR2(240); the language description based on the ISO-639-2 language name.
• SOURCE_LANG — the language the text mirrors; when a translation does not yet exist for LANGUAGE, changes to the source-language row are reflected here.
• ZD_EDITION_NAME — VARCHAR2(30); the edition discriminator used in EBS online patching (Editioning), allowing multiple editions of the same row to coexist during the patch cycle.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Who columns capturing creation and last-modification audit information.

The documented primary key is FND_ISO_LANGUAGES_TL_PK over (ISO_LANGUAGE_3, LANGUAGE). Two unique indexes act as business-key candidates: U1 on (ISO_LANGUAGE_3, LANGUAGE, ZD_EDITION_NAME) and U2 on (DESCRIPTION, LANGUAGE, ZD_EDITION_NAME). Because ZD_EDITION_NAME participates in both unique keys, row uniqueness is effectively scoped by patch edition, which is fundamental to querying the table correctly in an AD/TXK edition-based environment.

Common Use Cases and Queries

Typical uses include validating that language codes are defined, driving LOVs and display of language names in Oracle Forms-based EBS responsibilities, and reporting on the available seeded languages. A common pattern is to join the table to the session language code to retrieve the appropriate NAME and DESCRIPTION. Because editioning is in force, queries should constrain or filter on ZD_EDITION_NAME to return a single logical edition. A representative query:

SELECT ISO_LANGUAGE_3, LANGUAGE, NAME, DESCRIPTION FROM APPLSYS.FND_ISO_LANGUAGES_TL WHERE LANGUAGE = :session_lang AND ZD_EDITION_NAME = 'SET1';

The seeded ISO-639-2 alpha-3 codes and descriptions are also frequently extracted for interface and integration loads that require standardized language naming rather than internal EBS codes. Reports listing language names may additionally join FND_LANGUAGES on LANGUAGE to obtain installed-language attributes.

Related Objects

The most significant related objects and dependencies are:

• APPLSYS.FND_ISO_LANGUAGES — the base language-neutral table; FND_ISO_LANGUAGES_TL translates its rows and shares the ISO_LANGUAGE_3 key.
• FND_LANGUAGES — source of LANGUAGE codes and installed-language metadata, joinable on FND_ISO_LANGUAGES_TL.LANGUAGE = FND_LANGUAGES.LANGUAGE_CODE.
• FND_ISO_LANGUAGES_TL# — the documented editioning (AD/TXK) companion object that references this table.
• FND_ISO_LANGUAGES_TL_PK — the primary key constraint over (ISO_LANGUAGE_3, LANGUAGE).
• The translation infrastructure and the FND translation APIs, which populate and maintain the TL rows using SOURCE_LANG as the mirror reference.

Direct foreign keys from this table to other objects are not documented; instead it is referenced by the editioning number object listed above.