Search Results fnd_natural_languages_pk

Overview

FND_NATURAL_LANGUAGES is a reference, or lookup, table owned by the APPLSYS schema within the FND – Application Object Library product of Oracle E-Business Suite. It stores the definitive list of natural languages known to an EBS instance, providing the ISO language identity, associated territory, and enablement status that the application layer uses to present and validate language selections. The table is central to multilingual deployments, serving as the authoritative catalog from which language-dependent objects derive their valid values.

In Oracle EBS 12.1.1 and 12.2.2 the table is documented as VALID with a fifteen-character LANGUAGE_CODE key. The ETRM metadata records ten physical columns and two indexes: the primary key constraint FND_NATURAL_LANGUAGES_PK on LANGUAGE_CODE alone, and a unique index FND_NATURAL_LANGUAGES_U1 on the composite of LANGUAGE_CODE and ZD_EDITION_NAME. The presence of ZD_EDITION_NAME reflects the editioning infrastructure introduced in Release 12.2, which permits non-destructive online patching; in 12.1.1 the equivalent column does not exist, so LANGUAGE_CODE alone constitutes the full unique identifier. From a Data Vault modeling perspective, the provided heuristic classifies this object as standalone, suggesting it is best treated as a hub-like reference entity rather than a link or satellite. Its business keys are language and territory codes that change infrequently, and it carries no foreign-key dependencies on transactional data.

Key Information Stored

The LANGUAGE_CODE column anchors the table and constitutes the primary key. It holds the internal EBS language identifier, a value such as US, D, or ZHS, that other language-dependent tables and profile options reference. ISO_LANGUAGE_3 stores the three-letter ISO 639-2/639-3 language code, and ISO_TERRITORY stores the ISO 3166 territory or country designation; together these columns support interoperability with external systems and language-aware exports. ENABLED_FLAG indicates whether a given language is active and selectable at the site, providing a convenient filter for reporting on currently installable languages. The audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN record the standard "who, when" lineage maintained by the Applications Object Library. ZD_EDITION_NAME participates in the unique index and supports the editioning model in 12.2.x. The surrogate versus business-key distinction is important: LANGUAGE_CODE alone is the enforced primary key, while the composite of LANGUAGE_CODE and ZD_EDITION_NAME forms the business-key candidate captured by the unique index.

Common Use Cases and Queries

Typical usage centers on validation, seeding, and reporting. A common pattern is to confirm that a language is enabled before installing a translation patch:

• SELECT language_code, iso_language_3, iso_territory FROM fnd_natural_languages WHERE enabled_flag = 'Y' ORDER BY language_code;
• Resolving a displayed language name to its code for a concurrent program parameter list.
• Auditing which languages were enabled and by whom, using the audit columns.
• Cross-referencing ISO codes when exchanging data with external HR or financial systems.

Because the table is static and small, queries are inexpensive and are frequently embedded in views and lookups rather than executed interactively.

Related Objects

The table underlies many FND language features. The principal related objects include FND_LANGUAGES, which holds installation and translation status keyed by LANGUAGE_CODE; FND_LANGUAGE, the older synonym family; the FND_TERRITORIES reference table, whose mappings parallel ISO_TERRITORY; and the NLS configuration tables such as FND_NLS_INSTALLED_LANGUAGES. Profile option definitions and lookup types that restrict values to valid languages also depend on this table. Application APIs that derive a session's language, including the FND_SESSION management routines and the FND_LANGUAGE API, resolve codes through FND_NATURAL_LANGUAGES. When joining, the reliable predicate is fnd_languages.language_code = fnd_natural_languages.language_code, with ZD_EDITION_NAME included only in 12.2 environments.