Search Results mrp_sugg_rep_schedules




Overview
Explore in AI Chat

Overview

The MRP_SUGG_REP_SCHEDULES table is a core data object within the Oracle E-Business Suite (EBS) Master Scheduling/MRP module. It serves as the transactional repository for suggested repetitive schedules generated by the Master Production Schedule (MPS) and Material Requirements Planning (MRP) planning engines. When a plan is run, this table stores the output recommendations for repetitive manufacturing lines, detailing proposed production quantities and dates. These suggestions are subsequently reviewed by planners and can be implemented, modified, or rejected, ultimately driving the creation of firm production schedules in the Work in Process (WIP) module.

Key Information Stored

The table's structure captures the essential attributes of a suggested repetitive schedule. While the full column list is not detailed in the provided metadata, the documented foreign key relationships and standard MRP table design indicate it will contain critical fields. These typically include a unique TRANSACTION_ID linking to the MRP_RECOMMENDATIONS table, an INVENTORY_ITEM_ID and ORGANIZATION_ID identifying the item, and a REPETITIVE_LINE column specifying the manufacturing line. The COMPILE_DESIGNATOR is a key column that identifies the specific plan (e.g., 'MDS', 'MRP') that generated the suggestion. Other common columns would include suggested daily quantities, start and end dates, and processing status flags to track planner action.

Common Use Cases and Queries

The primary use case is the review and implementation of MRP/MPS output for repetitive manufacturing. Planners access these suggestions through the standard Oracle Planning Workbench or custom reports. Common analytical queries involve filtering by compile designator and organization to view all suggestions from a recent plan run, or joining to item master tables to assess suggestions for critical components. A typical reporting SQL pattern would join MRP_SUGG_REP_SCHEDULES to MRP_SYSTEM_ITEMS for item descriptions and to WIP_LINES for line details. Data from this table is also purged or archived upon the launch of a new plan to maintain performance and clarity.

Related Objects

The table maintains defined foreign key relationships with several other EBS tables, as documented in the metadata. These relationships are crucial for data integrity and reporting:

  • MRP_RECOMMENDATIONS (TRANSACTION_ID): This is the primary parent table. Each suggested schedule is a specific type of planning recommendation.
  • WIP_LINES (REPETITIVE_LINE): Links the suggestion to the specific repetitive manufacturing line defined in the Work in Process module.
  • MRP_SYSTEM_ITEMS (INVENTORY_ITEM_ID, ORGANIZATION_ID, COMPILE_DESIGNATOR): Joins to the planning item master to retrieve item attributes, planning methods, and other data specific to the compile designator used in the plan.