Search Results fnd_iso_languages_u1

Overview

APPLSYS.FND_ISO_LANGUAGES is a seed data table in Oracle E-Business Suite Release 12.1.1 and 12.2.2 that stores the master list of languages recognized by the application, based on the ISO-639 family of standards. The table resides in the APPS_TS_SEED tablespace and is registered under FND design data as FND.FND_ISO_LANGUAGES. Its status is VALID, and it functions as the authoritative language reference for the EBS technology stack, supplying the language codes consumed by the NLS (National Language Support) layer, the Applications Object Library, and numerous concurrent programs that render or validate language selections.

From a Data Vault modeling perspective, the heuristic classification for this object is a standalone structure — neither a classic hub, link, nor satellite — because it carries no foreign key dependencies and is not referenced through traditional FK constraints. It is best treated as a reference or lookup dimension whose natural business key is the ISO language code. The dependency metadata confirms that APPLSYS.FND_ISO_LANGUAGES does not reference any database object and is referenced only through the APPS synonym FND_ISO_LANGUAGES.

Key Information Stored

The documented physical schema for Release 12.2.2 reports nine columns, of which the following are materially significant:

• ISO_LANGUAGE_3 — VARCHAR2 column holding the language code based on ISO-639-2 alpha-3 (Terminology) codes, and also used for customer-defined languages. This column is the primary key (FND_ISO_LANGUAGES_PK) and the leading column of unique index FND_ISO_LANGUAGES_U1.
• ISO_LANGUAGE_2 — VARCHAR2 column holding ISO-639-1 alpha-2 language codes, providing the shorter two-character form used in many NLS contexts.
• PRIVATE_USE_FLAG — VARCHAR2 flag (Y or N) indicating whether the row represents a non-ISO-639-2 language, i.e., a customer-defined or private-use language.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Who columns that audit row creation and modification.
• ZD_EDITION_NAME — editioning column present in the 12.2.2 documented schema as part of the unique index FND_ISO_LANGUAGES_U1, supporting the Edition-Based Redefinition (EBR) architecture introduced in Release 12.2.

The documented business-key candidate is the unique index FND_ISO_LANGUAGES_U1, defined over (ISO_LANGUAGE_3, ZD_EDITION_NAME), while the surrogate primary key is FND_ISO_LANGUAGES_PK over ISO_LANGUAGE_3.

Common Use Cases and Queries

The table is most commonly queried to resolve language codes, validate user-entered language selections, and drive multilingual reporting. A typical query joins the table to language-dependent application tables. The cut-and-paste query from the ETRM documentation is:

• SELECT ISO_LANGUAGE_3, ISO_LANGUAGE_2, PRIVATE_USE_FLAG, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN FROM APPLSYS.FND_ISO_LANGUAGES;

Analysts typically filter on PRIVATE_USE_FLAG = 'N' to restrict results to genuine ISO-639-2 languages, and on ISO_LANGUAGE_2 to map between the two- and three-character code sets. Reporting use cases include auditing the set of installed languages against those configured in EBS, reconciling NLS installations, and confirming whether a custom language has been registered as a private-use entry.

Related Objects

Although the metadata records no explicit foreign key relationships, the following objects interact with this table in practice:

• FND_LANGUAGES — the operational language definition table, joined via the language code to obtain the installed language set and NLS configuration.
• FND_LANGUAGE_PAIRS — counterpart pairs used in translation workflows, associated through the language code.
• FND_TERRITORIES — territory definitions cross-referenced when building locale combinations.
• APPS.FND_ISO_LANGUAGES — the APPS synonym through which EBS code references the APPLSYS table.
• FND_NLS_SESSION_PARAMETERS or equivalent NLS session views — consume language codes to establish session language context.
• FND_LANGUAGE_ISO_MAP — where present, maps EBS language identifiers to ISO codes, relying on ISO_LANGUAGE_3.

These objects collectively allow developers and administrators to translate between ISO language standards and the EBS internal language model.