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 APRIL 17, 2023

Applies to:

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

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