Order Line Stuck At EXPORT_SCREENING_COMPL And Ship Line Workflow In Error
Last updated on MARCH 08, 2018
Applies to:Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Integrations & Conc. Program
All orders that are sent to Global Trade Management (GTM) after running WorkFlow background process show the Line workflow is in Error.
The line workflow is progressed to "Ship Line" activity but the Result is Error.
This makes the order line remain at EXPORT_SCREENING_COMPL instead of progressing to Awaiting Shipping.
Also, because of this no delivery detail is created.
OE_ORDER_LINES shows line 1.1 with flow code = EXPORT_SCREENING_COMPL.
Shipping Interface Flag = N. This is why there is no delivery detail created.
WORKFLOW LINE STATUS ERRORS shows this:
ERR_RETRY_USER = ORA-20001:
ERROR_NAME = OE_Shipping_WF.Shipping_Activity(OEOL, 34134483, 288204, RUN, 20120420521351,6,10,44,46,E5E6,E-33) Wf_Engine_Util.Function_Call(OE_SHIPPING_WF.START_SHIPPING, OEOL, 34134483, 288204, RUN)
LINE PROCESSING MESSAGES shows 4 messages:
User-Defined Exception in Package OE_Shipping_Integration_PVT Procedure Update_Shipping_PVT
User-Defined Exception in Package OE_Shipping_Integration_PVT Procedure Process_Shipping_Activity
User-Defined Exception in Package OE_Shipping_Integration_PVT Procedure Update_Shipping_From_OE
Workflow activity Ship has failed. Please fix the errors and retry the activity from the Order Form or the Workflow Monitor.
Running the "Retry Activities in Error" concurrent program progresses the line workflow to Ship Notified and the delivery details are created.
However, need to prevent the issue from happening so the Retry Activities in Error does not need to be run for every order.
==> Current Behavior: Enter -> Book -> Awaiting Export Screening -> Completed Export Screening (Workflow is stuck at Ship_line)
==> Expected Behavior: Enter -> Book -> Awaiting Export Screening -> Completed Export Screening -> Awaiting Shipping
The issue can be reproduced at will with the following steps:
1. Create sales order
2. Send to GTM for processing
3. Workflow is not creating delivery details after receiving response from GTM
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms