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.
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
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 |