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 DECEMBER 09, 2016

Applies to:

Oracle General Ledger - Version 12.1.1 and later
Oracle Financials Common Modules - Version 12.1.1 and later
Information in this document applies to any platform.
Advanced Global Intercompany System (AGIS)

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 it's HR assignment end dated (31-OCT-2013) and a new assignment created (start date = 01-NOV-2013).
On 31-OCT-2013 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-2013), 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-2013. The Workflow however does not seem to take time into account.
===========

The following errors can be seen .

Action Required: Error in Workflow
FUNIMAIN/99849_624089E9F98136126B57F0E044002128D63AC6

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.

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