Tag Archive

Tag Archives for " PeopleSoft Process Scheduler "

How to Resolve PeopleSoft Process Scheduler Posting Issues

It is common to have have Posting issues after PeopleTools upgrade or Database refreshes or even PeopleSoft application upgrade. So, what exactly happens in a PeopleSoft Posting issue? When you run processes or PSJobs via PeopleSoft process scheduler — all those processes would get stuck in Posting status after going to success or going to […]

Continue reading

ERROR: Verify That The Configurations Are Correct! (63,180)

In the recent PeopleTools versions, there has been a new option to avoid PeopleSoft process scheduler posting issues. This option validates whether PeopleSoft Report Node definition is correct or not. There is a Validate button in the Report Node Definition page, which does this job. In ideal cases, when you have the report node defined […]

Continue reading
1

PeopleTools 8.54: New Features in PeopleSoft Process Scheduler

In our past posts, we have already discussed about the changes in PeopleSoft Login Page, PeopleSoft Change Assistant & PeopleSoft Application Designer that were introduced with PeopleTools 8.54. In this post, lets quickly review the new features for PeopleSoft Process Scheduler. In almost all the organizations using PeopleSoft applications, PeopleSoft Process Scheduler is widely used […]

Continue reading
3

How to Find PeopleSoft Processes/PSJobs in a Recurrence

Do you want to find out all processes and jobs running under a particular recurrence? Use this SQL below: SELECT process_job_name,  description, recurname FROM   ps_prcsrecur a, (SELECT p.prcsname  AS Process_Job_name, p.descr     AS Description, p.recurname AS recurname FROM   ps_prcsdefn p UNION SELECT jp.prcsjobame AS Process_Job_name, (SELECT j.descr FROM   ps_prcsdefn j WHERE  j.prcsname = jp.prcsname) AS Description, jp.recurname AS recurname FROM   ps_prcsjobdefn j,  ps_prcsjobitem jp WHERE  j.prcsjobname = jp.prcsjobname) b WHERE b.recurname = a.recurname AND a.recurname = :1 ORDER  BY 1

Continue reading