Dynamic Approver Group Error When Passing Text 'PERSON_ID:' to AME Engine (Doc ID 1367638.1)

Last updated on JULY 18, 2016

Applies to:

Oracle Approvals Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Upgrade from 11.5.10 ==> 12.1.3
Customer is stating that there is a change of behavior in the way the AME engine is handling Dynamic Approval Groups.

Customer has setup a dynamic approval group where the logic is
select 'person_id:'||custom_function() from dual;
Now the custom_function() either returns a valid person_id or NULL (if no one was found).

Whenever the custom_function() returns a valid person_id everything works fine.
However when it returns NULL it passes the string 'person_id:' to the AME engine and the calling application errors out stating that the approver list can not be generated.

ie ... logic is as follows
. select 'person_id:'||custom_function() from dual;
= select 'person_id:'||null from dual;
= select 'person_id:' from dual;
= 'person_id:'


ERROR IN APPLICATION
---------------
Approval List could not be generated. Please contact your System Administrator to review AME rules setup.


CUSTOMER EXPECTED BEHAVIOR
---------------
No error to be displayed and no approvers to be listed
(customer states that this was the behavior in 11.5.10.

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