Search Results mrp_load_parameters




Deep Dive into MRP_LOAD_PARAMETERS Table in Oracle EBS 12.1.1/12.2.2

The MRP_LOAD_PARAMETERS table is a critical repository for Material Requirements Planning (MRP) configuration data in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. This table stores runtime parameters that govern how the MRP engine processes demand, supply, and planning recommendations during MRP or MRP-based ASCP (Advanced Supply Chain Planning) runs.

Key Functional Aspects

  • Parameter Storage: Acts as the primary repository for user-defined MRP run parameters including planning horizon, demand time fences, and processing rules.
  • Run Configuration: Stores settings that determine whether the run is net change or full regeneration, along with explosion controls.
  • Integration Bridge: Links the MRP application with underlying Oracle Planning Engine by passing execution parameters.

Technical Structure

Column Name Data Type Description
LOAD_ID NUMBER Primary key, sequence-generated identifier
ORGANIZATION_ID NUMBER References INV_ORGANIZATIONS
PLANNER_CODE VARCHAR2(10) MRP planner assignment
CUTOFF_DATE DATE Horizon end date for planning
NETTING_TYPE NUMBER 0=Gross, 1=Net requirements
PROCESSING_RULE NUMBER 1=Regen, 2=Net Change

Business Process Integration

During MRP execution, the Oracle Planning Engine reads parameters from this table to:

  • Determine the scope of items to process based on organization and planner filters
  • Apply demand time fence rules to prevent premature rescheduling
  • Control whether to explode phantom BOMs during component planning
  • Set the planning horizon for generating planned orders

Implementation Considerations

Administrators should note:

  • Data is typically populated via the MRP:Plan Options form (Oracle Forms) or Planning Central (OAF)
  • Historical parameter sets remain for audit purposes with LOAD_ID sequencing
  • Customizations often extend this table for industry-specific planning rules

Performance Impact

The table's design supports high-volume planning environments through:

  • Indexing on LOAD_ID and ORGANIZATION_ID columns
  • Partitioning strategies in large multi-org implementations
  • Minimal LOB columns to prevent tablespace fragmentation

Conclusion: The MRP_LOAD_PARAMETERS table serves as the configuration backbone for Oracle's MRP engine, balancing flexibility for planners with the technical rigor required for enterprise-scale planning operations. Its structure remains consistent across 12.1.1 and 12.2.2, ensuring upgrade compatibility for planning modules.