Interface Trip Stop Fails With Error OE_Line_Adj_Util:COPY_ADJUSTMENT_LINES:User-Defined Exception (Doc ID 1290744.1)

Last updated on JULY 19, 2016

Applies to:

Oracle Shipping Execution - Version 11.5.10.2 and later
Information in this document applies to any platform.
Executable:WSHINTERFACE - Interface Trip Stop


Symptoms

When attempting to run the Interface Trip Stop (ITS) the following error occurs.

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

OE_Line_Adj_Util:COPY_ADJUSTMENT_LINES:User-Defined Exception
unexp error Process_Request_Pvt
SQL ERROR MESSAGE:User-Defined Exception

LEAVING OE_MSG_PUB.COUNT_AND_GET 1
local split line RET STS : U
error in split_line User-Defined Exception
error in Ship_Confirm_Line User-Defined Exception
error in handle_nonbulk_mode User-Defined Exception
ship_confirm_new UNEXPECTED ERROR : User-Defined Exception
LEAVING OE_MSG_PUB.COUNT_AND_GET 1
rollback to om_ship_confirm :
After OE_Shipping_Integration_PUB.Ship_Confirm_New TIME: ==> 12/16/2010 08:23:38 AM
l_return_status ==> U
NO. OF OE MESSAGES :1
no. of OE messages :1
Calling program unit OE_MSG_PUB.GET
ORA-01422: exact fetch returns more than requested number of rows in Package OE_Validate Procedure Charge Type
Error msg: ORA-01422: exact fetch returns more than requested number of rows in
Package OE_Validate Procedure Charge Type
ERROR

 

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