My Oracle Support Banner

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 SEPTEMBER 21, 2018

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


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:


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.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.