Search Results selection_set_code




Overview
Explore in AI Chat

Overview

AZ_SELECTION_SETS_B is a core configuration table in the Oracle E-Business Suite Application Implementation (AZ) module, which underpins the Oracle Application Framework (OAF) personalization, extensibility, and functional setup infrastructure. The table stores Selection Sets — reusable definitions that describe a filtered or partial scope of records drawn from an underlying application structure. Selection Sets are consumed by Oracle components such as the Functional Administrator, Personalization, and Extensibility frameworks to restrict which rows or regions a given user or process may act upon.

The object resides in the AZ schema, is registered as VALID, and is documented in the ETRM repository for both EBS 12.1.1 and 12.2.2. ETRM confirms a documented physical schema of 15 columns in the 12.2.2 release. From a Data Vault modeling perspective, the heuristic classification mined from the FK structure is standalone. This classification is a modeling suggestion rather than a mandated Oracle design; it implies the table is not a strict hub, link, or satellite in a Data Vault sense, but rather an independent reference and configuration table whose relationships to other objects are expressed through business keys rather than enforced foreign keys.

Key Information Stored

The table is identified by the surrogate and business primary key AZ_SELECTION_SETS_B_PK, composed of SELECTION_SET_CODE and USER_ID. A second unique index, AZ_SELECTION_SETS_B_U1, extends the business key with ZD_EDITION_NAME, confirming that edition-aware uniqueness is enforced at the database level in 12.2.2.

  • SELECTION_SET_CODE — the primary business identifier for the Selection Set; joins to consuming configuration tables.
  • USER_ID — scopes the Selection Set to a specific user; combined with the code forms the primary key.
  • STRUCTURE_CODE — identifies the underlying application structure or entity from which the selection is drawn.
  • PREDEFINED_FLAG — indicates whether the Selection Set is seeded by Oracle or user-defined.
  • SOURCE_INSTANCE — records the originating instance, relevant for cross-instance or cloned configurations.
  • REF_SELECTION_SET_CODE — references a source Selection Set, supporting copy or derivation semantics.
  • ACTIVE — enables or disables the Selection Set without deleting it.
  • HIERARCHICAL_FLAG — indicates whether the selection traverses a hierarchical structure.
  • PARTIAL_SELECTION — distinguishes partial-scope selections from complete ones.
  • ZD_EDITION_NAME — the editioning column supporting EBS 12.2 online patching.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Typical reporting and support scenarios include auditing which users hold active Selection Sets, tracing derived sets back to their reference source, and confirming edition-specific definitions after an online patch cycle.

  • List all active Selection Sets for a user: SELECT selection_set_code, structure_code, partial_selection FROM az.az_selection_sets_b WHERE user_id = :p_user AND active = 'Y';
  • Identify Oracle-seeded versus custom sets: SELECT selection_set_code FROM az.az_selection_sets_b WHERE predefined_flag = 'Y';
  • Trace derivative definitions: SELECT selection_set_code, ref_selection_set_code FROM az.az_selection_sets_b WHERE ref_selection_set_code IS NOT NULL;
  • Edition-aware lookups: filter on ZD_EDITION_NAME when reconciling post-patch behaviour.
  • Change-audit reporting via LAST_UPDATED_BY and LAST_UPDATE_DATE.

Related Objects

Because ETRM classifies this table as standalone, dependencies are primarily logical rather than enforced foreign keys. The following objects are significant in the AZ selection infrastructure and join via the documented columns.

  • AZ_SELECTION_SETS_TL — translated name and description rows, joined on SELECTION_SET_CODE.
  • AZ_SELECTION_CRITERIA — child criteria rows defining the selection filter, joined on SELECTION_SET_CODE.
  • AZ_SELECTION_SET_COLUMNS — attribute projections for the selection, joined on SELECTION_SET_CODE.
  • FND_USER — supplies the user identity joined on USER_ID.
  • FND_APPLICATION and AK_REGIONS — resolve the Structure Code into an application and region context.
  • FND_OBJECTS — the OAF object registry consumed alongside Selection Sets by personalization.

Queries against these objects should always be edition-qualified on 12.2.2 to avoid cross-edition ambiguity.