E-PRCS: Process Scheduler Tips For Unexpected Behavior

(Doc ID 615950.1)

Last updated on FEBRUARY 22, 2018

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 7.5 and later
Information in this document applies to any platform.
SPECIFIC TO: PT8.1x,.8.4x
Checked for Relevance on 05-JUL-2013


Sometimes the Process Scheduler behaves erratically with the following symptoms:

a) 'Database Error Encountered' error messages in the Process Scheduler log file pointing to no specific error, (such as the offending SQL Statement).

b) Multiple rows of a single process are entered into the PSPRCSRQST table regardless if that process is a recurrence or not, (in one scenario there was 13,000 rows of the same process).

c) Process Scheduler comes up without issue, however it is not initiating any processes. Furhtermore, those processes that are in an 'Initiated' or 'Processing' status do not complete.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms