My Oracle Support Banner

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

Last updated on APRIL 16, 2021

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.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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