Search Results az_structures_tl_pk

Overview

AZ_STRUCTURES_TL is a translatable (TL) table owned by the AZ schema, which supports the Oracle Application Implementation (Application Object Library) product family. It stores the language-dependent descriptive attributes of structure definitions used within the AZ module, which governs the organization of application implementation structures. The table's core purpose is to hold the human-readable names and descriptions associated with each structure code, resolved per installed language. The _TL suffix indicates that Oracle's multi-language architecture is in effect: the row for a given structure exists once per active language, with LANGUAGE acting as part of the composite identifier.

From a heuristic Data Vault modeling perspective, the ETRM metadata classifies this object as standalone. In practice this suggests the table behaves as a satellite-style descriptive store attached to a structure business key, rather than as a hub or link carrying its own independent relationships. The absence of mined foreign-key relationships reinforces that AZ_STRUCTURES_TL is referenced by, rather than referencing, other AZ entities.

Key Information Stored

The table comprises 11 documented physical columns. The most significant are:

• STRUCTURE_CODE — The business identifier for the structure; part of the primary key.
• LANGUAGE — The NLS language code; the second component of the primary key, ensuring language-specific row uniqueness.
• SOURCE_LANG — The language from which the translated values were originally derived, supporting Oracle's translation-replication model.
• STRUCTURE_NAME — The language-specific display name of the structure.
• STRUCTURE_DESC — The language-specific descriptive text for the structure.
• ZD_EDITION_NAME — The edition discriminator used in Edition-Based Redefinition (EBR); present on the unique index but not the primary key.
• CREATED_BY, CREATION_DATE — Standard Oracle WHO columns recording row creation audit information.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns capturing the most recent modification metadata.

The surrogate primary key is AZ_STRUCTURES_TL_PK (STRUCTURE_CODE, LANGUAGE). A separate unique index, AZ_STRUCTURES_TL_U1 (STRUCTURE_CODE, LANGUAGE, ZD_EDITION_NAME), acts as the business-key candidate and accommodates edition-aware uniqueness in EBR-enabled 12.2.x environments.

Common Use Cases and Queries

Typical usage centers on resolving a structure code to its localized name and description for reporting, setup validation, and configuration migration.

• Retrieving the localized display name for a single structure:

SELECT structure_name, structure_desc
FROM   az.az_structures_tl
WHERE  structure_code = :p_code
AND    language = USERENV('LANG');

• Listing all translated names for a structure across languages, useful for translation-gap analysis.
• Joining to the base AZ_STRUCTURES table (via STRUCTURE_CODE) to combine language-independent attributes with the translated text.
• Auditing recent changes through LAST_UPDATED_BY and LAST_UPDATE_DATE for change-tracking reports.
• Excluding or including rows by ZD_EDITION_NAME when working in an EBR-enabled 12.2.2 instance.

Related Objects

• AZ_STRUCTURES — The base (non-TL) structure definition table; join on STRUCTURE_CODE.
• AZ_STRUCTURES_TL_PK — Primary key constraint enforcing (STRUCTURE_CODE, LANGUAGE).
• AZ_STRUCTURES_TL_U1 — Unique index supporting edition-aware business-key uniqueness.
• FND_LANGUAGES — Validates the LANGUAGE and SOURCE_LANG values.
• FND_APPLICATION / FND_PRODUCT_INSTALLATIONS — Provides product context for the AZ module.
• AZ_STRUCTURE_... dependent tables — Any AZ table keyed by STRUCTURE_CODE depends on the structure definition this TL table describes.