ORA-00001 Unique Constraint PS_PSTREENODE - The Selected Person Does Not Exist In The Company Directory Tree

(Doc ID 2320991.1)

Last updated on OCTOBER 25, 2017

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When Attempting to Search the Company directory with Employee Last Name, Search is working but When you click on the Name,
the following error occurs.

ERROR
-----------------------
The selected person does not exist in the Company Directory Tree

Below error is found in the Trace file,

Return: 805 - ORA-00001: unique constraint (ORHRPRD.PS_PSTREENODE) violated

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Main Menu ~ Company Directory
2. Search with Employee Last Name
3. Click on Employee Name/Title, the above error occurs

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