Depot Repair Error: "ORA-00060: Deadlock Detected While Waiting For Resource" (Doc ID 2963070.1)

Last updated on JULY 26, 2023

Applies to:

Symptoms

When attempting to create an RMA line in the logistics section in Depot Repair, the following error occurs:


ERROR
-----------------------
The Customer's PO Number is referenced by another order.
Click OK
Error: Error during sending of XML request
document.:ORA-29273: HTTP request failed
ORA-12541: TNS: no listener
Click OK
CS_DB_ERROR (PROG_NAME=Cs_Charge_Create_Order_PVT.Update_Errors)(SQLCODE=60)(SQLERRM=ORA-00060): deadlock detected while waiting for resource
ORA-06510: PL/SQL: unhandled user-defined exception


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log in with Depot Repair Manager responsibility and open Service Order form.
2. Enter the mandatory information and save.
3. Go To Logistics tab and enter an RMA line. Save.

Changes

Cause

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