Search Results fnd_languages

Overview

The FND_LANGUAGES table is a core reference table within the Application Object Library (FND) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. Owned by the APPLSYS schema, it serves as the central repository for defining and managing the national dialects and languages supported by the application. Its primary role is to provide a standardized, system-wide reference for language codes, enabling the EBS architecture to support multilingual installations. This table is fundamental to the translation infrastructure, underpinning the Translated Table (TL) mechanism and user interface (UI) personalization based on language preferences.

Key Information Stored

The table's structure is designed to uniquely identify each supported language. According to the provided metadata, it is constrained by two primary keys: FND_LANGUAGES_PK on the LANGUAGE_CODE column and FND_LANGUAGES_UK2 on the LANGUAGE_ID column. This indicates that both the language code (a short abbreviation like 'US' for American English) and a numeric language ID serve as unique identifiers. While the full column list is not detailed in the excerpt, standard implementations of this table typically include columns for the language name (e.g., 'English'), the territory (e.g., 'AMERICA'), and flags indicating installation status (installed, base language), NLS character set, and directionality (LTR/RTL). The dual-key structure ensures robust referential integrity across the application.

Common Use Cases and Queries

The table is most frequently queried to determine the languages available within an EBS instance or to validate language codes. Common SQL patterns include listing all installed languages for user profile options or reporting, and joining with TL tables to retrieve translated descriptions. For example, a report to show all translated terms for a specific entity would join a TL table (e.g., AP_TERMS_TL) with FND_LANGUAGES on the LANGUAGE column to get the readable language name. A typical administrative query is: SELECT language_code, nls_language FROM apps.fnd_languages WHERE installed_flag IN ('I', 'B'); This returns the codes and names for all actively installed base and secondary languages, which is critical for configuring multilingual functionality.

Related Objects

As evidenced by the extensive foreign key list in the metadata, FND_LANGUAGES is a pivotal parent table referenced by numerous Translated Table (TL) entities and other base tables across various EBS modules. Key relationships include:

• Translation Tables (TL): Tables like AP_TERMS_TL, CS_INCIDENT_STATUSES_TL, and CS_CF_FLOWS_TL reference FND_LANGUAGES via their LANGUAGE and SOURCE_LANG columns to store multiple translations for a single base record.
• Module-Specific Tables: Tables in modules like Advanced Marketing (AMS) and Customer Support (CS) reference it to define language-specific content, such as AMS_CAMPAIGN_SCHEDULES_B.LANGUAGE_CODE and AMS_EVENT_OFFERS_ALL_B.EVENT_LANGUAGE_CODE.
• Profile Options: The user profile option NLS_LANGUAGE is validated against the codes stored in this table.
• APIs: FND_LANGUAGES is integral to the FND_GLOBAL and localization APIs that manage session language settings.

This widespread dependency underscores its foundational role in the EBS globalized data model.