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 OCTOBER 30, 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

_____________________________

Error 4:

local split line RET STS : E
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=Cannot perform scheduling operation because line is shipped
Order Number :107301664  Line Number :16.1
Message :Cannot perform scheduling operation because line is shipped

LEAVING OE_MSG_PUB.COUNT_AND_GET 1
rollback to om_ship_confirm
         After OE_Shipping_Integration_PUB.Ship_Confirm_New TIME: ==> 08/16/2024 07:15:47 AM
         l_return_status  ==> E
         NO. OF OE MESSAGES :1
         Calling program unit OE_MSG_PUB.GET
         Cannot perform scheduling operation because line is shipped
Error msg: Cannot perform scheduling operation because line is shipped
         ERROR
         Rollback to savepoint its_process_order_non_bulk
         No DCP Error

________________________________

Error 5:

ZX_API_PUB.Calculate.Statistics  Number of partner calls     :1
ZX_API_PUB.Calculate.Statistics  Time taken by partner(secs) :10.00000000000000000000000000000000000002
Message returned by tax API ZX_API_PUB.calculate_tax: 28return statusE
Message returned by tax API ZX_API_PUB.calculate_tax: return statusE

LEAVING OE_MSG_PUB.ADD
VertexApplicationException: An error occurred during situs determination. This may be indicative of a loss of database connectivity.  Please retry, and if this problem persists, contact your database administrator.

_________________________________

Error 6:

ship_confirm_new UNEXPECTED ERROR : User-Defined Exception
Entering Procedure Clear_Request in Package OE_Delayed_Requests_Pvt
ENTERING DELETE_ATTRIBUTE_CHANGES -1
LEAVING OE_MSG_PUB.COUNT_AND_GET 3
rollback to om_ship_confirm :
         After OE_Shipping_Integration_PUB.Ship_Confirm_New TIME: ==> 09/04/2024 12:25:14 AM
         l_return_status  ==> U
         NO. OF OE MESSAGES :3
         Calling program unit OE_MSG_PUB.GET
         ORA-20002: 3103: Attribute '.MONITOR_KEY' does not exist for item 'OEOL/XXXXXXX'. in Package OE_ORDER_WF_UTIL Procedure Create_LineFork
         Calling program unit OE_MSG_PUB.GET
         User-Defined Exception in Package OE_ORDER_WF_UTIL Procedure CreateStart_LineFork


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.