Apurva Tripathi | PeopleSoft Tutorial

Apurva Tripathi

Author Archives: Apurva Tripathi

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

Running a PeopleSoft COBOL in a Unicode Environment

The character set that is used for PeopleSoft COBOL processing must match the character set for your database. If you created a Unicode database for the PeopleSoft system, you must also run COBOL in Unicode. The Unicode standard provides several methods of encoding Unicode characters into a byte stream. Each encoding has specific properties that […]

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

How to Add Custom Indexes in PeopleSoft

PeopleSoft comes with highly normalized tables and indexes to support them. When you start charting the path of doing customization, you are likely to come across a situation when a SQL does not run fine. One of the likely reason for a poor performing SQL is that there isn’t a proper index to support the […]

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

« Previous 1 … 45 46 47 48 Next »