How to Delete Company Directory Trees (Doc ID 1481587.1)

Last updated on SEPTEMBER 04, 2016

Applies to:

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

Goal

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.


 

Solution

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