Line Status Not Progressing To "Awaiting Shipping" After Changing The Shipping From Org
Last updated on AUGUST 02, 2017
Applies to:Oracle Shipping Execution - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Shipping Transactions form
After Export Compliance, the sales order line is failing to progress to an "Awaiting Shipping" status after changing the Shipping From Org to an Org where the shipping parameters are not defined. The ship line workflow activity is in error as follows:
Ship - Line, Manual Ship Exception Error-20001 ORA-20001: OE_Shipping_WF.Shipping_Activity(OEOL, 7941890, 196215, RUN, 20120420521351,6,10,44,46,Shp-E-4E-34) Wf_Engine_Util.Function_Call(OE_SHIPPING_WF.START_SHIPPING, OEOL, 7941890, 196215, RUN)
When the order line is retried either through the application or through the retry_shipline.sql script, the status of the line does successfully progress to an "Awaiting Shipping" status.
Customer does not want to define the shipping parameters for the GLO org because it is a non-shipping org. This worked fine prior to installing Oracle Transportation Management(OTM) . Line status was "Booked" for XXX org. When user updates the warehouse to YYY on the line then the line status used to change to "Awaiting Shipping". But after installing OTM, the error is raised.
NOTE: Debug file from the retry_shipline.sql shows the following:
Entering WSH_SHIPPING_PARAMS_PVT.GET (WSHSPRMB.pls 120.4.12010000.5) (07/22/2014 11:54:13 AM)
P_ORGANIZATION_ID ==> 22
P_CLIENT_ID ==> is NULL
Entering WSH_UTIL_CORE.GET_ORG_NAME (WSHUTCOB.pls 120.21.12010000.7) (07/22/2014 11:54:13 AM)
P_ORGANIZATION_ID ==> 22
ORGANIZATION_NAME ==> GLOBAL
Exiting WSH_UTIL_CORE.GET_ORG_NAME (07/22/2014 11:54:13 AM, 0 seconds)
ERROR: ==> Shipping Parameters not defined for Organization 22
NO_DATA_FOUND exception has occured.
Exiting WSH_SHIPPING_PARAMS_PVT.GET - EXCEPTION:NO_DATA_FOUND (07/22/2014 11:54:13 AM, .01 seconds)
After call to WSH_SHIPPING_PARAMS_PVT.Get x_return_status ==> E
wsh_ship_param_failed exception has occured.
Exiting WSH_EXTERNAL_INTERFACE_SV.GET_WAREHOUSE_TYPE - EXCEPTION:wsh_ship_param_failed (07/22/2014 11:54:13 AM, .01 seconds)
The issue can be reproduced at will with the following steps:
1) Create new order
2) Order 2756389
3) Enter shipping warehouse as “XXX”
4) Book the order
5) Line status shows as “Awaiting export screening”
6) Receive response from GTM
7) Line status changes to “Completed export screening”
8) Change warehouse to “YYY” on the line
9) Line status is not progressing to “Awaiting shipping”
10) Line status: “Completed export screening”
Oracle Transportation Management had been installed.
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