Search Results ahl_resource_mappings_pk

Overview

The AHL_RESOURCE_MAPPINGS table is a critical integration object within the Oracle E-Business Suite (EBS) module for Complex Maintenance, Repair, and Overhaul (AHL). Its primary role is to establish and maintain a formal mapping relationship between resources defined in the Advanced Supply Chain Planning (ASCP/ASO) context and those defined in the Bills of Material (BOM) application. This mapping is essential for ensuring data consistency and process flow when planning and executing complex service and maintenance operations, where resource requirements must be synchronized between planning engines and detailed manufacturing or repair execution systems.

Key Information Stored

The table's core function is to store a one-to-one link between two key resource identifiers. The central column is the system-generated primary key, RESOURCE_MAPPING_ID. The two critical foreign key columns define the relationship: ASO_RESOURCE_ID stores the identifier for the resource as defined within the ASCP/ASO planning environment, while BOM_RESOURCE_ID stores the identifier for the corresponding resource in the BOM_RESOURCES table. This structure allows the system to correctly translate resource requirements and assignments between the high-level planning domain and the detailed execution domain.

Common Use Cases and Queries

A primary use case is during the execution of a planned maintenance work order, where the system needs to identify the specific shop floor resource (BOM) required to fulfill a resource need identified during planning (ASO). This table is queried to facilitate this translation. Common reporting and validation queries include identifying all established mappings or finding unmapped resources which may cause process failures. A typical SQL pattern to retrieve the mapping details with resource names would be:

• SELECT arm.resource_mapping_id,
• aso.resource_code aso_resource_code,
• bom.resource_code bom_resource_code
• FROM ahl_resource_mappings arm,
• ahl_resources aso,
• bom_resources bom
• WHERE arm.aso_resource_id = aso.resource_id
• AND arm.bom_resource_id = bom.resource_id;

Related Objects

The AHL_RESOURCE_MAPPINGS table sits at the intersection of two major resource master tables, as defined by its documented foreign key constraints. It has a direct foreign key relationship to AHL_RESOURCES via the ASO_RESOURCE_ID column. Simultaneously, it has a foreign key relationship to the foundational manufacturing table BOM_RESOURCES via the BOM_RESOURCE_ID column. The table's primary key constraint, AHL_RESOURCE_MAPPINGS_PK, is defined on the RESOURCE_MAPPING_ID column, which is likely referenced by other AHL process-specific tables or views that need to utilize this mapping relationship.