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.


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.

You have encountered an unexpected error


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

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


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