Results for “fnd_objects_tl”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FND_OBJECTS_TL is the object translation subtable belonging to the FND — Application Object Library product in Oracle E-Business Suite. It is owned by the APPLSYS schema and holds the language-specific, translated attributes for the metadata objects registered in the base FND_OBJECTS table. Where FND_OBJECTS stores the language-independent definition of an application object (such as a form, concurrent program, function, or menu), FND_OBJECTS_TL supplies the display name and description rendered in each installed language. The "_TL" suffix follows the standard EBS multilingual naming convention, indicating a translated (language-dependent) companion table keyed by a language code.

Based on the documented foreign-key structure, the heuristic Data Vault classification for this object is satellite-leaning. In Data Vault modeling terms, this suggests treating FND_OBJECTS_TL as a satellite hanging off the FND_OBJECTS hub, with OBJECT_ID acting as the hub reference and LANGUAGE as part of the descriptive context. This classification is a modeling suggestion only, derived from the mined FK relationships, not an EBS-declared characteristic.

Key Information Stored

The table contains eleven documented columns. The most significant are:

• OBJECT_ID — The foreign key linking back to FND_OBJECTS; identifies which base object the translation describes. It forms the leading column of the primary key.
• LANGUAGE — The NLS language code for which the translation applies; the second component of the primary key.
• SOURCE_LANG — Indicates whether the row holds the source-language string or a translated variant, supporting the standard EBS translation workflow.
• DISPLAY_NAME — The translated user-facing name of the object, rendered in the target language.
• DESCRIPTION — The translated descriptive text for the object.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns capturing who created and last modified the row and when.
• ZD_EDITION_NAME — The edition designator supporting online patching in EBS 12.2.x; in 12.1.1 this column is absent.

The surrogate/primary key is defined by FND_OBJECTS_TL_PK on (OBJECT_ID, LANGUAGE). A separate unique index, FND_OBJECTS_TL_U1 on (OBJECT_ID, LANGUAGE, ZD_EDITION_NAME), serves as the business-key candidate under the 12.2.2 editioned data model. The single documented foreign key, FND_OBJECTS_TL.OBJECT_ID → FND_OBJECTS, enforces referential integrity to the base object registry.

Common Use Cases and Queries

Translation tables such as this one are queried whenever reports or extensions must present object metadata in a specific language. A typical pattern joins the translation table to its base via OBJECT_ID filtered by LANGUAGE, for example:

• Retrieving the display name and description for a given object: SELECT t.DISPLAY_NAME, t.DESCRIPTION FROM FND_OBJECTS_TL t WHERE t.OBJECT_ID = :object_id AND t.LANGUAGE = USERENV('LANG');
• Listing all translations of an object: SELECT t.LANGUAGE, t.DISPLAY_NAME FROM FND_OBJECTS_TL t WHERE t.OBJECT_ID = :object_id ORDER BY t.LANGUAGE;
• Joining to the base table for combined language-independent and translated attributes: SELECT o.OBJECT_ID, o.OBJECT_NAME, t.DISPLAY_NAME FROM FND_OBJECTS o, FND_OBJECTS_TL t WHERE o.OBJECT_ID = t.OBJECT_ID AND t.LANGUAGE = 'US';

These patterns are common in localization audits, translation-completeness reports, and diagnostics of user-visible object labels.

Related Objects

• FND_OBJECTS — The base object registry; joined on OBJECT_ID and the definitive parent of FND_OBJECTS_TL.
• FND_OBJECTS_TL_PK / FND_OBJECTS_TL_U1 — The primary key and unique index enforcing row uniqueness by language and edition.
• FND_LANGUAGES — Provides the valid LANGUAGE codes referenced by this table.
• FND_APPLICATION / FND_APPLICATION_TL — Related FND metadata tables sharing the same translation pattern for application-level attributes.