Changing Password of PTWEBSERVER id in PeopleSoft

Change the password of the PTWEBSERVER in PeopleSoft PTWEBSERVER is the default user id that is used when creating a new PeopleSoft webserver domain. To avoid any issues this id should only be used for webserver domain configuration. If password of this user id gets changed then your webserver may not boot up properly. In […]

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

Vi Editor for PeopleSoft DBA

 VI Editor commands for PeopleSoft DBA Movement Commands Character h, j, k, l Left, down, up, right Text w, W, b, B Forward, backward by word e, E End of word (, ) Beginning of next, previous sentence {, } Beginning of next, previous paragraph [[, ]] Beginning of next, previous section Lines 0, $ […]

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

PeopleSoft Application Server Configuration

Before you can start using the PeopleSoft application, you need to configure the PeopleSoft Application Server. This post details how to configure a PeopleSoft Appplication Server using PSADMIN utility then simply follow the below steps. Below document is prepared for PT 8.45 and can be used to configure application server domain on other PeopleTools versions […]

PeopleSoft Process Scheduler Run Status Codes

PeopleSoft Process Scheduler run status codes are very important. This is because these run status codes are not visible online and you will need them in case a process or a job has not run properly. You might need to find out the possible reasons of why a job or a process has malfunctioned and […]

JRE Path Not Found While Installing PIA

$ setup.solaris -console InstallShield Wizard Initializing InstallShield Wizard… Searching for Java(tm) Virtual Machine… …………………………….. …………………………….. …………………………….. …………………………….. ……………………………… ……………………………. ……………………………… …………………………A suitable JVM could not be found. Please run the program again using the option -is:javahome <JAVA HOME DIR> Solution: $ setup.solaris -console -is:javahome /disk2/psoft/psfsdev/jre

Query to Find Tax Updates Installed in PeopleSoft

When maintaining a PeopleSoft environment or even doing a PeopleSoft upgrade, you’re likely to come across a scenario where you need to find out the last tax update applied to a particular environment. You may also have to find out all the previous tax updates applied in the environment. All this is usually done to […]

PeopleSoft Application Server Failed to Boot “Could not allocate bulletin board shared memory”

PeopleSoft application server is one which you’d starting and shutting down quite often. Though PeopleSoft application server is quite stable and usually is pretty straight forward to configure and once you get it to work, it is very unlikely to give you any sort of a problem. There are a few errors, which might show […]

Transfer Private PS Queries From One User To Another

If any user leave the department and there are many Private queries which needs to be transferred to any new user, then there are 2 ways to do this. Option1: Log in as the user who owns the query, go to Query Manager in PeopleSoft and change the queries from Private to Public. Now new […]

How To Run AE VERSION in PeopleSoft

How To Run AE VERSION in PeopleSoft You may need to run AE VERSION when SYSAUDIT report shows that objects are out of sync and when you do a PeopleTools or/and Application Upgrade. It should only be run when there is reason to believe that the versions in the PSVERSION table are no longer coherent, […]

Welcome to PeopleSoft Tutorial

Overview of PeopleSoft

Want to know what is PeopleSoft, how PeopleSoft works, whether PeopleSoft is fit for your ERP solution or simply want to learn PeopleSoft. Below post will help you get the answers of such questions which are related to overview of PeopleSoft. Evolution of PeopleSoft 1987   – Addressing organizational Human Relations departments, from recruitment to retirement. […]

What is PeopleSoft Connect Id

We will discuss what is a Peoplesoft Connect ID, where it is used, how to create a Connect id and the permissions required by the Connect id. What is a PeopleSoft Connect ID? PeopleSoft Connect id is one of the basic requirements on which PeopleSoft works. PeopleSoft Connect id is infact a PeopleSoft database id, which is required to […]