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 MARCH 03, 2021

Applies to:

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

Symptoms

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.



ERROR
==========

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
  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)



STEPS
==========
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”

Changes

 Oracle Transportation Management is recently installed.

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.