Prashant

Author Archives: Prashant

Find PeopleSoft Navigation for a component using SQL

You can use below SQL to find PeopleSoft Navigation to a component. In below SQL replace the value of PORTAL_URI_SEG2 with your component name. SELECT DISTINCT REVERSE(LTRIM(SYS_CONNECT_BY_PATH (REVERSE(PORTAL_LABEL),’ >- ‘),’ >- ‘)) “NAVIGATION” FROM PSPRSMDEFN P WHERE PORTAL_OBJNAME = ‘PORTAL_ROOT_OBJECT’ START WITH PORTAL_URI_SEG2 = ‘PRCSDEFN’ — Replace with your Component Name CONNECT BY PRIOR PORTAL_PRNTOBJNAME […]

Continue reading

Faster Way to find solution on Oracle Support

​Have your tried to search for a solution on Oracle Support but you get similar search results even if you change your search term? Not sure if it happened with you but it has sure happened a lot with us.  Looks like Oracle has few top results (may be popular) that are ranked higher than […]

Continue reading
1

How To Change PS stylesheet using SQL

Stylesheets as the name suggests is the piece of code that adds style to your PeopleSoft application. When you log into PeopleSoft application, all the menus, colors , design are controlled by stylesheets. PeopleSoft application comes with a default stylesheet which can vary between different Application releases. Here are the default stylesheets for different PS […]

Continue reading

Difference between PeopleSoft Cloud Architecture and PeopleSoft Cloud Manager

It’s very easy for someone to get confused with PeopleSoft Cloud Architecture and PeopleSoft Cloud Manager but both have really simple explanation. One is referred to the set of features use to get cloud like features and another is used to move and deploy in-house PeopleSoft environments to Oracle Cloud. Difference between PeopleSoft Cloud Architecture […]

Continue reading

What is Puppet and what’s its significance in PeopleSoft?

If you’re familiar with PeopleTools 8.55 , then you must have heard about DPKs. DPK are the deployment kits which automates the installation and configuration of PS environment. DPK uses Puppet and Hiera for performing these automation and configuration tasks. What is Puppet? Puppet is an open source configuration management tool and produced by Puppet […]

Continue reading

What is PeopleSoft DPK?

With release of PeopleTools 8.55, Oracle introduced the concept of DPK i.e. Deployment Kits. Before we discuss about DPKs, we need to learn about how PeopleSoft system works. You might already know that PeopleSoft architecture comprises of different layers i.e. Database Server, Application Server, Web Server and Process Scheduler. When you deploy a PS environment, […]

Continue reading