Search Results mrp_aggregate_rates




Overview
Explore in AI Chat

Overview

The MRP_AGGREGATE_RATES table is a core data object within the Oracle E-Business Suite (EBS) Master Scheduling/MRP module. It serves as a repository for the suggested aggregate repetitive rates of production generated by the MRP planning engine. In repetitive manufacturing environments, production is often planned based on a daily rate rather than discrete work orders. This table stores the output of the planning process for such items, capturing the recommended production rate over specific time periods to meet forecasted demand. Its role is critical for planners who manage high-volume, continuous production lines, as it provides the foundational data for rate-based schedules.

Key Information Stored

The table's structure is defined to uniquely identify a production rate suggestion for a specific item and plan. Its primary key columns are INVENTORY_ITEM_ID, ORGANIZATION_ID, COMPILE_DESIGNATOR, and FIRST_UNIT_COMPLETION_DATE. This combination ensures a unique record for each item's suggested rate within a specific MRP plan, starting on a given date. While the provided metadata does not list all columns, typical data stored includes the suggested daily or periodic production quantity (rate), the effective date range for the rate, and the planning horizon details. The FIRST_UNIT_COMPLETION_DATE is particularly significant as it marks the start date for the application of the calculated aggregate rate.

Common Use Cases and Queries

The primary use case is reviewing and implementing rate-based production schedules post-MRP run. Planners query this table to view the planning engine's suggestions before firming the schedule. Common reporting involves joining with item master tables to pull item descriptions and planning attributes. A typical query pattern would be:

  • Identifying all suggested rates for a critical item across plans: SELECT * FROM MRP_AGGREGATE_RATES WHERE INVENTORY_ITEM_ID = 12345 AND ORGANIZATION_ID = 101 ORDER BY COMPILE_DESIGNATOR, FIRST_UNIT_COMPLETION_DATE;
  • Comparing rates between different MRP plan scenarios (compile designators) for analysis.
  • Extracting data for custom reports or dashboards that visualize planned production rates over time.

Data from this table is often used as a source for creating repetitive schedules and interfacing with execution systems.

Related Objects

MRP_AGGREGATE_RATES has defined relationships with other key MRP tables, as indicated by its foreign keys. It is primarily linked to MRP_SYSTEM_ITEMS via the INVENTORY_ITEM_ID, ORGANIZATION_ID, and COMPILE_DESIGNATOR columns. This ensures referential integrity with the snapshot of item data used in the specific MRP plan. While not listed in the provided metadata, this table is logically related to other MRP output tables like MRP_RECOMMENDATIONS and is populated by the MRP planning engine (typically via packages within the MRP schema). It may also be referenced by views or interfaces that consolidate planning output for user review in the EBS forms.