Interface Trip Stop Errors With No Actual Departure Date For Stop Calculate_Freight_Cost API Failed
(Doc ID 3048812.1)
Last updated on SEPTEMBER 19, 2024
Applies to:
Oracle Shipping Execution - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
Interface Trip Stop(ITS) is fails with the following:
P_DELIVERY_ID ==> 1233679404
Entering WSH_FC_INTERFACE_PKG.SOURCE_LINE_LEVEL_COST (WSHFCIFB.pls 120.4) (09/19/2024 01:28:12 AM)
P_STOP_ID ==> 62933060
p_prorated_freight_cost.COUNT ==> 5
BEGINNING OF SOURCE_LINE_LEVEL_COST , STOP_ID: 62933060
l_OE_Curr_Rec.conversion_type_code ==> Corporate
l_OE_Curr_Rec.conversion_rate_date ==>
l_OE_Curr_Rec.conversion_rate ==>
NO ACTUAL DEPARTURE DATE FOR STOP 62933060
WSH_NO_ACTUALL_DEPARTURE_DATE exception has occured.
Exiting WSH_FC_INTERFACE_PKG.SOURCE_LINE_LEVEL_COST - EXCEPTION:WSH_NO_ACTUALL_DEPARTURE_DATE (09/19/2024 01:28:12 AM, 0 seconds)
SOURCE_LINE_LEVEL_COST API FAILED
END OF CALCULATE_FREIGHT_COST
Exiting WSH_FC_INTERFACE_PKG.CALCULATE_FREIGHT_COSTS (09/19/2024 01:28:12 AM, .01 seconds)
CALCULATE_FREIGHT_COST API FAILED
CALCULATE_FAILED exception has occured.
Exiting WSH_FC_INTERFACE_PKG.PROCESS_FREIGHT_COSTS - EXCEPTION:CALCULATE_FAILED (09/19/2024 01:28:12 AM, .01 seconds)
l_return_status ==> E
stop id ==> 62933060
l_lines_tab.count ==> 5
l_ship_adj_line_all.line_id.count ==> 0
process_freight_costs_failed
PROCESS_FREIGHT_COSTS_FAILED exception has occured.
Entering WSH_FC_INTERFACE_PKG.SOURCE_LINE_LEVEL_COST (WSHFCIFB.pls 120.4) (09/19/2024 01:28:12 AM)
P_STOP_ID ==> 62933060
p_prorated_freight_cost.COUNT ==> 5
BEGINNING OF SOURCE_LINE_LEVEL_COST , STOP_ID: 62933060
l_OE_Curr_Rec.conversion_type_code ==> Corporate
l_OE_Curr_Rec.conversion_rate_date ==>
l_OE_Curr_Rec.conversion_rate ==>
NO ACTUAL DEPARTURE DATE FOR STOP 62933060
WSH_NO_ACTUALL_DEPARTURE_DATE exception has occured.
Exiting WSH_FC_INTERFACE_PKG.SOURCE_LINE_LEVEL_COST - EXCEPTION:WSH_NO_ACTUALL_DEPARTURE_DATE (09/19/2024 01:28:12 AM, 0 seconds)
SOURCE_LINE_LEVEL_COST API FAILED
END OF CALCULATE_FREIGHT_COST
Exiting WSH_FC_INTERFACE_PKG.CALCULATE_FREIGHT_COSTS (09/19/2024 01:28:12 AM, .01 seconds)
CALCULATE_FREIGHT_COST API FAILED
CALCULATE_FAILED exception has occured.
Exiting WSH_FC_INTERFACE_PKG.PROCESS_FREIGHT_COSTS - EXCEPTION:CALCULATE_FAILED (09/19/2024 01:28:12 AM, .01 seconds)
l_return_status ==> E
stop id ==> 62933060
l_lines_tab.count ==> 5
l_ship_adj_line_all.line_id.count ==> 0
process_freight_costs_failed
PROCESS_FREIGHT_COSTS_FAILED exception has occured.
The issue cannot be reproduced at will as it is data corruption.
Steps to run the Interface Trip Stop:
1. Order Management Super User Responsibility
2. Shipping > Interfaces
3. Interface Trip Stop
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 |