Deadlock Happens on MRP Workbench When Releasing Planned Orders
(Doc ID 2335186.1)
Last updated on SEPTEMBER 17, 2019
Applies to:Oracle Materials Requirement Planning - Version 12.1.3 and later
Information in this document applies to any platform.
When attempting to release planned orders on workbench, the following error occurs.
ORA-00060:Deadlock detected while waiting for resource.
Trace file shows deadlock happens for below 2 sql statement.
SQL1: - Comes from the Snapshot Delete worker that runs when plan is launched
DELETE FROM mrp_recommendations
AND rownum <= 100000
AND organization_id = :org_id
SQL2: - Comes from user working in workbench to release a planned order
UPDATE MRP_RECOMMENDATIONS SET LAST_UPDATE_DATE = :b1, ...
1.(N)Material Planning - MRP - Workbench(B)Supply/Demand.
2.Check Selected to Release.
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