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:
-----------------------
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 |