Interface Trip Stop Error ORA-00001: Unique Constraint (Doc ID 1333668.1)

Last updated on JUNE 19, 2017

Applies to:

Oracle Order Management - Version 12.0.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to submit the Interface Trip Stop program, the following error occurs.

ERROR
-----------------------
error in split_line User-Defined Exception
error in Ship_Confirm_Line User-Defined Exception
error in handle_nonbulk_mode User-Defined Exception
ENTER Save_API_Messages
l_errmsg User-Defined Exception
L_MSG_DATA=Validation failed for the field - Shipping Method
Order Number :140841 Line Number :
Message :Validation failed for the field - Shipping Method
L_MSG_DATA=ORA-00001: unique constraint (ONT.OE_ORDER_LINES_U1) violated in Package oe_line_util Procedure Insert_Row
Order Number :140841 Line Number :
Message :ORA-00001: unique constraint (ONT.OE_ORDER_LINES_U1) violated in Package oe_line_util Procedure Insert_Row
EXIT Save_API_Messages
ship_confirm_new UNEXPECTED ERROR : User-Defined Exception
LEAVING OE_MSG_PUB.COUNT_AND_GET 2
rollback to om_ship_confirm :
After OE_Shipping_Integration_PUB.Ship_Confirm_New TIME: ==> 06/13/2011 11:25:09 AM
l_return_status ==> U
NO. OF OE MESSAGES :2
no. of OE messages :2
Calling program unit OE_MSG_PUB.GET
Validation failed for the field - Shipping Method
Error msg: Validation failed for the field - Shipping Method
Calling program unit OE_MSG_PUB.GET
ORA-00001: unique constraint (ONT.OE_ORDER_LINES_U1) violated in Package oe_line_util Procedure Insert_Row
Error msg: ORA-00001: unique constraint (ONT.OE_ORDER_LINES_U1) violated in Package oe_line_util Procedure Insert_Row
ERROR
Rollback to savepoint its_process_order_non_bulk
No DCP 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