Configure PeopleSoft WorkCenter

How to Configure WorkCenter in PeopleSoft

Creating a workcenter in peoplesoft is a pretty easy process. In this post I will teach you a step by step process on how to configure a workcenter in peoplesoft. I completed these steps using PeopleSoft Financials 9.2 with PeopleTools 8.55.15. 1. Configure Navigation Collection PeopleTools > Portal > Portal Utilities > Navigation Collections Click Add Collection …

Continue reading How to Configure WorkCenter in PeopleSoft


Flattening PeopleSoft Summer Tree

If you need to denormalize or flatten PeopleSoft summer trees (trees with leaves) in your data warehouse, here is an ETL process for you to follow. Typical PeopleSoft summer tree structure SQL to flatten the PeopleSoft summer tree Substitute TREE_NAME with the name(s) of your summer tree(s) on line 54 below. Result of the SQL …

Continue reading Flattening PeopleSoft Summer Tree