Depot Repair Error: "ORA-00060: deadlock detected while waiting for resource" (Doc ID 1583967.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Depot Repair - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Repair Orders > Repair Actuals

When trying to process a line from Repair Actuals an error occurs:

ERROR
-----------------------

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)

From the trace file:

----- Current SQL Statement for this session (sql_id=atfkvnhnwww2u) -----
UPDATE CS_ESTIMATE_DETAILS SET LINE_SUBMITTED = :B5 , SUBMIT_RESTRICTION_MESSAGE = :B4 , SUBMIT_ERROR_MESSAGE = :B3 , SUBMIT_FROM_SYSTEM = :B2 , LAST_UPDATE_DATE = SYSDATE, LAST_UPDATE_LOGIN = FND_GLOBAL.LOG
IN_ID, LAST_UPDATED_BY = FND_GLOBAL.USER_ID WHERE ESTIMATE_DETAIL_ID = :B1
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object line object
 handle number name
1b3a7a7e30 362 package body APPS.CS_CHARGE_CREATE_ORDER_PVT
1b3a7a7e30 3563 package body APPS.CS_CHARGE_CREATE_ORDER_PVT
1df46afab8 151 package body APPS.CS_CHARGE_CREATE_ORDER_PUB
1c6f01f8f8 1467 package body APPS.CSD_PROCESS_PVT
1b35900b10 2769 package body APPS.CSD_LOGISTICS_UTIL
1c6f01f8f8 4795 package body APPS.CSD_PROCESS_PVT
===================================================

STEPS TO REPRODUCE:
===================
1. Add a new item to the inventory that has an incomplete setup for a particular organization
2. Use that item in a Repair Actuals line
3. Click on "Book Selected" and the following messages are displayed:

"Error messages from Order Management"

click "OK" button

"The item specified is invalid or does not exist in the warehouse you specified. Please enter a valid item-warehouse combination."

click "OK" button

"Item Validation resulted in error(s)."

click "OK" button

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)

4. If the same item is used in Charges UI, then only the OM errors are displayed but no ORA-00060
5. If the item setup is fixed then there is no error from OM and also no ORA-00060

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