Deadlock Happens on MRP Workbench When Releasing Planned Orders

(Doc ID 2335186.1)

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.

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

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