Search Results fnd_application_tl




The FND_APPLICATION_TL table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical repository for storing translated application names and descriptions. As part of the Oracle Application Object Library (FND) module, this table supports multilingual functionality by maintaining language-specific labels for applications registered in the system. Below is a detailed analysis of its structure, purpose, and usage within Oracle EBS.

Table Structure

The FND_APPLICATION_TL table is a child table of FND_APPLICATION, which stores the base application definitions. Its columns include:
  • APPLICATION_ID: Foreign key referencing FND_APPLICATION.APPLICATION_ID, uniquely identifying the application.
  • LANGUAGE: The language code (e.g., 'US' for American English) for which the translation is stored.
  • SOURCE_LANG: Indicates the source language of the original record, used for synchronization during translations.
  • APPLICATION_NAME: The translated name of the application (e.g., "General Ledger" in English, "Grand Livre" in French).
  • DESCRIPTION: A translated description of the application's purpose.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE: Standard Oracle audit columns.

Purpose and Functionality

The table enables Oracle EBS to display application names and descriptions in multiple languages, adhering to the NLS (National Language Support) framework. Key functionalities include:
  1. Multilingual Support: Stores translations for applications, ensuring UI elements adapt to user language preferences.
  2. Integration with FND_APPLICATION: Works in tandem with the parent table to provide a complete application definition, combining non-translatable metadata (e.g., application ID) with translatable labels.
  3. Translation Synchronization: The SOURCE_LANG column helps track changes in the base language, ensuring translations remain consistent during updates.

Usage in Oracle EBS

In EBS 12.1.1 and 12.2.2, FND_APPLICATION_TL is leveraged in the following scenarios:
  • User Interface Localization: When a user logs in with a non-English language preference, the system retrieves translated application names from this table for menus, forms, and reports.
  • Seed Data Management: During installation or upgrades, Oracle seed data scripts populate this table with default translations for standard applications (e.g., "Payables," "Receivables").
  • Custom Application Registration: When custom applications are registered using FND_APPLICATION_PKG, corresponding entries must be added to FND_APPLICATION_TL for multilingual support.

Technical Considerations

  1. Indexing: The primary key is a composite of APPLICATION_ID and LANGUAGE, optimizing query performance for language-specific lookups.
  2. API Usage: Direct DML operations on this table are discouraged; instead, Oracle provides PL/SQL APIs like FND_APPLICATION_PKG for safe modifications.
  3. Upgrade Impact: During EBS upgrades, this table may be updated with new translations or corrections, requiring careful testing in multilingual environments.

Example Query

To retrieve French translations for all applications: 
SELECT a.application_short_name, t.application_name, t.description
FROM fnd_application a, fnd_application_tl t
WHERE a.application_id = t.application_id
AND t.language = 'FR';
In summary, FND_APPLICATION_TL is a foundational component of Oracle EBS's globalization architecture, ensuring seamless multilingual experiences across applications. Its design reflects Oracle's commitment to scalability and maintainability in enterprise environments.