Oracle EBS MRP Exception Messages Reference
After every MRP or ASCP plan run, the planner works through exception messages in the Planner Workbench. Knowing what each message means, and which are noise, is the difference between a managed plan and a flooded inbox.
| Exception message | Group | What it means | Usual planner action |
|---|---|---|---|
Items with a shortage | Item | Projected on-hand falls below zero or below safety stock. | Add supply, expedite or change demand. |
Items with excess inventory | Item | Projected on-hand exceeds the demand and safety stock. | Cancel or defer supply, review min-max. |
Items with no activity | Item | No demand or supply in the planning horizon. | Review for obsolescence. |
Items with negative beginning on hand | Item | Starting on-hand is negative. | Correct the inventory balance first. |
Orders to be rescheduled in | Timing | Supply arrives later than it is needed, so it should be pulled earlier. | Expedite the order. |
Orders to be rescheduled out | Timing | Supply arrives earlier than needed. | Push the due date to reduce carrying cost. |
Orders to be cancelled | Supply | Supply exists with no matching demand. | Cancel the order after review. |
Orders with compression days | Timing | Order must be completed in less than the normal lead time. | Check capacity or move the due date. |
Past due orders | Supply | Supply order due date is before the plan start. | Chase supplier or the shop floor. |
Past due forecast | Demand | Forecast entries have dates in the past. | Consume or remove stale forecast. |
Past due sales orders | Demand | Open sales orders with request dates in the past. | Confirm ship dates with customers. |
Potential late order | Timing | Supply is planned after the need date. | Expedite, resource or renegotiate. |
Repetitive schedules past due | Supply | Repetitive schedule dates have passed. | Update or close the schedule. |
Exact wording and the list available depend on your release and on whether you plan in MRP or ASCP. Check the Planner Workbench exception summary on your instance to confirm the names.
Exception triage assistant
Optional: we can show how an agent ranks planning exceptions from your EBS data.
Optional. The tool and every export work without this. No spam.
How to use this reference
Filter by group to focus on supply, demand, item or timing messages. Use the planner action column as a starting playbook for a new planner or as the basis for a standard operating procedure. Export to PDF if you need to put a one-page cheat sheet beside the planner desk.
Prioritising exceptions
Not every exception deserves the same attention. Shortages and past due orders directly threaten customer delivery, so work them first. Reschedule messages are about cost and efficiency, and cancel messages release working capital, so they follow. Items with no activity are a periodic housekeeping task, not a daily one.
- First: shortages, past due, potential late
- Second: reschedule in and compression days
- Third: reschedule out and cancel
- Periodic: excess inventory and no activity
Reducing exception noise
Too many exceptions usually point to master data and parameters, not to bad planning. Check lead times, safety stock, planning time fences, reschedule tolerance and the plan options that control which messages appear. Fixing a single wrong lead time on a high-volume item can remove hundreds of reschedule messages.
Common mistakes
Planners often release or reschedule from the workbench without checking supplier or shop capacity, which then creates fresh past due orders. Another mistake is ignoring negative beginning on hand messages, which silently distort every projected quantity for the item. Fix balances before trusting the plan.
Frequently Asked Questions
Where do I see MRP exceptions in Oracle EBS?
Use the Planner Workbench, where exceptions are summarised by type and drill down to the items and orders. The underlying data is stored in the MRP tables for the plan you ran.
What does Reschedule In mean?
It means the supply order currently arrives after the date it is needed, so it should be moved earlier. It is the planner's signal to expedite the order.
Why do I get Orders to be cancelled?
The plan found supply with no demand to consume it. This often follows a demand drop, a forecast change, or an order that was already covered by other supply.
Are the exception names the same in ASCP?
Most are similar, but ASCP adds exceptions that relate to resource and material constraints. Confirm the list in your own Planner Workbench.
If your planners spend hours triaging exceptions, we can build a read-only agent over your EBS planning data that ranks them by customer impact.
Related Tools
Oracle EBS Item Attribute Template Worksheet
Plan item master attribute values for a new item template, with the underlying MTL_SYSTEM_ITEMS_B column for each attribute.
OracleOracle EBS Discrete Job Statuses Reference
Look up every Oracle WIP discrete job status, its numeric code, what transactions it allows and the usual next step.
Developer ToolsOracle EBS SQL Query Generator for Items and WIP Jobs
Build ready-to-run SELECT statements over MTL_SYSTEM_ITEMS_B, WIP_DISCRETE_JOBS and on-hand quantity tables.
OracleOracle EBS Inventory Transaction Types Reference
Quick lookup of common Oracle Inventory transaction types, their IDs, source types and effect on on-hand quantity.
More Oracle tools
See all- Oracle EBS BOM Interface Load Worksheet
- Oracle EBS Inventory Period Close Checklist
- Oracle EBS WIP Accounting Class Reference
- Oracle EBS Cycle Count Setup Worksheet
- Oracle EBS WIP Job Close Variance Worksheet
- Oracle EBS Routing and Operations Load Worksheet
- Oracle EBS Inventory Organization Parameters Setup Template
- Oracle EBS Item Cost Update Request Form
- Oracle EBS Engineering Change Order Request Template