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.
Continue reading
This tip could save you time when you’re stressing out to find a solution on MOS
Quick tip that you use to review not just 10 but 100 support articles at once.
Continue reading
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.
Continue reading
1
List of PUM Tables
PeopleSoft Update Manager or PUM has become part of daily life of PeopleSoft consultants and so has the task of troubleshooting issues related to PUM. While troubleshooting an issue related to PUM, I had the need to look at some PUM tables and felt that you may also have a need for the same. Hence, […]
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 readingMicrosoft Excel 2013 CheatSheet
Microsoft Office Excel 2013 needs no introduction – it is a must know skill for anyone who works in a office environment. While Excel is a very powerful software, its subtle appearance doesn’t overwhelm the user and they use minimum features of Excel. If you want to be a powerful ninja Excel user, you need […]
Continue reading
1
Oracle PL/SQL Cheat Sheet
PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation’s procedural language extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7) and IBM DB2 (since version 9.7). Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. While PL/SQL is easy to learn, it can […]
Continue reading