Break in Supervisor Hierarchy Generates Error For All AME Rules (Doc ID 2010498.1)

Last updated on JULY 02, 2017

Applies to:

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

Symptoms

On : 12.0.6 version, AME Setup issues

When attempting to approve a transaction when the AME rule uses an approval group with dynamic sql and no reference to the supervisor hierarchy
the following error occurs only when the transaction initiator has a broken supervisor hierarchy chain eg his supervisor is an ex-employee.

ERROR
-----------------------
You have encountered an unexpected error

or

Unable to build the Supervisor Hierarchy, no person record exists with the person id xxxx as of sysdate

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. AME setup with dynamic sql for approver groups not referencing supervisor hierarchy
2. employee has an ex-emp as his supervisor
3. same employee enrolls on a course using OLM
4. enter details and press the 'Review' button and get the error



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