‘ORA-20001: Unable to build the Supervisor Hierarchy " when a terminated user involved

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: ‘ORA-20001: Unable to build the Supervisor Hierarchy " when a terminated user involved
When Submitting SSHR transaction, employee is getting a error Unable to create supervisor hierarchy even if approval is not required from the supervisor in the hierarchy who is terminated






Symptoms:
When Submitting SSHR transaction, employee is getting a error Unable to create supervisor hierarchy even if approval is not required from the supervisor in the hierarchy who is terminated


Log files:



Solution:



What you are reporting is the standard functionality of the system.

No terminated employees should exist in the complete approver chain.

Even if you have restricted approval up to 2 levels and have an employee at level 5 who is terminated, you will face the error "Unable to build Supervisor hierarchy ... "

As a business practice it is recommended that whenever an employee is terminated, his record should be removed from all the approval hierarchies.

The system will throw an error if any person within the approval hierarchy is terminated even if the person is not actually involved in the approval.

Apply patch 6960124 could help

This may be a problem at the customer end due to presence of terminated people in approval hierarchy.
As for AME, no terminated employees should exist in the approver chain.
Please check that.

In another forum response:

http://myforums.oracle.com/jive3/thread.jspa?messageID=4848395?

Issue: Receiving error message when employee attempts to enroll in a class. The employee's direct supervisor is still employed but the supervisor's supervisor has been terminated. The issue looks similar to Metalink ID 745430.1 but we are running Release 12.1.1 hrapcuwf.pkb 120.6.12010000.4 so the patch is not appropriate.


You cannot have terminated people in the hierarchy.
What has been fixed through bug mentioned in metalink note 745430.1 is even when there were no terminated people in hierarchy it was throwing this error. That fix is already present in 12.1.1.

Anyway You cannot have terminated people in the hierarchy.

References:

Note 745430.1 ‘ORA-20001: Unable to build the Supervisor Hierarchy, No Person Record Exists Error When Submitting Any Transaction In SSHR’ . . .

Get Oracle Certifications for all Exams
Free Online Exams.com