Search Results fnd_object_instance_sets_tl_u1

Overview

APPLSYS.FND_OBJECT_INSTANCE_SETS_TL is the translation subtable (the "_TL" suffix denotes translated attributes) for Oracle E-Business Suite object instance sets. It stores the language-specific display names and descriptions associated with an instance set defined in the base FND_OBJECT_INSTANCE_SETS table. Object instance sets are ordered groupings of application object instances that support personalization, menu configuration, and object-level targeting across the EBS application framework, and the translation layer enables multilingual presentation of those groupings.

The object resides in the APPLSYS schema, is marked VALID, and carries the FND design data reference FND.FND_OBJECT_INSTANCE_SETS_TL. It is stored in the APPS_TS_SEED tablespace, consistent with seed or developer-defined configuration data rather than high-volume transactional content, and is partitioned by PCT Free 10. A heuristic Data Vault classification treats this object as a satellite, since it holds descriptive, language-dependent attributes keyed to a parent identifier and carries no independent business relationships of its own.

Key Information Stored

The table is composed of 11 documented columns. The most significant are:

• INSTANCE_SET_ID (NUMBER, 15) — the first component of the composite primary key; the identifier of the parent instance set. This is the logical foreign key linking back to the base table.
• LANGUAGE (VARCHAR2) — the second component of the primary key; the language code identifying the translation. Together with INSTANCE_SET_ID it forms a composite primary key (SYS_C00134090).
• SOURCE_LANG (VARCHAR2) — the source language of the translated row, used by the translation framework to track origin language.
• DISPLAY_NAME (VARCHAR2, 240) — the translated display name shown to end users in the application UI.
• DESCRIPTION (VARCHAR2, 2000) — the translated descriptive text for the instance set.

The remaining columns are the standard audit and editioning attributes: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and ZD_EDITION_NAME. The unique index FND_OBJECT_INSTANCE_SETS_TL_U1 spans INSTANCE_SET_ID, LANGUAGE, and ZD_EDITION_NAME, making these columns the business-key candidate; under editioning, the same instance set may have distinct rows per edition. The surrogate composite key (INSTANCE_SET_ID, LANGUAGE) identifies each translation row, while ZD_EDITION_NAME qualifies it for edition-based redefinition.

Common Use Cases and Queries

Translation tables are queried primarily to resolve locale-specific labels. A common pattern joins the translation to the base table and filters by language so that only the active language context is returned:

• Retrieve the display name and description for a given instance set in a target language.
• Identify instance sets missing a translation for a required language (outer joins against the language list).
• Audit translations for stale or last-updated content using LAST_UPDATE_DATE.

A representative query uses the documented columns directly:

SELECT t.INSTANCE_SET_ID, t.LANGUAGE, t.SOURCE_LANG, t.DISPLAY_NAME, t.DESCRIPTION
FROM APPLSYS.FND_OBJECT_INSTANCE_SETS_TL t
WHERE t.LANGUAGE = 'US'
AND t.INSTANCE_SET_ID = :p_instance_set_id;

Because translations are seed data, reporting is typically low-volume and used for UI validation, metadata extraction, and localization coverage checks rather than operational reporting.

Related Objects

The ETRM dependency data shows this table does not itself reference any database object, and it is referenced only by its editioning companion FND_OBJECT_INSTANCE_SETS_TL#. Relationships are therefore inferred through the shared business key rather than declared foreign keys:

• FND_OBJECT_INSTANCE_SETS — the base (non-translated) table joined on INSTANCE_SET_ID to obtain language-independent attributes.
• FND_OBJECT_INSTANCE_SETS_TL# — the editioning view or companion object referencing this table.
• FND_OBJECT_INSTANCE_SET_MEMBERS — membership table linking instance sets to their member instances, joined on INSTANCE_SET_ID.
• FND_OBJECTS and FND_OBJECT_INSTANCES — the object and instance definitions whose grouped membership the instance set represents.
• FND_LANGUAGES — referenced by the LANGUAGE and SOURCE_LANG columns to validate language codes.

Applications and personalization utilities that resolve object instance sets by name typically join the translation table to these objects to produce user-facing labels.