iAssets Receiving Approval Workflow Error "failed activity, get next approver" Using a Custom Function in AME Approver Group (Doc ID 2960199.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

Defining an iAssets transfer custom receiving approval and the workflow is failing in Approval Management Engine (AME) as it is unable to determine an approver.

Steps to replicate the issue:
--------------------------------
1) In iAssets, define transfer release and receiving setups.
2) In AME define related approval flows and approver groups.
3) The receiving approval group is defined as a custom function:

LOG_ID    PACKAGE_NAME  ROUTINE_NAME      TRANSACTION_ID APPLICATION_ID EXCEPTION_NUMBER  EXCEPTION_STRING
4481987 ame_engine         fetchRuntimeGroup   12038                       -161                       -20109            YYYY:MM:DD:HH:MM:SS The approver group CUSTOM_APPROVAL_CC has dynamic query in wrong format.
ETC....

Changes

 This is a new setup and has not worked with success in the past.

Cause

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