AME: Purchase Requisitions Can Be Self Approved Unexpectedly When Using Dynamic SQL in AME Approval Groups (Doc ID 1674136.1)

Last updated on JUNE 19, 2017

Applies to:

Oracle Purchasing - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

When using a dynamic approver group in the Approval Management Engine (AME) Approval Rules, if the dynamic SQL returns no records the Requisition can be self approved unexpectedly.

What is expected, is if no AME Approvers are returned from the AME Approval Group(s), then the Requisition should not be self approved.

STEPS
The issue can be reproduced at will with the following steps:
1. Create a requisition where an AME Rule applies when dynamic approver group is used and this dynamic query returns 0 records.
2. The Requisition worklfow returns result "no appprovals required" and the requisition can be self approved.

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