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. This SQL will work most of the time but in some cases you might have to validate the component name from PSMENUITEM, PSAUTHITEM table. There is an alternate way to […]
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
SQL Query to find Records and Fields used in a PeopleSoft Page
Many a times you come across a situation when you need to find records behind a page or records associated with a field and so on. Most of such situations arise from the need to debug an issue and find a resolution for the same. In this article you will find a few helpful SQL […]
Continue reading