Help With Purchase Order / Requisitions that are In Process or Pre-Approved Status with Cancelled Workflow or Missing Workflow

(Doc ID 1273245.1)

Last updated on MAY 14, 2018

Applies to:

Oracle Purchasing - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 28-JUL-2014***

Symptoms

Find when canceling a pending workflow for a Purchase Order (or Requisition), the backing Purchase Order or Requisition that the workflow is for, does not get changed back to its original status. When the workflow is canceled, the purchasing document remains in an 'In Process' or 'Pre-Approved' status and then there is no way to get the document moved to an approved status, other than to use a data fix.

EXPECTED BEHAVIOR
-----------------------
Expect that when a canceled Purchase Order Workflow occurs and the workflow was pending a response from an approver, the backing Purchase Order or Requisition should get reverted back to its original status, either Incomplete or Requires Reapproval (if a Purchase Order that has been approved previously) or as an alternative, prevent the cancellation of the workflow in the first place.  

STEPS
-----------------------
The issue can be reproduced at will with the following steps (this example is for Purchase Orders but can also be applied for Requisitions).
1. Purchase Order was created and approved
2. Purchase Order was pending an approver
3. Purchase Order Workflow was canceled but still the Purchase Order status is displayed as 'In Process' or 'Pre-Approved'.

IMPORTANT NOTE:   Once the workflow is canceled, if the concurrent program "Purge Obsolete Runtime Workflow" is scheduled to run, eventually the workflow can get purged.  The reason is because the cancellation of the workflow has ended the workflow.  Once the workflow is ended, it is a candidate to get purged.   The status of the purchasing document itself is not considered when purging workflows, as only the workflow data is used for that consideration.  This explains how In Process and Pre-Approved documents can exist without any workflow data.  

Changes

 

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