My Oracle Support Banner

Interface Trip Stop Ends With Variety Of Errors Where A Single Order Line Has Multiple Split Delivery Details Which Are Not Assigned To Same Delivery ID (Doc ID 3000582.1)

Last updated on JUNE 17, 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.

Examples of errors where ITS attempting to create a new split order line because ITS is being run for only one of the delivery ids assigned to the split delivery
details hence partial shipped qty.

Error 1:

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 :

___________________________

Error 2:

Calling program unit OE_MSG_PUB.GET
         Warning: You are changing a PO number that has already been sent on a shipment for this sales order.
Error msg: Warning: You are changing a PO number that has already been sent on a
shipment for this sales order.

________________________

Error 3:

EXCEPTION IN CALL_PROCESS_ORDER: User-Defined Exception
ERROR IN UPDATE_ATO_LINE_ATTRIBUTESUser-Defined Exception
EXC ERROR IN CHANGE_COLUMNS IN OE_CONFIG_PVT
ERROR IN COPY_CONFIG,OE_CONFIG_PVTUser-Defined Exception
exe error Process_Request_Pvt
Expected error in Process_Request_for_Entity

l_return_status  ==> E
NO. OF OE MESSAGES :1
Calling program unit OE_MSG_PUB.GET
The item specified is invalid or does not exist in the warehouse you specified. Please enter a valid item-warehouse combination.
Error msg: The item specified is invalid or does not exist in the warehouse you
specified. Please enter a valid item-warehouse combination.
ERROR


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.

Changes

 

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
Changes
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.