Search Results map_ahl_eam_op_rec

Overview

APPS.AHL_EAM_JOB_PVT is a private (PVT) PL/SQL package within the Oracle Enterprise Asset Management (eAM) and Asset Lifecycle Management (AHL) product family. Its role is to map Oracle eAM work order structures into the AHL Production Process (AHL_PP) data model. In Oracle EBS, the AHL schema supports maintenance, repair, and overhaul (MRO) execution logic, while eAM provides the underlying work order, operation, material, and resource constructs. This package bridges the two by translating eAM work order records—work orders, operations, material requirements, and resource assignments—into the AHL_PP representation used by production and visit task processing.

The package is classified as PVT, indicating it is an internal implementation package rather than a public API. As such, it is intended for consumption by other AHL_PP packages and by eAM integration routines, not for direct invocation by external customizations. Its status is documented as VALID in the ETRM 12.2.2 metadata, and it is owned by the APPS schema.

Key Procedures and Functions

The metadata documents thirteen procedures and functions. The MAP_AHL_EAM_* procedures perform the core mapping of eAM records into AHL structures: MAP_AHL_EAM_WO_REC maps a work order record, MAP_AHL_EAM_WO_REL_REC maps a work order release record, MAP_AHL_EAM_OP_REC maps an operation record, MAP_AHL_EAM_MAT_REC maps a material requirement record, MAP_AHL_EAM_RES_REC maps a resource record, and MAP_AHL_EAM_RES_INST_REC maps a resource instance record.

The processing procedures orchestrate the business flow. UPDATE_JOB_OPERATIONS updates job operation data; PROCESS_MATERIAL_REQ processes material requirements; PROCESS_RESOURCE_REQ processes resource requirements; PROCESS_RESOURCE_ASSIGN processes resource assignments; CREATE_EAM_WORKORDER creates an eAM work order; PROCESS_EAM_WORKORDERS drives work order processing across the mapped structures; and MOVE_WORKORDER moves a work order through its lifecycle states. Parameter signatures are not documented in the ETRM excerpt and should not be assumed.

Tables Accessed

The package references several tables through APPS synonyms. AHL_UE_RELATIONSHIPS and AHL_UNIT_EFFECTIVITIES_B support unit effectiveness and relationship logic that governs which maintenance activities apply to an asset. AHL_VISIT_TASKS_B stores visit task definitions associated with maintenance execution. WIP_DISCRETE_JOBS connects the AHL mapping to the Oracle Work in Process work order model used by eAM. DUAL supports standard PL/SQL expression evaluation. PLITBLM is the PL/SQL intercommunication table buffer used for bulk data passing. UTL_FILE supports file I/O, likely for logging or intermediate data exchange, and V$PARAMETER is queried to read database initialization parameters. The package also depends on AHL_PP_MATERIALS_PVT, AHL_PP_RESRC_ASSIGN_PVT, AHL_PP_RESRC_REQUIRE_PVT, AHL_PRD_OPERATIONS_PVT, AHL_PRD_WORKORDER_PVT, EAM_PROCESS_WO_PUB, and FND_API.

Usage Notes

Because AHL_EAM_JOB_PVT is a PVT package, it is normally invoked indirectly. Reference metadata shows it is referenced by five other packages, including AHL_PP_MATERIALS_PVT, AHL_PP_RESRC_ASSIGN_PVT, AHL_PP_RESRC_REQUIRE_PVT, AHL_PRD_OPERATIONS_PVT, and AHL_PRD_WORKORDER_PVT. A user searching for "ahl_pp_materials_pvt" reaches this object precisely through that dependency chain: AHL_PP_MATERIALS_PVT depends on AHL_EAM_JOB_PVT for material requirement mapping.

In practice, these routines are triggered during eAM work order creation, release, and execution—typically from eAM forms, concurrent programs that process work orders, or higher-level AHL_PP processing packages. Custom code should not call this package directly; instead, use documented public APIs such as EAM_PROCESS_WO_PUB or the public entry points of the referencing AHL_PP packages.