Search Results mrp_repetitive_schedules




Overview
Explore in AI Chat

Overview

The MRP_REPETITIVE_SCHEDULES table is a core data repository within the Oracle E-Business Suite (EBS) Master Scheduling/MRP module. It stores the current and active production schedules for items manufactured using a repetitive manufacturing flow. In repetitive manufacturing, discrete jobs are not used; instead, production is scheduled over a period at a constant daily rate for a specific assembly on a dedicated production line. This table is fundamental to the Material Requirements Planning (MRP) engine, as it holds the planned supply that MRP consumes to calculate net requirements. The data in this table is typically generated from master production schedules (MPS) or directly from repetitive planning and is a primary input for MRP and Supply Chain Planning processes in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by its primary key, which uniquely identifies a repetitive schedule record. The key columns are INVENTORY_ITEM_ID, ORGANIZATION_ID, COMPILE_DESIGNATOR (identifying the MRP plan), WIP_ENTITY_ID (identifying the repetitive schedule), and SCHEDULE_ID. Beyond the key, the table contains critical scheduling attributes. These include the REPETITIVE_LINE (linking to WIP_LINES), REVISION, and the scheduled quantities and dates. Key operational columns typically found in such schedules are the scheduled start and completion dates, the daily production rate, and the total quantity to be produced over the schedule period. The table maintains a relationship with master item definitions via its foreign key to MRP_SYSTEM_ITEMS.

Common Use Cases and Queries

A primary use case is analyzing planned supply for MRP items. Planners often query this table to review all active repetitive schedules within a specific organization and MRP plan. Common reporting needs include summarizing total planned quantities by item or production line, and identifying schedules that fall within a specific date range. A typical query pattern involves joining with item and line tables for descriptive information.

  • Sample Query: Retrieving schedule details for a specific plan.
    SELECT mrs.*, msi.concatenated_segments item_code
    FROM mrp_repetitive_schedules mrs,
    mrp_system_items msi
    WHERE mrs.organization_id = msi.organization_id
    AND mrs.inventory_item_id = msi.inventory_item_id
    AND mrs.compile_designator = 'MASTER_PLAN'
    AND mrs.organization_id = 101;
  • Data in this table is also crucial for capacity planning and is often sourced by custom or standard reports to monitor production line loading and schedule adherence.

Related Objects

The MRP_REPETITIVE_SCHEDULES table is centrally connected to several key EBS entities, as indicated by its foreign keys. Its most critical relationship is with MRP_SYSTEM_ITEMS, which provides the item master context for the scheduled assembly. It links to WIP_LINES via the REPETITIVE_LINE column, defining the specific manufacturing line for production. For revision-controlled items, it references MTL_ITEM_REVISIONS_B. This table is a direct source for the MRP planning engine and is closely related to the WIP_REPETITIVE_SCHEDULES table in the Work in Process module, which may hold more execution-focused data. Programmatic access and updates are typically managed through dedicated Oracle APIs rather than direct DML.