Ship Confirm Error Ora-20001 OE_SHIPPING_WF.Shipping_activity (Doc ID 421639.1)

Last updated on JULY 19, 2016

Applies to:

Oracle Shipping Execution - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 08-May-2013***
***Checked for relevance on 13-May-2015***

Symptoms

When attempting to Ship confirm sales order lines following error occurs

ERROR
ora-20001 oe_shipping_wf.shipping_activity

STEPS
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:
ORA-20001 OE_SHIPPING_WF.SHIPPING_ACTIVITY

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

Cause

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