Home » Applications » Oracle Fusion Apps & E-Business Suite » After calling an Activity in Workflow proceeding is Deferred
After calling an Activity in Workflow proceeding is Deferred [message #229541] Mon, 09 April 2007 02:01
Messages: 18
Registered: March 2007
Location: Ireland and Boston
Junior Member

11.5.10 cu2 OPM

A preexisting Workflow Process in Oracle for a type of Sales Order Process we use.

There is a particular point in the process where the User manually clicks on the Activities Button in the Sales Order Window and chooses Progress Order and then an activity that is a notification in the workflow to continue processing.

The problem is that I am trying to automate this notification step so that is sent via a pl/sql call to the Workflow process as follows:
WF_ENGINE.CompleteActivity('OEOL', to_char(pc_line_no), 'BIO_CLOSE_ELIGIBLE', 'No');

OEOL: Sales Order Line Doc Type
pc_line_no = Sales Order Line in Question
'BIO_CLOSE_ELIGIBLE' = The Internal Name of the Notification, which has the Status of Notify if checked in the Workflow diagram and required by the documentation for the WF_ENGINE.CompleteActivity API documentation
'No' = This is supposed to be the result of the activity. I've also tried NULL but same result.

What happens is that when performed manually the Sales Order Line follows the remaining steps of the workflow all the way through closed.
But when using WF_ENGINE.CompleteActivity to automatically create the notification then the next activity in the workflow immediately goes to a DEFERRED state. The only way to proceed is to run the Background Concurrent Request which clears DEFERRED activities.

Any suggestions as to why the next activity is going directly to DEFERRED when using the PL/SQL notification and how to fix it
would be great.
Previous Topic: Process Order API - Unreserving a Sales Order in Oracle
Next Topic: Fusion
Goto Forum:

Current Time: Fri Oct 28 19:11:33 CDT 2016

Total time taken to generate the page: 0.10298 seconds