Search Results fnd_objects_tl




Overview
Explore in AI Chat

Overview

The FND_OBJECTS_TL table is a core Application Object Library (AOL) translation subtable within Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It is owned by the APPLSYS schema and is integral to the application's multilingual architecture. As a translation table, its primary role is to store language-specific textual descriptions for application objects defined in its parent table, FND_OBJECTS. This separation of base data from translatable content enables a single EBS installation to support multiple active languages, allowing users to view object names and descriptions in their preferred language.

Key Information Stored

The table stores translated text for objects registered in the AOL. Its structure is centered on a composite primary key and language-specific columns. The critical columns include OBJECT_ID, which is a foreign key to FND_OBJECTS and identifies the base object being translated. The LANGUAGE column holds the ISO language code (e.g., 'US' for American English) and forms the second part of the primary key. The primary translatable columns are USER_OBJECT_NAME and DESCRIPTION, which hold the translated name and descriptive text for the object, respectively. Additional standard columns like CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN track row history, while SOURCE_LANG denotes the original language in which the data was created.

Common Use Cases and Queries

This table is primarily accessed to retrieve localized user interface text for reports, integrations, and data fixes. A common use case is generating a list of all translated names for a specific object type across languages. Developers often join this table with FND_OBJECTS to get a complete, language-specific view of registered entities. A typical query pattern is:

  • SELECT tl.user_object_name, tl.description, tl.language FROM fnd_objects_tl tl, fnd_objects b WHERE b.object_id = tl.object_id AND b.obj_name = '&OBJECT_NAME' AND tl.language = '&LANG_CODE';

Another frequent scenario involves data correction, where a translation for a specific object in a given language needs to be updated or inserted to resolve UI display issues.

Related Objects

FND_OBJECTS_TL has a direct and essential relationship with its parent table, FND_OBJECTS, via the foreign key on OBJECT_ID. FND_OBJECTS stores the non-translatable attributes of application objects. The table is also closely related to other AOL TL (Translation) tables, such as FND_APPLICATION_TL and FND_DOCUMENTS_TL, which follow the same architectural pattern. Key APIs, like FND_OBJECT_PKG, may reference this table during operations for registering or maintaining application objects in a multilingual environment. Views that present translated object information to other modules will typically join FND_OBJECTS and FND_OBJECTS_TL.