Deadlock Happens on MRP Workbench When Releasing Planned Orders
Last updated on DECEMBER 12, 2017
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms