Deadlock Happens on MRP Workbench When Releasing Planned Orders (Doc ID 2335186.1)

Last updated on SEPTEMBER 17, 2019

Applies to:

Symptoms

When attempting to release planned orders on workbench, the following error occurs.

ERROR
-----------------------
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
WHERE compile_designator=:vdesig
AND 1=1
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, ...

STEPS
-----------------------
1.(N)Material Planning - MRP - Workbench(B)Supply/Demand.

2.Check Selected to Release.

3.Save it.

Cause

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