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

Last updated on AUGUST 14, 2023

Applies to:

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

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