Search Results mrp_schedule_dates




The MRP_SCHEDULE_DATES table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical data structure within the Manufacturing and Supply Chain modules, specifically supporting Material Requirements Planning (MRP) and Advanced Supply Chain Planning (ASCP) functionalities. This table stores scheduling-related information for planned orders, work orders, purchase requisitions, and purchase orders, enabling organizations to manage production and procurement timelines efficiently. Below is a detailed breakdown of its structure, purpose, and key attributes.

Purpose and Functional Context

The MRP_SCHEDULE_DATES table acts as a repository for date-sensitive scheduling data generated during MRP or ASCP runs. It captures planned start and completion dates, firm dates, and other scheduling milestones for items across the supply chain. This data is pivotal for:
  • Order Scheduling: Determines when orders should be released, started, or completed based on lead times and constraints.
  • Capacity Planning: Aligns production schedules with resource availability.
  • Exception Management: Flags discrepancies between planned and actual dates for corrective actions.

Key Columns and Attributes

The table includes columns that map to scheduling logic and integration points with other modules (e.g., Inventory, Purchasing, Work in Process). Notable columns include:
  • SCHEDULE_LEVEL: Indicates whether the record pertains to an item, organization, or global plan.
  • INVENTORY_ITEM_ID: Foreign key to MTL_SYSTEM_ITEMS_B, linking to item master data.
  • ORGANIZATION_ID: References HR_ALL_ORGANIZATION_UNITS, tying schedules to specific inventory organizations.
  • PLANNED_ORDER_TYPE: Distinguishes between planned orders (1), work orders (2), purchase requisitions (3), or purchase orders (4).
  • FIRM_PLANNED_FLAG: Marks whether the schedule is firm (Y/N), preventing automatic rescheduling.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY: Standard Oracle audit columns.

Integration with Other Modules

The table interacts with:
  • MRP_RECOMMENDATIONS: Supplies input for order recommendations.
  • WIP_DISCRETE_JOBS: For work order scheduling.
  • PO_REQUISITIONS_INTERFACE: For purchase requisition processing.

Technical Considerations

  • Indexing: Key columns like INVENTORY_ITEM_ID and ORGANIZATION_ID are indexed for performance.
  • Partitioning: In high-volume environments, partitioning by ORGANIZATION_ID or PLAN_ID may be implemented.
  • Purge Logic: Data is typically purged during MRP plan refreshes to avoid bloating.

Business Process Impact

The table directly influences:
  • Procurement: Purchase order dates drive supplier commitments.
  • Production: Work order dates align with shop floor execution.
  • Inventory Replenishment: Planned order dates trigger stock replenishment.

Customization and Extensions

Organizations may extend the table via descriptive flexfields (DFFs) or custom columns to capture additional scheduling attributes (e.g., project-specific deadlines). However, modifications require careful testing due to integration dependencies. In summary, the MRP_SCHEDULE_DATES table is a cornerstone of Oracle EBS’s planning engine, ensuring alignment between demand, supply, and execution timelines. Its design reflects Oracle’s commitment to integrated supply chain management, providing a robust framework for date-driven decision-making.