My Oracle Support Banner

E-PRCS: SQL Errors "Invalid date. (180,112)" Or "1861 - ORA-01861: literal does not match format string" Running Process Scheduler Requests. (Doc ID 2792831.1)

Last updated on AUGUST 25, 2023

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.56 to 8.58 [Release 8.4]
PeopleSoft Enterprise PT PeopleTools - Version 8.59 to 8.59 [Release 8.4]
Information in this document applies to any platform.


Automated Solution Alert: Do not delete or modify this document without first referring to Doc ID 2778233.1.

Process Scheduler Intermittent SQL statement failures observed when running Process Scheduler requests.

Invalid date. (180,112)


1861 - ORA-01861: literal does not match format string

When the process request that failed is restarted the second pass runs fine with no errors. There is no change to the parameters for the second run. The "failed" process will then continue to run successfully for many days before failing again.


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.