Search Results implement_alternate_bom




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

MRP_RECOMMENDATIONS is the central transaction table within the Oracle E-Business Suite Master Scheduling/MRP (MRP) module. Each row represents a single planning recommendation generated by an MRP, MPS, or DRP planning run — for example, a planned order release, a reschedule suggestion, a cancellation, or a firm-planned order action. The table is owned by the MRP schema and is validated in both 12.1.1 and 12.2.2. It holds 92 documented columns in 12.2.2.

Because the table captures the outcome of the planning engine and serves as the source for downstream implementation, relief, pegging, and capacity processes, it functions as the operational hub of the planning data model. Applying the heuristic Data Vault classification supplied in the metadata, MRP_RECOMMENDATIONS is hub-leaning: its TRANSACTION_ID is the unique business key around which numerous dependent link and satellite tables (pegging, schedule dates, resource plans, gross requirements) are organized.

Key Information Stored

The primary key is MRP_RECOMMENDATIONS_PK, defined on TRANSACTION_ID, and a unique index MRP_RECOMMENDATIONS_U1 reinforces TRANSACTION_ID as the business-key candidate. The most significant columns include:

Common Use Cases and Queries

Typical uses include the Planner Workbench, where recommendations are reviewed and released; exception reporting on reschedule days and compression; and auditing of implemented versus suggested actions. A frequent query pattern joins recommendations to their item and plan context and filters by run:

  • Retrieve all recommendations from a specific plan run: SELECT * FROM MRP.MRP_RECOMMENDATIONS WHERE COMPILE_DESIGNATOR = :plan AND REQUEST_ID = :request_id;
  • List reschedule suggestions: ... WHERE RESCHEDULED_FLAG = 'Y' AND DISPOSITION_STATUS_TYPE = 'RESCHEDULE';
  • Trace implemented actions by joining IMPLEMENT_* columns to WIP and purchasing entities.
  • Feed planning dashboards summarizing NEW_ORDER_QUANTITY by ORGANIZATION_ID and INVENTORY_ITEM_ID.

Related Objects

MRP_RECOMMENDATIONS participates in an extensive foreign-key network. Key relationships (with join columns) include: