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 […]
Continue readingVI 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, $ […]
Continue readingWhile 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 readingBefore 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 […]
Continue readingPeopleSoft 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 […]
Continue reading