Search Results ahl_fleet_forecast_pvt




Overview
Explore in AI Chat

Overview

APPS.AHL_FLEET_FORECAST_PVT is a private (PVT) PL/SQL package within the Oracle Enterprise Asset Management (eAM) / Asset Lifecycle Management (ALM) family of modules, specifically belonging to the AHL (Complex Maintenance, Repair and Overhaul) schema. Its principal business function is to support fleet-level forecasting, simulation, and reconfiguration processing. In the context of fleet operations, "forecast" refers to the projection of fleet utilization, downtime, and configuration changes over time, which enables planners to anticipate availability, schedule maintenance, and assess the impact of reconfiguration moves on fleet readiness.

This package is classified as a private API, meaning it is intended for internal consumption by other AHL components, concurrent programs, or supported business flows rather than being exposed as a public integration point. It operates with AUTHID CURRENT_USER, executing under the privileges of the calling schema.

Key Procedures and Functions

The documented package exposes three procedures:

  • REMOVE_FLEET — Removes a fleet record from the system. The procedure accepts a fleet identifier and an object version number, supporting optimistic locking, and follows the standard Oracle API return convention via x_return_status, x_msg_count, and x_msg_data out parameters. It performs validation and commit handling through the standard FND_API parameters (p_api_version, p_init_msg_list, p_commit, p_validation_level, p_module_type).
  • PROCESS_RECONFIG_MRS — Creates, deletes, or updates Service Requests based on Reconfiguration Maintenance Requests (MRs) associated with a fleet. Inputs include the fleet ID, unit configuration ID, fleet unit association ID, and a delete SR flag (defaulting to 'N').
  • PROCESS_RECONFIGURATION_MRS — Invoked by a concurrent program to create reconfiguration MRs. It accepts an optional fleet header ID and unit configuration ID, and returns the standard concurrent program errbuf and retcode parameters. The ETRM metadata also lists a procedure or function named NAME, which represents a naming or utility helper.

Tables Accessed

The package reads and writes a wide set of AHL and CSI tables via APPS synonyms. Fleet master data is held in AHL_FLEET_HEADERS_B and AHL_FLEET_HEADERS_TL. Fleet composition and configuration are captured in AHL_FLEET_UNIT_ASSOCS, AHL_UNIT_CONFIG_HEADERS, and AHL_UE_RELATIONSHIPS, while fleet reconfiguration activity is stored in AHL_FLEET_RECONFIG_MRS. Forecast-relevant operational data resides in AHL_FLEET_UTILIZATION, AHL_FLEET_DOWNTIMES, AHL_SIMULATION_PLANS_B, and AHL_UE_SIMULATIONS. Maintenance request effectivity and headers are referenced through AHL_MR_EFFECTIVITIES, AHL_MR_HEADERS_B, and AHL_UNIT_EFFECTIVITIES_B. Visit task linkage is captured in AHL_VISIT_TASKS_B, and the installed base reference is CSI_ITEM_INSTANCES.

Usage Notes

Because this is a PVT package, it is not intended for direct customer invocation. It is typically called by other AHL packages, eAM forms supporting fleet definition and reconfiguration, and by concurrent programs that process reconfiguration MRs. Developers extending fleet forecasting functionality should invoke the public AHL APIs that wrap this package rather than calling AHL_FLEET_FORECAST_PVT directly. The package is compatible with both Oracle EBS 12.1.1 and 12.2.2; the header comment indicates it was last updated for the 12.2 code line.