Apurva Tripathi

Author Archives: Apurva Tripathi

Apurva is a PeopleSoft consultant and a big advocate of everything PeopleSoft. He is also a technology enthusiast and loves learning and implementing newer and open source technologies. He spends his spare time updating this blog and likes to read books on self help and productivity.

PSQuery Not Running

Came across a situation where the PSQuery does not run even after you click of ‘Run’ or ‘Run to Excel’ or ‘Run to HTML’. This post is to address such situations. On clicking these buttons/links nothing happens and the page(browser) remains AS-IS instead of launching new window to run the PS-Query where it would also […]

Continue reading

PSQuery Tables

PSQuery tables are all PeopleTools tables. Here is the complete list of PeopleTools meta tables that store all the possible information about PSQueries. These tables are specific to Tools version 8.50 and could vary slightly in earlier and later versions. There are situations when you might need this list of tables, like when you need […]

Continue reading

PeopleSoft License Codes

PeopleSoft license codes are needed when you do a fresh install of a PeopleSoft demo or any other install. You also need this license code when you apply PeopleSoft application bundles and patches or when you do PeopleTools upgrade or apply a patch. If your customer already has a license, you can very well get […]

Continue reading
1

SQL to Retrieve Navigation of a Process in PeopleSoft

Following SQL is used to find out all Processes Defined in PeopleSoft System. Additionally this query also provides Components attached with Process Definition and Navigation from where this process can be executed. This query is tested on Oracle platform. Select S.prcsname,S.prcstype, S.pnlgrpname,N.navigation From (Select A.prcsname, A.prcstype,B.pnlgrpname From PS_PRCSDEFN A, PS_PRCSDEFNPNL B Where A.prcsname = B.prcsname) […]

Continue reading

How to Find Unused Permission List in PeopleSoft

How to Find Unused Permission List in PeopleSoft   SELECT * FROM PSCLASSDEFN A WHERE NOT EXISTS ( SELECT ‘X’ FROM PSUSERCLASSVW B WHERE A.CLASSID = B.CLASSID ) AND NOT EXISTS (SELECT ‘X’ FROM PSOPRDEFN B WHERE A.CLASSID = B.OPRCLASS) AND NOT EXISTS (SELECT ‘X’ FROM PSOPRDEFN B WHERE A.CLASSID = B.PRCSPRFLCLS) AND NOT EXISTS […]

Continue reading
1

PeopleSoft Cobol Compiler Options

Purpose of this article is to answer FAQs about PeopleSoft and COBOL Compilers and let you know the PeopleSoft Cobol Compiler options you have. Some PeopleSoft applications use routines written in COBOL. Since COBOL is primarily suited to batch processing, you’ll likely use COBOL with applications like PeopleSoft Payroll. There are two components for running […]

Continue reading

PeopleSoft Remote Cobol Error

While running a PeopleSoft appengine program, especially in case of Payroll Interface appengine program, PI_PIRUN, you are likely to encounter a situation where the app engine program fails with an error, which is similar to “…..did not complete in allowed time (50 seconds). Killing process (2, -1)” If the process is submitted to the process […]

Continue reading
1 10 11 12