Search Results entity_occurance_code




Overview
Explore in AI Chat

Overview

AZ_SELECTION_SET_ENTITIES_TL is a translation (TL) table in the AZ – Application Implementation product of Oracle E-Business Suite. It stores the language-specific, translated names for the entities that comprise a selection set — the reusable groupings of application implementation entities (such as business processes, functions, or setup data) used by Oracle Application Implementation and related EBS tooling. Each row represents one entity occurrence within a selection set, in one language, for one owning user context.

The table's translated attribute is ENTITY_OCCURANCE_NAME, the display name shown to end users; the untranslated base record resides in the corresponding non-TL table AZ_SELECTION_SET_ENTITIES_B. Both tables share the same composite key so translations can be resolved by joining on SELECTION_SET_CODE, USER_ID, ENTITY_OCCURANCE_CODE, and LANGUAGE.

Under the heuristic Data Vault classification supplied with the ETRM metadata, this object is marked standalone. As a modeling suggestion, it is best treated as a satellite (or reference/lookup table) attached to the selection set entity business key, because it carries descriptive, language-dependent attributes (SOURCE_LANG, ENTITY_OCCURANCE_NAME) plus standard audit columns, rather than acting as a pure hub or a link between independent hubs.

Key Information Stored

  • SELECTION_SET_CODE — identifies the parent selection set; part of the composite primary key and a core business-key component.
  • USER_ID — the user (owner) context that scopes the selection set; part of the primary key.
  • ENTITY_OCCURANCE_CODE — the internal code identifying the specific entity occurrence inside the selection set; part of the primary key and the column most commonly referenced in searches.
  • LANGUAGE — the language of this translated row; part of the primary key and the driver of TL resolution.
  • ENTITY_OCCURANCE_NAME — the translated display name of the entity occurrence; this is the principal payload of the TL table.
  • SOURCE_LANG — the language in which the source/base row was authored, used by the translation framework.
  • ZD_EDITION_NAME — the editioning column that supports EBS online patching (ADOP) and edition-based redefinition; it appears in the unique index and is essential in 12.2.x.
  • CREATED_BY / CREATION_DATE — standard audit trail capturing row creation.
  • LAST_UPDATED_BY / LAST_UPDATE_DATE / LAST_UPDATE_LOGIN — standard audit trail capturing the most recent change and session context.

The primary key is AZ_SEL_SET_ENTITIES_TL_PK (SELECTION_SET_CODE, USER_ID, ENTITY_OCCURANCE_CODE, LANGUAGE). A second unique index, AZ_SELECTION_SET_ENTITIES_TL, extends that key with ZD_EDITION_NAME, confirming the edition dimension in 12.2.2. No surrogate single-column primary key is documented; the key is entirely business-derived. The table contains 12 documented columns.

Common Use Cases and Queries

The most frequent pattern is resolving the translated name for selection set entities, typically joining to the base table and filtering on language:

  • Language-specific lookup — retrieving ENTITY_OCCURANCE_NAME for a known entity occurrence and language to display in a UI or report.
  • Translation coverage reporting — identifying entity occurrences that lack a row for a target LANGUAGE, highlighting untranslated content.
  • Edition-aware queries — filtering on ZD_EDITION_NAME when querying across patch editions in 12.2.2 environments.
  • Audit queries — using LAST_UPDATE_DATE and LAST_UPDATED_BY to trace who modified a translation and when.

A representative query joining the TL and base tables might select SELECTION_SET_CODE, ENTITY_OCCURANCE_CODE, and ENTITY_OCCURANCE_NAME from AZ_SELECTION_SET_ENTITIES_TL where SELECTION_SET_CODE = :code and LANGUAGE = USERENV('LANG'), ordering by ENTITY_OCCURANCE_CODE. A coverage query would use a NOT EXISTS subquery against the TL table for a specified LANGUAGE. Because the row set is scoped by USER_ID, queries should generally include it to avoid spanning multiple owners' selection sets.

Related Objects

  • AZ_SELECTION_SET_ENTITIES_B — the base (non-translated) table sharing the same composite key; the primary join partner.
  • AZ_SELECTION_SETS_TL — translation table for the parent selection set, joinable via SELECTION_SET_CODE and LANGUAGE.
  • AZ_SELECTION_SETS_B — base table for the selection set header, providing selection set attributes by SELECTION_SET_CODE.
  • FND_LANGUAGES — validates and describes the LANGUAGE and SOURCE_LANG values.
  • FND_USER — resolves the USER_ID owner reference to a user account.
  • AZ_SELECTION_SET_ENTITIES_VL — the translated view layered over the base and TL tables, typically the preferred query surface for applications and reports.

Where foreign keys are documented as absent, the relationships above are conventional joins on the shared composite key components and standard EBS lookup columns rather than enforced referential constraints.