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 laterInformation 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 |