Results for “mrp_weeks_months”
24 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
MRP_REPORTING_BUCKETS is an Oracle Applications (APPS) PL/SQL package body that belongs to the Oracle Material Requirements Planning (MRP) product family. Its core business function is to generate and manage the time-bucket structures — weeks and months — that drive MRP planning and reporting output. Material planning in Oracle EBS is inherently time-phased: on-hand supply, demand, scheduled receipts, and planned orders must be aggregated and displayed across distinct planning periods so that planners can evaluate requirements by bucket. MRP_REPORTING_BUCKETS encapsulates the logic that maps calendar dates to these reporting buckets, ensuring consistent bucketing across MRP reports, forms, and inquiry screens.
Under ETRM classification this package is an OTHER (non-public-API) object. It is a supporting utility rather than a documented integration API, and consumers invoke it internally from within the MRP application code and supporting forms. The package body is documented as VALID in the APPS schema.
Key Procedures and Functions
The ETRM metadata documents a single procedure/function entry:
- MRP_WEEKS_MONTHS — This is the principal entry point of the package. Its purpose is to derive and populate the week-based and month-based reporting buckets used by MRP output. By resolving calendar start dates into discrete planning periods, it supplies the time-phased framework that MRP reports and inquiries render against. No documented parameter list is available; per ETRM guidance, no specific signature should be assumed.
The procedure is the sole documented member, indicating the package is a focused, single-purpose utility rather than a broad library of routines.
Tables Accessed
The package references the following database objects, accessed through APPS synonyms:
- BOM_CAL_WEEK_START_DATES — A calendar table from the Oracle Bills of Material schema that stores the start dates of each defined work week. MRP uses this to align reporting weeks with the manufacturing calendar, ensuring buckets are built from valid working-week boundaries.
- BOM_PERIOD_START_DATES — The companion table defining period (month) start dates. Together with the week-start dates, it allows the package to construct both weekly and monthly reporting buckets from the same calendar definitions.
- MRP_FORM_QUERY — An MRP form-query table used to drive query and display logic for MRP forms and inquiry screens. Referencing it indicates the bucketing routine supports interactive form-based reporting.
It also depends on internal objects MRP_CALENDAR and MRP_REPORTING_BUCKETS itself (self-reference, likely recursive or shared internal logic), plus SYS.DBMS_STANDARD and SYS.STANDARD. No insert, update, or delete operations are documented; the primary use is read access against the calendar and form-query tables.
Usage Notes
MRP_REPORTING_BUCKETS is typically invoked internally by MRP forms and reporting logic rather than being called directly by end users or external integrations. Because it reads the BOM calendar start-date tables, correct results depend on a properly maintained manufacturing calendar; if weeks or periods are undefined, bucketing output may be incomplete.
The ETRM metadata indicates the package is referenced by two other database objects, confirming it is a dependency for higher-level MRP components. It is not referenced by public APIs and should be treated as an internal implementation object. Custom code should avoid hard-coding calls to MRP_WEEKS_MONTHS; where date bucketing is required, developers should rely on supported MRP APIs or replicate the calendar logic. As with any internal package, it may be modified between EBS releases.