My Oracle Support Banner

MRP Work Bench Does Not Show The Open Purchase Orders It Is Always Creating New Planned, MTL_SUPPLY Trigger Not Firing, MRP_RELIEF_INTERFACE Empty (Doc ID 2536487.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Inventory Management - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

There are rows in MTL_SUPPLY that are not being correctly updated in MRP_RELIEF_INTERFACE table.
The MTL_SUPPLY_T is not picking up these records correctly.

EXPECTED BEHAVIOR
Rows get correctly updated from MTL_SUPPLY to MRP.

STEPS
1. Create a purchase order.
2. Approve the purchase order.
3. Check MRP_RELIEF_INTERFACE table for records.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.