Category Archives for "Quick Reference"

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 reading

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

Microsoft 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

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

Perl Cheat Sheet

As a PeopleSoft admin, you will most likely need to work with Perl language. Though there isn’t a need to master Perl language, it is definitely a great language to learn. There are many commands in Perl, which you just need to keep handy and you will be able to write powerful and efficient programs. […]

Continue reading

MS-DOS Command Reference Cheat Sheet

As a PeopleSoft admin and a PeopleSoft developer, you will have plenty of occasions to create batch files and having competitive MS-DOS skills will go a long way helping you write super efficient code. There is a great book on Windows Command-Line Pocket Reference if you’d like to use. In this post, you will find […]

Continue reading

vi Command Reference Cheat Sheet

This vi editor command reference cheat sheet presents the majority of vi commands and keys. We hope you find it useful. We also recommend two good books on vi (mentioned below). How to Use Unix-Linux vi Text Editor vi Pocket Reference vi Command Reference Cheat Sheet Invoking vi: vi filename Command mode versus input mode […]

Continue reading

Ubuntu Reference Cheat Sheet

As a PeopleSoft admin, you will need to work with Ubuntu, but you do not need to an expert of Ubuntu. All you need to be good at are a few things only. If you want to be great at Ubuntu – you should get the book Ubuntu Unleashed 2013 Edition. Ubuntu Reference If you want […]

Continue reading