Prashant
Author Archives: Prashant
Prashant
Unable to select recurrence when running PeopleSoft processes
Recurrences as the name suggests are used to run PeopleSoft processes repeatedly. You could create multiple recurrence selecting different date & time to create a schedule such as daily, monthly etc. Once a recurrence is created, it can be used to schedule a process to run multiple times based on the recurrence settings. If you’re […]
Continue readingHow to find current status of PeopleSoft process scheduler
Process Scheduler plays an important role in PeopleSoft application by performing batch transactions & running processes and reports. Due to its significance in PeopleSoft architecture, availability of process scheduler become critical. Most of the organizations deploy multiple process scheduler to handle the requests. Still at times, process scheduler can behave erratically (specially when running on […]
Continue reading
How to monitor connections to PeopleSoft Database
Ever wondered how many users are connected to PeopleSoft database? This is different than users who login into PeopleSoft application via web. You can find users who make direct SQL connection with your PeopleSoft database. This includes anyone using SQL client tool, PeopleSoft development tools and connections made by PeopleSoft server such as application server […]
Continue readingChange PeopleSoft Access ID & Password in PeopleTools 8.56 & 8.55
PeopleSoft Access ID also known as Owner ID is the owner of PeopleSoft tables. In Oracle, it’s commonly used as ‘SYSADM’ and ‘sa’ for SQL server. All PeopleSoft tables belongs to this user id and this ID is created during the database creation. You may need to change password for PeopleSoft access id /owner id […]
Continue readingHow to access SQL for a Private PS query of another user
PS query is a powerful tool for end users to fetch data from PeopleSoft application and users can create public and private queries. Although public queries can be viewed by anyone having access to Query Viewer or Query Manager but private queries can only be seen by the user who created them. But there could […]
Continue reading