Search Results mrp_weeks_months

Overview

MRP_REPORTING_BUCKETS is an Oracle EBS Material Requirements Planning (MRP) utility package owned by the APPS schema. It is declared with AUTHID CURRENT_USER, meaning that its unqualified references to database objects are resolved using the privileges of the invoking user rather than the package owner, a design choice that allows the PL/SQL logic to operate against synonyms and calendar data visible to the caller.

The package addresses a recurring requirement in MRP and supply chain reporting: translating planning output into time-phased reporting "buckets." MRP reports and inquiries commonly present planned orders, demand, and supply in weekly or monthly columns. The database stores discrete calendar data — week start dates and period start dates — in the BOM calendar tables, but a report must be able to align those discrete dates into a fixed number of display columns starting from a user-selected date. MRP_REPORTING_BUCKETS performs that alignment so downstream reports and forms can render horizontal time buckets consistently. Because the package is invoked in the context of a specific user and planning query, it also participates in the temporary state maintained by MRP inquiry and report generation.

Key Procedures and Functions

The package exposes a single documented procedure, MRP_WEEKS_MONTHS. As the name implies, it drives the construction of a combined week and month bucketing scheme for MRP reporting. The procedure accepts an MRP query identifier, the invoking user identifier, counts for weeks and periods, a start date, and an organization identifier. These parameters together define both the reporting context (which query, which user, which organization) and the bucket geometry (how many weekly buckets, how many monthly buckets, and the date from which bucketing begins).

Internally the procedure is expected to resolve the supplied start date against the organization's calendar, derive the sequence of week and period boundaries, and record or return the bucketed date ranges so that a caller can label and populate report columns. It does not publish any functions or additional documented procedures; all buffering and reporting behavior is consolidated into this entry point.

Tables Accessed

ETRM documentation identifies three tables referenced through APPS synonyms:

• BOM_CAL_WEEK_START_DATES — supplies the week-start boundaries for the organization's calendar, used to construct the weekly portion of the bucket set.
• BOM_PERIOD_START_DATES — supplies period (monthly) start boundaries for the same calendar, used to construct the monthly portion of the bucket set.
• MRP_FORM_QUERY — stores the MRP query definition associated with the supplied query identifier, providing the planning context in which the buckets are applied.

Calendar data from the BOM tables is read-only reference data; MRP_FORM_QUERY is likewise accessed for query context. The package is referenced by two other packages in the EBS schema, indicating it functions as a shared low-level utility consumed by higher-level MRP reporting modules rather than as a standalone application feature.

Usage Notes

MRP_REPORTING_BUCKETS is not intended as an end-user-facing API. It is invoked programmatically by MRP reporting components — chiefly report-generation logic and the Oracle Forms-based MRP inquiries — when a horizontal, time-bucketed display is required. Oracle Planning and Supply Chain Planning release 12.1.1 and 12.2.2 do not document this package for direct customer invocation, and Oracle does not publish a commitment for its signature. Customizations should treat it as internal: calling it directly risks breakage on upgrade. When custom code must manipulate MRP week and month buckets, the recommended approach is to replicate the calendar logic against BOM_CAL_WEEK_START_DATES and BOM_PERIOD_START_DATES rather than to call MRP_WEEKS_MONTHS. The header revision shown (115.0) is unchanged since 1999, indicating that the package is stable and rarely modified.