Quickest way to find hidden portal objects [SQL]
You can hide PeopleSoft portal objects (e.g. content reference) from PeopleSoft Navigation. This can be done by navigating to ‘Structure and Content’ and selecting the checkbox ‘Hide from portal navigation’. Navigate to PeopleTools > Portal > Structure and Content Incase you don’t have access to this page to view the configuration, you can check this […]
Continue reading
How to monitor connections to PeopleSoft Database
Ever wondered how many users are connected to PeopleSoft database? This is different than users who login into PeopleSoft application via web. You can find users who make direct SQL connection with your PeopleSoft database. This includes anyone using SQL client tool, PeopleSoft development tools and connections made by PeopleSoft server such as application server […]
Continue readingFind 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
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
Learning Oracle SQL the Easy Way
If you plan to use Oracle – the most powerful database in the world, there is one skill you need to learn anyhow whether you want to become Oracle PL/SQL programmer or Oracle database administrator. The skill is SQL. The greatest fact about learning SQL is that the skill works across databases. Even if tomorrow […]
Continue reading