Search Results mrp_auto_reduce_mps

Overview

MRP_AUTO_REDUCE_PK is a PL/SQL package owned by the APPS schema within Oracle E-Business Suite. It supports the Material Requirements Planning (MRP) and Master Production Scheduling (MPS) feature set by automating the reduction, or consumption, of forecast and schedule demand against actual supply and demand activity. This process is commonly referred to as auto-reduce, schedule consumption, or forecast consumption. Its principal business purpose is to prevent the planning engine from double-counting demand by adjusting open forecast and master schedule entries whenever firmer demand such as sales orders or actual production is recorded.

In the ETRM 12.2.2 metadata, the package is classified with an API type of OTHER. It is a valid, compiled package that has historically been present across Oracle EBS 11i, 12.1.1, and 12.2.2 releases. The package encapsulates the consumption logic invoked by Oracle's planning and scheduling processes, ensuring that forecast quantities are reduced in line with actual demand within the appropriate consumption window.

Key Procedures and Functions

The documented package exposes a single procedure:

• MRP_AUTO_REDUCE_MPS — The sole documented procedure in the package. Its name indicates that it performs automatic reduction of master production schedule and forecast entries. It is the entry point through which the consumption logic is executed, typically processing schedule consumption records and applying the reduction across the relevant planning dates. No parameter list is documented in the ETRM repository metadata, so callers should reference the Oracle implementation or the database package specification for the exact signature.

Because only one procedure is catalogued, the package is narrow in scope and functions as a focused utility invoked by higher-level planning jobs rather than a broad public API.

Tables Accessed

The package operates against the following tables via APPS synonyms:

• MRP_SCHEDULE_CONSUMPTIONS — Stores the consumption records that map forecast demand to actual demand. This is the primary table the procedure reads and updates during the reduce operation.
• MRP_SCHEDULE_DATES — Provides the schedule date definitions used to determine the consumption window and which forecast buckets are eligible for reduction.
• BOM_CALENDAR_DATES — Supplies the manufacturing calendar, allowing the consumption logic to respect valid working dates when advancing or matching schedule buckets.
• MTL_PARAMETERS — Holds organization-level planning and inventory parameters that influence how consumption is performed for a given inventory organization.
• MTL_SYSTEM_ITEMS — Provides item master attributes, such as planning and consumption settings, that control whether and how an item participates in auto-reduction.

Usage Notes

MRP_AUTO_REDUCE_PK is not intended for direct invocation by end users. It is typically called by Oracle planning processes, scheduled concurrent programs, and the planning engine when schedule consumption is required. In EBS 12.1.1 and 12.2.2, forecast and schedule consumption may be triggered during the planning cycle or through dedicated consumption requests.

Custom code should invoke the documented procedure only where the standard planning flows cannot be used, and developers should obtain the exact parameter specification from the deployed package specification before calling it. Per the ETRM metadata, no other application packages reference MRP_AUTO_REDUCE_PK, indicating that it is invoked through internal engine calls or direct (non-package) dependencies rather than being a widely reused shared library. Organizations migrating between 12.1.1 and 12.2.2 should note that while the object remains VALID in 12.2.2, the online patching model and editioning introduced in 12.2 may affect any custom code that references it directly. Testing consumption behavior after upgrade is therefore advisable.