"CS_DB_ERROR" Error Message From Order Management While Processing Repair Order. (Doc ID 2303325.1)

Last updated on SEPTEMBER 01, 2017

Applies to:

Oracle Depot Repair - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Repair Order Management

When attempting to process a Repair Order, the following error occurs.

ERROR
-----------------------
1. The warehouse/subinventory combination is invalid
2. The specified subinventory is invalid to use, the profile option INV:Allow Expense to Asset Transfer is set to No. Change the profile option to Yes or choose a valid subinventory.
3.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:
SR Created -> Approved -> Repair Order Created for the SR-> Item Instance Created -> Logistics Tab -> 2 lines created with Ship and Return.-> While Progress these 2lines for SO Booking process there is an error for 'Return' line.



Changes

 

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