Search Results iso_language_2

Overview

FND_ISO_LANGUAGES_VL is a multilingual (translated) view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It is part of the FND — Application Object Library product and exposes language reference data conforming to the ISO-639 standard (the ETRM description summarizes this as "based on ISO-649"). The view joins the base language table to its translation table so that language name and description are returned in the session's current language, as determined by USERENV('LANG').

Because it presents both the three-character and two-character ISO language codes alongside a session-localized name, the view is the standard reporting and integration source for language lookups in EBS. The user search term iso_language_2 corresponds directly to a column exposed by this view, confirming its relevance to callers looking up two-letter ISO language codes.

Underlying Base Objects

The view is defined over two referenced base objects, both exposed to APPS through synonyms:

• FND_ISO_LANGUAGES — the base (non-translated) table holding the ISO language codes and associated attributes such as PRIVATE_USE_FLAG and standard WHO audit columns.
• FND_ISO_LANGUAGES_TL — the translation table holding the language-dependent NAME and DESCRIPTION.

The join condition links the two on B.ISO_LANGUAGE_3 = T.ISO_LANGUAGE_3, and the translation row is filtered by T.LANGUAGE = USERENV('LANG') so that only the row matching the current session language is returned. The view also exposes the base table's ROWID as ROW_ID.

Key Columns

• ROW_ID — the ROWID of the underlying FND_ISO_LANGUAGES row.
• ISO_LANGUAGE_3 — the three-character ISO language code; this is the primary join key between the base and translation tables.
• ISO_LANGUAGE_2 — the two-character ISO language code, the column matching the user's search term.
• PRIVATE_USE_FLAG — indicates whether the language is a private-use (non-standard) entry.
• NAME / DESCRIPTION — the translated, session-localized language name and description drawn from FND_ISO_LANGUAGES_TL.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS WHO audit columns inherited from the base table.

Common Use Cases and Queries

Typical scenarios include validating or resolving two-letter ISO codes supplied by external interfaces, populating list-of-values queries, and joining to setup or configuration tables that store a language code. A simple lookup by two-character code is:

• SELECT ISO_LANGUAGE_2, ISO_LANGUAGE_3, NAME FROM FND_ISO_LANGUAGES_VL WHERE ISO_LANGUAGE_2 = 'EN';
• SELECT ISO_LANGUAGE_3, ISO_LANGUAGE_2, NAME, DESCRIPTION FROM FND_ISO_LANGUAGES_VL ORDER BY NAME;

Because the view filters on the session language, results are returned in the caller's language, making it suitable for user-facing reports and integration payloads that require localized language names while preserving the stable ISO codes.