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 MAY 11, 2022

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.

Symptoms

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)

OR

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.



Cause

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
Symptoms
Cause
Solution


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