Results for “mrp_forecast”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

MRP_FORECAST is a public PL/SQL package in the APPS schema that supports forecast bucketing and date-bucket retrieval logic within Oracle E-Business Suite's Material Requirements Planning (MRP) and forecasting modules. Its principal role is to evaluate a user-supplied forecast query — against a designated forecast set and designator — and to resolve each forecast entry into the appropriate time bucket (day, week, or period) based on the bucket type and date range supplied by the caller. This bucketing capability is essential to the Forecast Workbench and forecast-entry forms, which present forecast quantities organized by time bucket rather than as flat dated rows.

The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than as definer, and it relies on APPS synonyms to reach the underlying MRP, BOM, and MTL tables.

Key Procedures and Functions

The documented package exposes a single public procedure, BUCKET_ENTRIES. Its parameter list (per the shipped specification) includes form mode, organization ID, query ID and secondary query ID, bucket type, past-due indicator, forecast designator, forecast set, inventory item ID, start date, and cutoff date. In operation, BUCKET_ENTRIES takes a forecast query definition and translates the individual forecast entries within a forecast set/designator into bucketed quantities spanning the window defined by the start date and cutoff date, honoring the requested bucket type and the treatment of past-due entries. Because the only documented callable is this procedure, the package should be understood as a focused utility rather than a broad API surface; no other public functions or procedures are recorded in the ETRM metadata.

Tables Accessed

The package reads the following documented tables (through APPS synonyms):

• BOM_CALENDAR_DATES — provides valid working dates used to align buckets to the manufacturing calendar.
• BOM_CAL_WEEK_START_DATES — supplies week-start dates for weekly bucket boundaries.
• BOM_PERIOD_START_DATES — supplies period-start dates for period-based buckets.
• MRP_FORECAST_DATES — holds the dated forecast quantity records that are being bucketed.
• MRP_FORECAST_DESIGNATORS — identifies the forecast designator context applied to the query.
• MRP_FORM_QUERY — stores the saved query definition (query ID / secondary query ID) used to select forecast rows.
• MTL_PARAMETERS — provides organization-level defaults, including the org's calendar and default period settings.

The calendar and start-date tables drive the bucketing boundaries; the MRP forecast tables supply the data; MTL_PARAMETERS supplies organizational context.

Usage Notes

MRP_FORECAST is typically invoked indirectly from Oracle MRP/forecasting forms during forecast display and query execution, where the user selects a forecast set, designator, bucket type, and date range. The presence of arg_form_mode in the signature indicates that the calling form passes its current mode so the procedure can behave appropriately in query versus display contexts.

For custom or extension development on 12.1.1 and 12.2.2, BUCKET_ENTRIES can be called directly to obtain bucketed forecast data consistent with standard MRP behavior, which avoids reimplementing calendar-based bucket logic. Because the package depends on APPS synonyms and organization setup, callers must supply a valid org_id and a query ID that exists in MRP_FORM_QUERY. The header date (2003) and version (115.2) indicate the package has remained stable across releases, so references remain consistent between 12.1.1 and 12.2.2. No other packages in the documented inventory reference MRP_FORECAST, confirming its role as a leaf-level utility invoked by forms rather than by other PL/SQL APIs.