My Oracle Support Banner

ORA-00001 Unique Constraint PS_PSTREENODE - The Selected Person Does Not Exist In The Company Directory Tree (Doc ID 2320991.1)

Last updated on SEPTEMBER 26, 2019

Applies to:

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


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.

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

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


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

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