Search Results ahl_ump_forecast_req_pvt




Overview
Explore in AI Chat

Overview

APPS.AHL_UMP_FORECAST_REQ_PVT is a private PL/SQL package within the Oracle Enterprise Asset Management (eAM) and Enterprise Asset Management module of Oracle E-Business Suite. The AHL_ prefix identifies it as part of the Asset Lifecycle / Maintenance Management (formerly Enterprise Asset Management) product family, and the UMP token indicates its role in the Unit Maintenance Planning and forecasting subcomponent. The PVT suffix classifies the package as a private API, meaning it is not intended for direct invocation by external or customer-written code. Instead, it operates as an internal engine supporting the public forecast-related interfaces that drive material requirement forecasting for scheduled maintenance activities.

The package is valid and present in the APPS schema on both EBS 12.1.1 and 12.2.2. Its business function is to compute and stage forecast requirements for materials and maintenance resources, translating scheduled maintenance plans and unit configuration data into forward-looking material demand streams.

Key Procedures and Functions

The ETRM metadata documents two procedures for this package. Parameter lists are not published.

  • PROCESS_MRL_REQ_FORECAST — Processes Material Requirement Lines (MRL) to generate forecast requirements. This procedure evaluates scheduled maintenance material needs and produces the corresponding forecast records, forming the core processing step for material demand forecasting.
  • BUILD_MAT_FORECAST_STREAM — Constructs the material forecast stream, assembling the sequence of material demand values over the forecast horizon based on unit configuration, effectivities, and scheduled tasks.

Tables Accessed

The package interacts with a set of eAM operational tables through APPS synonyms. These include AHL_MR_HEADERS_B and AHL_ROUTES to read maintenance requirement headers and routing definitions; AHL_SCHEDULE_MATERIALS for scheduled material lines; AHL_UNIT_CONFIG_HEADERS and AHL_UNIT_EFFECTIVITIES_B for unit configuration and effectivity dating; AHL_VISIT_TASKS_B for visit task definitions; and CSI_ITEM_INSTANCES plus CSI_II_RELATIONSHIPS for installed base item instance data and their relationships. AHL_ROUTES_B provides base routing information. PLITBLM is a standard Oracle Applications PL/SQL index-by table used for parameter passing. Collectively, these tables supply the schedule, configuration, and installed-base context needed to derive forecast demand.

Usage Notes

Because AHL_UMP_FORECAST_REQ_PVT is a PVT package, it is invoked indirectly—typically through the public unit maintenance planning APIs and concurrent programs that generate forecast requirements. It depends on AHL_UMP_PROCESSUNIT_PVT and FND_API, and the metadata indicates no other packages reference it directly, consistent with its private status. In EBS 12.2.2 the code resides online in the APPS schema rather than in a separate products directory, reflecting the AD/TXK editioning model introduced in 12.2. Customers and integrators should not call this package directly; forecasting is exercised through the supported eAM maintenance planning flows.