SQL – PeopleSoft Tutorial

Tag Archive

Tag Archives for " SQL "

SQL Tip: Find PS Query set on recurrence

Want to find out the queries that are set to run on recurrence? Here is a SQL that you can run.

SQL Tip : Find users logged into PeopleSoft PIA with this SQL

Here is a quick SQL that you can run to find out PeopleSoft users that are logged into PeopleSoft via PIA web login.

Find Size of PeopleSoft Tables and indexes [SQL]

What is the biggest pain for PeopleSoft Admins/DBA or any PeopleSoft consultant supporting the application? That’s when performance of PeopleSoft application is really sluggish. There are hundreds of things that could go wrong and one of those is directly related to size of your PeopleSoft database. PeopleSoft database consists of PeopleSoft Tables, indexes and few other objects […]

SQL to find when PeopleSoft table was built and analyzed in Oracle

Ever wondered when a PeopleSoft table was last built / altered or when its database stats were gathered ? Many times, you need to know that information to analyze what’s happening with a table. For example, your table may not be working correctly or the performance may be degraded. You may want to check when was the […]

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 […]

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 […]

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 […]

1 2 Next »