Search Results az_selection_sets_tl_u1

Overview

The table AZ.AZ_SELECTION_SETS_TL is a multi-lingual (translation) table within the Oracle E-Business Suite AZ schema, which underpins the Application Technology stack used by ETRM and related modules for storing user-defined selection sets. Its documented role is to store translated and language-specific information for the base AZ_SELECTION_SETS entity, holding the selection set name and description in each installed language alongside the owning user identifier.

The object is classified in the ETRM metadata as VALID and resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10. From a data-vault modeling perspective, the heuristic classification is standalone; because no foreign-key references are documented, the table can be modelled as an independent satellite-style store keyed by business attributes rather than as a hub or link. The presence of translation columns (LANGUAGE, SOURCE_LANG) and a language-aware unique key reinforces its role as a descriptive, attribute-bearing structure.

Key Information Stored

The table contains 12 documented columns. The most significant attributes are:

• SELECTION_SET_CODE (VARCHAR2 45) — the business identifier for the selection set; part of the primary key and unique index.
• USER_ID (NUMBER 15) — the owner of the selection set; part of the primary key, allowing per-user personalization.
• LANGUAGE — the language of the translated row; completes the primary key.
• SOURCE_LANG — the language from which the translation originated.
• SELECTION_SET_NAME (VARCHAR2 45) — the translated display name of the selection set.
• SELECTION_SET_DESC (VARCHAR2 1800) — the translated long description.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.
• ZD_EDITION_NAME (VARCHAR2 30) — the edition discriminator supporting edition-based redefinition and the unique index.

The documented primary key is AZ_SELECTION_SETS_TL_PK (SELECTION_SET_CODE, USER_ID, LANGUAGE). The unique index AZ_SELECTION_SETS_TL_U1 (SELECTION_SET_CODE, USER_ID, LANGUAGE, ZD_EDITION_NAME) serves as the business-key candidate, extending the primary key with the edition name to guarantee one translated row per selection set, user, language, and edition.

Common Use Cases and Queries

Typical usage involves retrieving the localized name and description for a user's selection set, or auditing which users have defined selection sets and in which languages. A common reporting pattern joins the translation table to the base entity by SELECTION_SET_CODE and USER_ID while filtering on LANGUAGE to return a single localized row.

Representative query patterns include:

• Retrieving localized metadata: SELECT SELECTION_SET_NAME, SELECTION_SET_DESC FROM AZ.AZ_SELECTION_SETS_TL WHERE SELECTION_SET_CODE = :code AND USER_ID = :user AND LANGUAGE = USERENV('LANG');
• Inventory of translated rows grouped by LANGUAGE to verify multi-lingual coverage.
• Audit reporting using CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE to track change history.

Because the table is documented as a standalone object with no referencing dependencies, queries are typically driven by joining on the shared business columns rather than navigated through foreign keys.

Related Objects

The metadata documents that AZ.AZ_SELECTION_SETS_TL does not reference any database object, and that it is referenced only by the internal object AZ_SELECTION_SETS_TL#. Consequently, the most significant related objects are:

• AZ.AZ_SELECTION_SETS_TL# — the internal dependent object generated for the translation table.
• AZ.AZ_SELECTION_SETS — the base (non-translated) selection set entity, related by SELECTION_SET_CODE and USER_ID.
• The APPS user/FND user directory — associated with USER_ID and the WHO audit columns.
• FND_LANGUAGES — the reference source for valid values of LANGUAGE and SOURCE_LANG.
• FND standard WHO/audit infrastructure — the framework that populates CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and related columns.

These objects collectively support the maintenance, translation, and consumption of selection set definitions across the Oracle EBS environment.