My Oracle Support Banner

Line Status Not Progressing To "Awaiting Shipping" After Changing The Ship From Org And Errors With Ship - Line, Manual Ship Exception Error ORA-20001: OE_Shipping_WF.Shipping_Activity (Doc ID 1924774.1)

Last updated on MAY 16, 2023

Applies to:

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


After Export Compliance, the sales order line is failing to progress to an "Awaiting Shipping" status after changing the Ship 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

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.

User does not want to define shipping parameters for the XXX 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 order line then the line status would change to "Awaiting Shipping". However, 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)
  Entering WSH_UTIL_CORE.GET_ORG_NAME (WSHUTCOB.pls 120.21.12010000.7) (07/22/2014 11:54:13 AM)
  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
  l_shipping_param_info.otm_enabled ==>
  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) Order Management Super User Responsibility
2) Create new sales order
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 is recently installed.


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

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