My Oracle Support Banner

PO Approval Ends With Error: "ORA-06512" and "ORA-00060: Deadlock Detected While Waiting for Resource" at "Remove All Notifications For This Doc" Activity (Doc ID 389462.1)

Last updated on JUNE 09, 2019

Applies to:

Oracle Purchasing - Version 11.5.10 to 11.5.10.4 [Release 11.5]
Information in this document applies to any platform.
Checked for relevance on 01-Aug-2012


Symptoms

Purchase orders are stuck in pre-approved or in-process status and the workflow displays this error:

Error:
Activity: Remove All Notifications For This Doc.
Result: #Exception
Error_Name: -06512
Error_Message: ORA-06512: at line
Error Stack: Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_INIT1.REMOVE_REMINDER_NOTIF, POAPPRV, <wf_item_key, <po_num>, RUN)


Notification Error:
ORA-00060: deadlock detected while waiting for resource

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.