Populating Tree Selector Tables in PeopleSoft

Hello All,

If you’re using Tree Selector tables for Department, Business Unit security, once you make changes to the Tree , the tree values in tree selector tables are deleted – while you can use nVision to populate the Tree Selector tables, PeopleSoft PS Query provides an easy a way to populate tree selector tables.

Provided below are the steps:

Step 1: Identify the tree whose tree selector table has to be refreshed

Step 2: Navigate to Main Menu > Reporting Tools > Query Manager > New Query


Step 3: Add a table of  your choice to the PS Query


Step 4: Select any field from the table selected in Step 3


Step 5: Add a new criteria using the Criteria tab



Step 6:  Choose a field as Expression 1 type and change the Condition Type to in tree. Also, click on the Tree Option radio button and click on the New Node List link


Step 7: Enter the tree identified as part of Step 1 and click on Search


Step 8: Click on the Icon_1.jpg icon to the right of the root node


Step 9: Ensure that the selected note has been added to the Selected Nodes List group box


Step 10: Ensure that the selected nodes have been populated in the Criteria page

Step 11 : Click on OK and run the PS Query

Step 12: The Tree Selector tables will now be populated with requisite data

Hope this helps!

Have fun! 🙂


About Manikandan Surendren

A PeopleSoft Techno-functional Consultant. An engineering graduate in Computer Science. Technology Enthusiast. Movie freak. Gadget geek.
This entry was posted in Code, PeopleSoft, PeopleSoft HCM and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s