Search Results az_selection_sets_tl_pk

Overview

AZ_SELECTION_SETS_TL is a translation (TL) table owned by the AZ schema, within the Application Implementation product family in Oracle E-Business Suite 12.1.1 and 12.2.2. Selection sets are reusable groupings of application entities — responsibilities, functions, menus, request groups, and similar objects — that drive the configuration wizards and setup flows in the Application Implementation module. The _TL suffix denotes the multilanguage layer: for every selection set definition, one row exists per installed language, allowing the selection set name and description to be presented in the user's session language while the base record remains language-independent.

From a Data Vault modeling perspective, the mined relationship data classifies this object as standalone, meaning it carries no foreign key dependencies on other tables in the documented schema. A heuristic Data Vault classification would therefore treat it as a satellite-style descriptive structure attached to a selection set business key, carrying the translated name and description attributes rather than acting as a hub or link between distinct business entities. This is a modeling suggestion derived from the observed key structure, not an Oracle-defined classification.

Key Information Stored

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

• SELECTION_SET_CODE — the business identifier for the selection set; part of both the primary key and the unique index.
• USER_ID — the owning user for the selection set definition; participates in the primary key, indicating that selection sets are scoped per user.
• LANGUAGE — the language code for the translated row, also part of the primary key.
• SOURCE_LANG — the language in which the base record was originally entered, used by the translation framework to determine whether re-translation is required.
• SELECTION_SET_NAME — the translated display name shown to end users.
• SELECTION_SET_DESC — the translated description of the selection set's purpose.
• ZD_EDITION_NAME — the editioning column supporting Oracle's Edition-Based Redefinition (EBR), present in the 12.2.x schema and included in the unique index.
• CREATED_BY / CREATION_DATE / LAST_UPDATED_BY / LAST_UPDATE_DATE / LAST_UPDATE_LOGIN — the standard WHO audit columns capturing row provenance and last modification context.

The surrogate primary key is defined by AZ_SELECTION_SETS_TL_PK on the composite of SELECTION_SET_CODE, USER_ID, and LANGUAGE. A second unique index, AZ_SELECTION_SETS_TL_U1, extends that set with ZD_EDITION_NAME, making it the strongest business-key candidate once editioning is considered.

Common Use Cases and Queries

Typical usage centers on resolving a selection set code into a localized label for reporting, migration validation, or setup diagnostics. A standard multilingual lookup retrieves the base row plus the desired translation:

• Retrieve the translated name for a given code and language: SELECT selection_set_name FROM az.az_selection_sets_tl WHERE selection_set_code = :code AND language = USERENV('LANG');
• Detect missing translations by comparing the count of SELECTION_SET_CODE values against the language rows where LANGUAGE != SOURCE_LANG.
• Audit recently modified definitions using LAST_UPDATED_BY and LAST_UPDATE_DATE filtered against a reporting window.
• Join to the base (non-TL) selection set table on SELECTION_SET_CODE, USER_ID, and ZD_EDITION_NAME to produce a fully resolved configuration report.

Because the table is standalone, these queries require no additional join paths once the base selection set table is identified.

Related Objects

The documented metadata shows no enforced foreign keys from this table, so related objects are inferred from the shared business key and the AZ module's dependency graph. The most significant are:

• AZ_SELECTION_SETS (base table) — joined on SELECTION_SET_CODE, USER_ID, and ZD_EDITION_NAME; holds the language-independent definition.
• AZ_SELECTION_SET_MEMBERS — the membership detail rows listing the entities included in each selection set.
• AZ_SELECTION_SET_CRITERIA — stores the filtering criteria attached to a selection set.
• FND_LANGUAGES — validates LANGUAGE and SOURCE_LANG against installed languages.
• FND_USER — resolves USER_ID to the owning application user.
• FND_APPLICATION / FND_RESPONSIBILITY — frequently enumerated as selection set members and referenced through the membership tables.

These relationships are joined on the documented key columns and should be validated against the specific patch level in use, since the AZ schema is revised across 12.1.1 and 12.2.2.