Apurva Tripathi
Author Archives: Apurva Tripathi
Apurva Tripathi
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 readingHow to Enable COBOL Trace in PeopleSoft
COBOLs are an integral part of PeopleSoft. If your PeopleSoft base has NA Payroll, Global Payroll or Payroll Interface modules installed, you’re likely to come across COBOL issues once a while. Some of these might need to enable COBOL trace for further troubleshooting. You can enable COBOL trace in PeopleSoft in both two tier and […]
Continue readingPSQuery Tables
PSQuery tables are all PeopleTools tables. Here is the complete list of PeopleTools meta tables that store all the possible information about PSQueries. The below list of PSQuery tables is correct for PeopleTools 8.57 release. It could vary slightly in earlier and later versions. This list is super helpful in situations when you might need […]
Continue readingPeopleSoft 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