Process_Order API - APP-ONT-251208 - Line Workflow Not Created when Creating and Cancelling SO Lines on the Same Session. (Doc ID 2038208.1)

Last updated on AUGUST 07, 2017

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.
*** Checked for relevance on 07-Aug-2017 ***

Symptoms

When using the oe_order_pub.process_order API, the workflow of the sales order line is not getting created when there are lines being created and cancelled within the same session. 

When trying to view the workflow of the sales order line using Menu from Sales Order form -> Tools -> Workflow status, the following error is received:


ERROR

APP-ONT-251208: Workflow status is not available.The workflow history may be purged.

The process flow is as follows:

  1. Order is entered using Sales Order form with one line and saved.  The workflow of the Line is created.
  2. When the Order is BOOKED, during booking process the workflow calls a custom process that implements a business logic to check if the item is superseded and if it is, then oe_order_pub.process_order is called with the superseded item to  create a new line.  Line 2.1 is created and the order line workflow is kicked off for this line.  The business logic again checks the availability of this item in the Warehouse that is on the Order line.
  3. If the superseded Item on the line 2.1 is not available in the warehouse, then oe_order_pub.process_order API is called to change the warehouse on the line where Item is available and then create a new line, line 3.1 and also Cancel the line 2.1 in same session.  The new line 3.1 is created successfully however, no workflow is created for this line.

 

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