AGIS: When Query an End Dated Employee in a Future Date on AGIS Security Page Workflow Errors with ORA-20215: An invalid approver has been encountered in ame_engine.fetchRuntimeGroup:FUN Recipient Approval Group (Doc ID 1964195.1)

Last updated on OCTOBER 10, 2022

Applies to:

Symptoms

End dated employees are not visible on the Advanced Global Intercompany System (AGIS) Security Page for the last day of assignment.

When an employee joins a company, they get an HR assignment which is controlled by a start and end date. If anything changes for that employee, the original assignment's end date gets updated and a new assignment is created which has a new start and end date.

For example :
===========
The approver has had an HR assignment end dated (31-OCT-YYYY) and a new assignment created (start date = 01-NOV-YYYY).
On 31-OCT-YYYY a charge was sent through to the Organization that the above approver was assigned to. Due to the transaction date being equal to the assignment end date (31-OCT-YYYY), the workflow errored for all the
transactions. This should not have happened as the User in question is still active till 24h00 on 31-OCT-YYYY. The Workflow however does not seem to take time into account.
===========

The following errors can be seen .

Action Required: Error in Workflow
FUNIMAIN/12345_XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

or

ORA-20215: An invalid approver has been encountered in ame_engine.fetchRuntimeGroup:FUN Recipient Approval Group.
Please remove the invalid approver.

The above error results in all transactions regardless of Transaction Type erroring out for the AGIS Recipient Organization.

Changes

Cause

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