Results for “ahl_operation_resources_u1”

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

Overview

AHL.AHL_OPERATION_RESOURCES is a transactional table in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 codelines, owned by the AHL schema — the product schema associated with Oracle Complex Maintenance, Repair, and Overhaul (CMRO), formerly Enterprise Asset Management for Maintenance. The table stores information about job operation resources, capturing the individual resource assignments that belong to a specific work order or job operation. In practical terms, it is the child detail table that records how resources (labor, equipment, or services defined in BOM_RESOURCES) are allocated to operations within a work order, together with quantities, durations, and scheduled windows for each allocation.

The ETRM metadata classifies this object heuristically as satellite-leaning within a Data Vault model. This is a modeling suggestion: the table behaves primarily as a descriptive detail attached to its parent operations, with a surrogate key and standard Who columns typical of EBS transactional satellites. It carries its own non-key business attributes (quantity, duration, schedules) that describe a single resource-per-operation fact rather than defining an independent hub.

Key Information Stored

The primary key of the table is OPERATION_RESOURCE_ID, a NUMBER column and the surrogate identifier for each resource assignment row. The unique index AHL_OPERATION_RESOURCES_U1 is documented on the same column; although it is listed as NONUNIQUE in the storage details, it is treated here as the business-key candidate for the row identity.

• RESOURCE_ID — foreign key to BOM_RESOURCES, identifying the actual resource (labor, machine, or service) assigned.
• WORKORDER_OPERATION_ID — foreign key to AHL_WORKORDER_OPERATIONS, the parent operation to which the resource belongs.
• RESOURCE_SEQUENCE_NUM — ordering of the resource within the operation.
• QUANTITY and DURATION — the numeric amount of resource and the time duration consumed by the assignment.
• SCHEDULED_START_DATE and SCHEDULED_END_DATE — the planned execution window for the resource on the operation.
• OBJECT_VERSION_NUMBER — optimistic locking sequence used by the OC4J/ADF middle tier to prevent concurrent update conflicts.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — the standard EBS Who columns for auditing.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, supporting application hosting and multi-tenant partitioning.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the descriptive flexfield (DFF) structure and segment columns for customer extension.
• RT_OPER_RESOURCE_ID — an additional resource identifier column carried in the documented 12.2.2 schema.

Common Use Cases and Queries

Typical reporting scenarios include resource loading per work order operation, capacity and utilization analysis, and schedule adherence reporting. A common pattern joins the table to its parent operation and to the resource definition:

• Resource assignments for a given operation: SELECT OPERATION_RESOURCE_ID, RESOURCE_ID, QUANTITY, DURATION, SCHEDULED_START_DATE, SCHEDULED_END_DATE FROM AHL_OPERATION_RESOURCES WHERE WORKORDER_OPERATION_ID = :p_op_id ORDER BY RESOURCE_SEQUENCE_NUM;
• Resource utilization: aggregate QUANTITY and DURATION grouped by RESOURCE_ID joined to BOM_RESOURCES.
• Schedule variance: compare SCHEDULED_START_DATE/SCHEDULED_END_DATE against executed transactions in AHL_WO_OPERATIONS_TXNS.
• Concurrent-update diagnostics: filter on OBJECT_VERSION_NUMBER when troubleshooting "record has been modified" errors.
• DFF reporting: join ATTRIBUTE_CATEGORY to FND_DESCR_FLEX_CONTEXTS to resolve segment meanings.

Related Objects

• AHL_WORKORDER_OPERATIONS — parent operation; join on WORKORDER_OPERATION_ID.
• BOM_RESOURCES — resource master; join on RESOURCE_ID.
• FND_SECURITY_GROUPS — security group; join on SECURITY_GROUP_ID.
• AHL_WORK_ASSIGNMENTS — referencing child table; join on OPERATION_RESOURCE_ID.
• AHL_WO_OPERATIONS_TXNS — transaction history referencing the same column, useful for actual-versus-plan comparisons.