My Oracle Support Banner

Interface Trip Stop Errors With ORA-00001:unique Constraint(ONT.OE_ORDER_LINES_U1) Violated In Package Oe_line_util For Single Line With Multiple Split Delivery Details Not Assigned To Same Delivery ID (Doc ID 3000582.1)

Last updated on FEBRUARY 01, 2024

Applies to:

Oracle Shipping Execution - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

Interface Trip Stop (ITS) errors with the below for a single order line containing multiple split delivery details that are not assigned to the same delivery id.

SCH: AFTER CALLING PROCESS ORDER
X_RETURN_STATUS IS U
RR: UNEXP ERRORED OUT
4.1:U
ERROR SAVE_SCH_ATTRIBUTES User-Defined Exception
SCHEDULING RESULTS OF THE LINES:
LINE ID : XXXXXX
SCHEDULE STATUS : SCHEDULED
LINE ID : XXXXXXX
SCHEDULE STATUS : SCHEDULED
EXITING SPLIT_SCHEDULING WITH U
After Calling Split Scheduling: U
unexp err

local split line RET STS : U
here 12 index is 1
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=ORA-00001: unique constraint (ONT.OE_ORDER_LINES_U1) violated in Package oe_line_util Procedure Insert_Row
Order Number :XXXXXX Line Number :


The issue can be reproduced at will with the following steps:

1. Order Management Super User Responsibility
2. Shipping > Transactions
3. Ship Confirm order launching Interface Trip Stop.
4. ITS fails with error.

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


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