My Oracle Support Banner

How to Delete Company Directory Trees (Doc ID 1481587.1)

Last updated on JUNE 22, 2022

Applies to:

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


Question 1 : Nightly the company directory tree is rebuilt using "create/replace tree". This creates an effective dated tree per day.  Is it possible to delete the old trees in a controlled/automated manner?  Tree manager can be used but it only allows for selecting one at a time.

Question 2 :  Tree node is not populated in the PSTREENODE table and this node has been inserted into the job tree exception table (HRCD_JOBTR_EXCP) whenever run the Job Tree Builder process manually for the current dated Effective date tree. The same issue happened when the Job Tree Builder process is scheduled for nightly run as well.

But there is no issue when the Job Tree Builder process run with back dated Tree Effective date.



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.