Search Results iso_language_3




Overview
Explore in AI Chat

Overview

FND_ISO_LANGUAGES is a reference table in the Oracle E-Business Suite Application Object Library (FND) product, owned by the APPLSYS schema. Its documented description identifies it as a "Language table based on ISO-649," meaning it stores the language definitions that Oracle EBS uses to identify and present content across the multilingual architecture of Release 12.1.1 and 12.2.2. Rows in this table are used to validate and resolve language codes referenced throughout the applications schema, including the language-independent seed data and the translated (language-dependent) tables maintained under the NLS (National Language Support) framework.

The table's own primary key is FND_ISO_LANGUAGES_PK, defined on the ISO_LANGUAGE_3 column, and a unique index FND_ISO_LANGUAGES_U1 spans ISO_LANGUAGE_3 and ZD_EDITION_NAME. From a heuristic Data Vault modeling perspective, the mined foreign-key structure indicates this object behaves as a standalone reference or lookup table, which in Data Vault terms is best suggested as a hub-like reference entity: it carries no dependencies on other business entities and is referenced by consumers rather than referencing them. The presence of ZD_EDITION_NAME indicates compatibility with the Edition-Based Redefinition (EBR) feature used for online patching in Release 12.2.x.

Key Information Stored

The documented physical schema contains nine columns in APPLSYS. The most significant are:

  • ISO_LANGUAGE_3 — The three-character ISO 649 language code serving as the primary key (FND_ISO_LANGUAGES_PK). This is the value most commonly seen in user searches for "iso_language_3" and is the principal business identifier.
  • ISO_LANGUAGE_2 — The corresponding two-character ISO code, providing a mapping between the three-letter and two-letter numbering schemes. Many external integrations and RFC 3066 language tags rely on the two-letter form.
  • PRIVATE_USE_FLAG — A flag identifying whether the language entry is a private or reserved code rather than a standard ISO designation. This distinguishes supported Oracle languages from customizable or internal-use codes.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — The standard WHO columns tracking row insertion and modification audit information.
  • ZD_EDITION_NAME — The edition identifier supporting Edition-Based Redefinition in 12.2.x; combined with ISO_LANGUAGE_3 in FND_ISO_LANGUAGES_U1 it forms the documented business-key candidate.

The surrogate key is ISO_LANGUAGE_3, while the composite of ISO_LANGUAGE_3 and ZD_EDITION_NAME is the candidate business key exposed through the unique index. The absence of surrogate sequence columns confirms its nature as a natural-key reference table.

Common Use Cases and Queries

Typical uses include resolving a stored three-character code to its two-character equivalent, validating incoming language values, and joining to language-dependent base tables for reporting. A representative query is:

  • Lookup by code: SELECT iso_language_3, iso_language_2, private_use_flag FROM fnd_iso_languages WHERE iso_language_3 = 'ENU';
  • Mapping ISO-649 codes: SELECT iso_language_3, iso_language_2 FROM fnd_iso_languages ORDER BY iso_language_3;
  • Filtering standard entries: SELECT iso_language_3 FROM fnd_iso_languages WHERE private_use_flag = 'N';
  • Edition-aware join (12.2.x): SELECT a.iso_language_3 FROM fnd_iso_languages a, fnd_languages b WHERE a.iso_language_3 = b.language_code AND a.zd_edition_name = 'ORA$BASE';

Reporting use cases include multi-language content reconciliation, NLS configuration audits, and integration mapping tables that convert between Oracle's internal language identifiers and external ISO standards.

Related Objects

The following objects are the most significant references and dependencies based on the primary-key structure and standard Oracle EBS NLS architecture:

  • FND_LANGUAGES — The principal language definition table, joined to FND_ISO_LANGUAGES on the language code columns.
  • FND_LANGUAGE_ISO_MAP — An ISO mapping table used to translate between Oracle language codes and ISO terminology.
  • FND_TERRITORIES — Territory definitions frequently paired with language rows for locale resolution.
  • FND_NLSSORT_ORDER — Language-dependent sort order data referencing language codes.
  • FND_SESSION_ATTRIBUTES — Stores the active language and session attributes for the current user, resolved against the ISO language table.
  • FND_PRODUCT_INSTALLATIONS and FND_NODES — Configuration metadata that depends on language settings in multilingual installations.

These relationships center on ISO_LANGUAGE_3 as the documented join and reference key, reinforcing the table's role as a foundational lookup object within the FND schema.