Depot Repair Error: "ORA-00060: deadlock detected while waiting for resource"
(Doc ID 1583967.1)
Last updated on SEPTEMBER 14, 2023
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
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 |