Ship Confirm Error Ora-20001 OE_SHIPPING_WF.Shipping_activity

(Doc ID 421639.1)

Last updated on DECEMBER 05, 2017

Applies to:

Oracle Shipping Execution - Version to [Release 11.5.10]
Information in this document applies to any platform.


When attempting to Ship confirm sales order lines following error occurs

ora-20001 oe_shipping_wf.shipping_activity

The issue can be reproduced at will with the following steps:
Order Management Super user->Sales order -> Enter and book order
Order Management Super user->Shipping-.Transaction

This error will manifest in Workflow from Ship confirm process:

OE_Shipping_WF.Shipping_Activity(OEOL, 1987, 161990, RUN, 20120420521351,6,10,44,46,Shp-E-4E-34)
Wf_Engine_Util.Function_Call(OE_SHIPPING_WF.START_SHIPPING, OEOL, 1987, 161990, RUN)

Debug of the Ship Confirm will show the following:

Failed to import the order line because Create_Delivery_Details failed
Creation of the delivery details failed because of Error: Failed to import
the order line because Create_Delivery_Details failed.:Unexpected Error: Error in Routine




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