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

To view full details, 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 a vibrant support community of peers and Oracle experts.