Search Results ahl_work_assignments_s

Overview

APPS.AHL_PP_RESRC_ASSIGN_PVT is a private PL/SQL package body in the Oracle Enterprise Asset Management (eAM) and Enterprise Territory/Asset Lifecycle (AHL) schema, classified as a PVT (private) API. It supports the resource assignment and scheduling logic within the Oracle Asset Lifecycle Management / production planning (AHL_PP) module. Its principal responsibility is to process resource assignments against work assignments associated with work orders and work order operations, coordinating between work execution entities and manufacturing resource definitions.

The package is not a public interface; it is invoked internally by other packages (referenced by four database objects) and exposes the core logic that other AHL packages delegate to. The dependency list confirms a strong integration with both the AHL work execution stack (AHL_WORKORDERS, AHL_WORKORDER_OPERATIONS, AHL_WORK_ASSIGNMENTS) and the BOM/WIP manufacturing resource stack (BOM_DEPARTMENTS, BOM_DEPARTMENT_RESOURCES, BOM_RESOURCES, WIP_OPERATIONS, WIP_OPERATION_RESOURCES).

Key Procedures and Functions

The package body exposes a single documented procedure:

• PROCESS_RESRC_ASSIGN — The principal routine that processes resource assignments. It evaluates the requirements defined in AHL_PP_REQUIREMENT_V, resolves eligible resources from the BOM department resource and resource employee definitions, and applies the assignment against the work assignment records (AHL_WORK_ASSIGNMENTS and its _S sequence table). It leverages the FND_API, FND_MSG_PUB, and AHL_DEBUG_PUB utilities for error handling, message stack management, and debugging, consistent with standard EBS API conventions. Parameter lists are not defined in the available metadata; invocation is internal.

Tables Accessed

The package reads and writes against a documented set of tables reached through APPS synonyms:

• AHL_WORK_ASSIGNMENTS / AHL_WORK_ASSIGNMENTS_S — the primary target of resource assignment; the _S table supplies the sequence used to generate unique identifiers. This is the object most directly associated with the user search term "ahl_work_assignments_s".
• AHL_WORKORDERS, AHL_WORKORDER_OPERATIONS — supply the work order and operation context under which assignments are made.
• AHL_OPERATION_RESOURCES — operation-level resource definitions.
• BOM_DEPARTMENTS, BOM_DEPARTMENT_RESOURCES, BOM_DEPT_RES_INSTANCES, BOM_RESOURCES, BOM_RESOURCE_EMPLOYEES — the manufacturing resource and department resource model used to identify assignable resources and their employee links.
• WIP_DISCRETE_JOBS, WIP_OPERATIONS, WIP_OPERATION_RESOURCES — WIP work-in-process job and operation resource data, enabling alignment between eAM work orders and WIP execution.
• DUAL, PLITBLM — utility access for scalar selection and PL/SQL table (index-by) manipulation.

MTL_EMPLOYEES_CURRENT_VIEW and MFG_LOOKUPS are additionally referenced in the dependency listing to resolve employees and validation lookup codes.

Usage Notes

As a private package, AHL_PP_RESRC_ASSIGN_PVT is not intended for direct customer invocation. It is called by the four documented referencing packages, which act as the public entry points for resource assignment in the eAM scheduling workflow. Typical invocation occurs when a work order operation requires personnel or equipment allocation, often triggered from the Oracle eAM Work Management forms or from concurrent programs performing mass resource scheduling.

Custom extensions should call the public wrapper packages rather than this private API, because the private body may change between releases without notice. On 12.1.1 and 12.2.2 the object is reported VALID in the APPS schema. Any custom code that manipulates AHL_WORK_ASSIGNMENTS directly must call AHL_WORK_ASSIGNMENTS_S to obtain a valid primary key, mirroring the sequence behavior this package relies upon. Database administrators troubleshooting assignment failures should query the FND message stack, since errors are surfaced through FND_MSG_PUB and logged via AHL_DEBUG_PUB.