Results for “master_config_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AHL_UC_HEADERS_H is the history table for AHL_UNIT_CONFIG_HEADERS within the Oracle E-Business Suite AHL (Complex Maintenance Repair and Overhaul) module. It preserves the state of each unit configuration header across successive revisions, capturing every change made to the parent record so that a complete audit trail of configuration evolution is retained. This design is characteristic of Oracle's "_H" history tables: the transactional table holds only the current row per entity, while the history table accumulates one row per version, distinguished by a version number rather than overwritten in place.

Unit configurations represent the as-maintained structure and composition of a tracked asset or assembly in the context of complex MRO operations, tying a configuration to a specific item instance and linking parent configurations into hierarchies. The history table therefore plays a central role in configuration-change auditing, lifecycle reporting, and point-in-time reconstruction of what a unit's configuration looked like at any given date.

Under the heuristic Data Vault classification mined from the foreign-key structure, this object is modeled as a link. This suggestion reflects its role in associating a header identity with its versioned history and in connecting the configuration to related entities such as master configurations and item instances, rather than behaving as a standalone hub of a fixed business key.

Key Information Stored

The documented schema contains 33 columns. The most significant are as follows:

• UNIT_CONFIG_HEADER_ID — Identifier of the unit configuration header. Together with VERSION_NO it forms the composite primary key (AHL_UC_HEADERS_H_PK) and the unique business-key candidate AHL_UC_HEADERS_H_U1.
• VERSION_NO — The version sequence for the header, distinguishing each historical snapshot of the same configuration.
• OBJECT_VERSION_NUMBER — Optimistic-locking column standard to Oracle EBS, supporting concurrent update control.
• NAME — Descriptive name of the unit configuration at that version.
• MASTER_CONFIG_ID — Reference to the master configuration (AHL_MC_HEADERS_B) that governs this unit configuration.
• CSI_ITEM_INSTANCE_ID — Reference to the item instance (CSI_ITEM_INSTANCES) the configuration applies to.
• PARENT_UC_HEADER_ID — Self-referencing link to the parent unit configuration header, enabling hierarchical configuration structures.
• UNIT_CONFIG_STATUS_CODE — Status of the unit configuration for the versioned record.
• ACTIVE_UC_STATUS_CODE, ACTIVE_START_DATE, ACTIVE_END_DATE — Effective-dating attributes describing when the configuration was active.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, governing data access through Oracle's multi-organization security model.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard audit columns identifying who created and modified each historical row and when.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — The DFF (descriptive flexfield) segments for extensible, customer-defined configuration.

Common Use Cases and Queries

The primary use case is configuration-change auditing: retrieving the full version history of a given unit configuration, ordered by version, to determine what changed and when.

• Full history of a configuration: SELECT UNIT_CONFIG_HEADER_ID, VERSION_NO, NAME, UNIT_CONFIG_STATUS_CODE, LAST_UPDATE_DATE, LAST_UPDATED_BY FROM AHL.AHL_UC_HEADERS_H WHERE UNIT_CONFIG_HEADER_ID = :id ORDER BY VERSION_NO;
• Latest historical version: join on a subquery or analytic function using ROW_NUMBER() OVER (PARTITION BY UNIT_CONFIG_HEADER_ID ORDER BY VERSION_NO DESC) to isolate the most recent snapshot.
• Point-in-time reconstruction: filter on ACTIVE_START_DATE and ACTIVE_END_DATE to identify which configuration version was effective on a given date.
• Change attribution: group by LAST_UPDATED_BY and TRUNC(LAST_UPDATE_DATE) to report which users modified configurations over a period.

Related Objects

• AHL_UNIT_CONFIG_HEADERS — The primary (current) table; joined on UNIT_CONFIG_HEADER_ID, and referenced again through PARENT_UC_HEADER_ID for hierarchy.
• AHL_MC_HEADERS_B — Master configuration header; joined via MASTER_CONFIG_ID.
• CSI_ITEM_INSTANCES — Item instance master; joined via CSI_ITEM_INSTANCE_ID to resolve the tracked asset.
• FND_SECURITY_GROUPS — Security group definition; joined via SECURITY_GROUP_ID for access control reporting.
• AHL_UC_HEADERS_H_PK / AHL_UC_HEADERS_H_U1 — Primary-key constraint and unique index defining row uniqueness on (UNIT_CONFIG_HEADER_ID, VERSION_NO).