My Oracle Support Banner

ORA-20001: Unable to build the Supervisor Hierarchy, No Person Record Exists Error When Submitting Any Transaction In SSHR (Doc ID 745430.1)

Last updated on JANUARY 23, 2024

Applies to:

Oracle Self-Service Human Resources - Version 12.0.5 and later
Information in this document applies to any platform.

Symptoms

Problem Statement:
Self Service web pages are erroring out with the following error:

Error
-------
ORA-20001: Unable to build the Supervisor Hierarchy, no person record exists with the person id
#### as of sysdate. Please contact your System Administrator to correct the data issue.

Steps To Reproduce:
------------------------
1. Submit any sshr transaction.
2. Get the error :

ORA-20001: Unable to build the Supervisor Hierarchy, no person record exists with the person id
1432 as of sysdate. Please contact your System Administrator to correct the data issue.

Error Stack: hr_workflow_ss...get_final_approver(HRSSA, 121838)
hr_workflow_ss...allow_requestor_approval(HRSSA, 121838) AME_ENGINE.fetchAttributeValues(186580)
AME_ENGINE.setContext(186581) AME_ENGINE.updateTransactionState(186582)
AME_ENGINE.getNextApprovers(186583) AME_API2.getNextApprovers4(186584)
Wf_Engine_Util.Function_Call(hr_approval_ss.isfinalapprover, HRSSA, 121838, 217504, RUN)

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

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