Results for “path_position_id”

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

Overview

The AHL_MC_PATH_POSITIONS table is a core transactional data object within the Oracle E-Business Suite Complex Maintenance Repair and Overhaul (AHL) module. It stores multi-level Maintenance Configuration (MC) positions that describe the hierarchical placement of components within complex assemblies managed through the ETRM (Enterprise Tracking and Repair Management) functionality. In environments running Oracle EBS 12.1.1 or 12.2.2, this table underpins the structured representation of path positions used in route and operation material planning.

From a dimensional modeling perspective, the ETRM metadata classifies this object heuristically as hub-leaning within a Data Vault framework. This suggests that PATH_POSITION_ID functions as a durable business key hub around which satellite attributes and dependent link relationships are organized. The table was designed to be referenced by downstream material and operation records rather than to serve as a pure junction or pure descriptive satellite.

Key Information Stored

The table contains 28 documented columns. The most significant are listed below:

• PATH_POSITION_ID — Surrogate primary key, enforced by AHL_MC_PATH_POSITIONS_PK and mirrored by unique index AHL_MC_PATH_POSITIONS_U1, making it a business-key candidate for direct lookups.
• ENCODED_PATH_POSITION — Alternate unique key enforcing AHL_MC_PATH_POSITIONS_UK1; encodes the hierarchical position for path resolution.
• PATH_POS_COMMON_ID — Reference to the shared/common position definition that this specific path instance instantiates.
• POSITION_REF_CODE — Business reference code identifying the position within operational contexts.
• VER_SPEC_SCORE — Version specification score used during configuration validation and matching.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, controlling row-level access.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the EBS framework for concurrent update control.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns tracking record provenance.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield (DFF) columns enabling customer-specific extensions without schema changes.

Common Use Cases and Queries

Typical usage centers on resolving which operation material records belong to a given path position, or on traversing the encoded hierarchy for reporting. A common query joins the table to its dependent child:

• Retrieve all materials for a position:
  SELECT m.* FROM AHL_RT_OPER_MATERIALS m, AHL_MC_PATH_POSITIONS p WHERE m.POSITION_PATH_ID = p.PATH_POSITION_ID AND p.PATH_POSITION_ID = :id;
• Look up a position by its business key:
  SELECT * FROM AHL_MC_PATH_POSITIONS WHERE ENCODED_PATH_POSITION = :encoded;
• Reporting on security-scoped positions:
  SELECT p.* FROM AHL_MC_PATH_POSITIONS p, FND_SECURITY_GROUPS g WHERE p.SECURITY_GROUP_ID = g.SECURITY_GROUP_ID;

These patterns are commonly used in maintenance workbench extensions, custom OAF pages, and BI Publisher reports where path position hierarchies must be flattened for dashboards.

Related Objects

The following objects interact most significantly with AHL_MC_PATH_POSITIONS:

• AHL_RT_OPER_MATERIALS — References this table via POSITION_PATH_ID; the primary dependent child storing operation materials tied to each position.
• AHL_MC_PATH_POSITIONS_PK / _UK1 / _U1 — Primary and unique constraints defining key integrity.
• FND_SECURITY_GROUPS — Referenced through SECURITY_GROUP_ID for access control.
• AHL_MC_PATH_POS_COMMON (implied by PATH_POS_COMMON_ID) — Shared position definitions referenced by this table.
• ETRM Maintenance Configuration APIs — Standard AHL APIs manipulate rows here during path configuration and versioning.