My Oracle Support Banner

Is There A Way To Remove The CS_DB_ERROR Received When Booking The Logistics Line With Incorrect/Incomplete Data? (Doc ID 2728542.1)

Last updated on NOVEMBER 15, 2020

Applies to:

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

Goal

Currently the application throws an error like the following when booking logistics lines with incorrect data:

ERROR
-----------------------
Item hold applied against line 1
Please enter valid lot number and quantity
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)

Error can be avoided by passing the correct data. If charges API doesn't have all required parameters, it gives the message followed by dead lock message.
On clicking ok, this gets closed immediately.

This unnecessary message should be removed and replaced with a more meaningful error message.

 

Solution

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
Goal
Solution
References


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