Search Results implement_simulation_plan

Overview

APPS.AHL_SIMULATION_PVT is a private (PVT) PL/SQL package body belonging to the Oracle E-Business Suite Enterprise Asset Management (EAM) / Asset Lifecycle Management (ALM) product family, specifically the AHL (Asset Lifecycle) application module that supports Maintenance Management and simulation planning. The package encapsulates the business logic required to create, modify, and remove simulation plans that model "what-if" fleet maintenance scenarios before they are committed to live execution. Simulation plans allow planners to evaluate the impact of scheduled maintenance on fleet units, unit associations, maintenance requirements, materials, and resources without affecting operational data. The package is designated private because it is intended for internal invocation by the AHL simulation user interface and by other AHL APIs rather than as a public extension point.

Key Procedures and Functions

The package body documents three procedures, all centered on simulation lifecycle management:

• DELETE_SIMULATION_PLAN — Invoked from the user interface to delete a simulation plan's fleet-unit association. The procedure first acquires row-level locks on the underlying simulation and unit association records (using cursors over AHL_UE_SIMULATIONS and AHL_FLEET_UNIT_ASSOCS with FOR UPDATE), and it defines a named exception record_locked bound to Oracle error -54 to handle contention gracefully. This is the entry point most relevant to the search term "delete_simulation_plan."
• IMPLEMENT_SIMULATION_PLAN — Promotes an approved simulation plan into an actual maintenance plan, transferring the modeled requirements and associations into the operational maintenance structures.
• REMOVE_UNIT_FROM_PLAN — Removes an individual unit from an existing simulation plan without deleting the entire plan, supporting incremental scenario editing.

All procedures follow the standard EBS API signature conventions, accepting p_api_version, p_init_msg_list, p_commit, p_validation_level, and p_module_type, and returning x_return_status, x_msg_count, and x_msg_data for standardized error propagation.

Tables Accessed

The package reads and writes several AHL tables via APPS synonyms:

• AHL_FLEET_UNIT_ASSOCS — Stores the associations between fleet units and simulation plans; deleted or modified when units are removed.
• AHL_SIMULATION_PLANS_B — The base table holding simulation plan headers.
• AHL_UE_SIMULATIONS — Holds simulated unit events, locked during deletion to prevent concurrent modification.
• AHL_UMP_MAINT_REQMNTS — Simulation maintenance requirements generated by the plan.
• AHL_UMP_MATERIAL_REQMNTS — Material requirements derived from the simulated maintenance work.
• AHL_UMP_RESOURCE_REQMNTS — Resource requirements associated with the simulation.
• DBMS_LOCK — Used for explicit locking behavior beyond row-level FOR UPDATE semantics.
• PLITBLM — The standard EBS PL/SQL table/list utility used for building and processing array parameters.

Usage Notes

AHL_SIMULATION_PVT is typically invoked from the AHL simulation plan maintenance form, where user actions such as deleting a plan or removing a unit trigger the corresponding procedures. Because the package is classified PVT, Oracle does not guarantee its signature across releases; custom code should avoid direct calls and instead use the documented public APIs. The package is not referenced by any other packages per the ETRM metadata, confirming its role as a leaf-level implementation package. Developers extending simulation behavior in 12.1.1 or 12.2.2 should rely on the FND message stack populated by x_return_status, x_msg_count, and x_msg_data for error handling. The FOR UPDATE cursors and record_locked exception indicate that concurrent plan deletion is explicitly guarded, and callers should expect retry logic when ORA-00054 is raised.