Order Line Stuck At EXPORT_SCREENING_COMPL And Ship Line Workflow In Error

(Doc ID 2371202.1)

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.

Symptoms

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.

Sample order shows the following in the HTMomse.sql output:

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.


Workaround

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.

Other Details

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


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

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