My Oracle Support Banner

E-PRCS: Process Scheduler Tips For Unexpected Behavior (Doc ID 615950.1)

Last updated on JANUARY 03, 2023

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


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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.