My Oracle Support Banner

ORA-00060: Deadlock Error While Approving Requisitions In IProcurement After Canceling Lines (Doc ID 1276856.1)

Last updated on JANUARY 03, 2023

Applies to:

Oracle Purchasing - Version 12.0.1 to 12.1.1 [Release 12 to 12.1]
Oracle iProcurement - Version 12.0.1 to 12.1.1 [Release 12 to 12.1]
Information in this document applies to any platform.

Symptoms

Following error occurs in the workflow while submitting for approval an iProcurement requisition after canceling some lines:

ERROR
-----------------------
Failed Activity Set XML Event Key Activity Type Function Error Name -60 Error Message ORA-00060: deadlock detected while waiting for resource Error Stack Wf_Engine_Util.Function_Call(PO_XML_DELIVERY.setXMLEventKey, POAPPRV, 463882-293782, 175977, RUN)


STEPS
-----------------------
1. Go to an iProcurement responsibility.
2. Create Requisition and submit for approval.
3. Get the Requisition approved if approval is required.
4. Run Workflow Background Process - this creates the Purchase Order.
5. Now, go back to the requisition in iProcurement and cancel one of the lines on the requisition - this creates the Change Order.
6. Now, login as a supplier and accept the Change Order.
7. The 'deadlock' error notification appears.

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.