Purchase Order Stuck 'In Process' With no Workflow Associated When There is a Circular Loop in the Hierarchy (Doc ID 814780.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Purchasing - Version: 11.5.10.2 to 11.5.10.4 - Release: 11.5 to 11.5
Information in this document applies to any platform.
Checked for currency on 6-MAR-2012

Symptoms

When using the Employee Supervisor hierarchy and there is a loop in the hierarchy, the workflow gets stuck when the approvers have no authority to approve the document.

The issue can be reproduced at will with the following steps:
1- Enter a Purchase Order for an amount greater than any supervisor can approve.
2- Submit the PO for approval
3- No notification comes back to the originator that an approver could not be found and the PO remains stuck with a status of 'in process'.

The wfstat output will show empty for the item key associated to the purchase order. However the trace reflects a loop in the workflow between the activities: PO_REQAPPROVAL_ACTION.VERIFY_AUTHORITY and
PO_REQAPPROVAL_FINDAPPRV1.GETMGR_HR_HIER.

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