E-ORA: Pages in PIA Failed With "...ORA-01861: Literal Does Not Match Format String..."
(Doc ID 2812773.1)
Last updated on OCTOBER 10, 2021
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.57 and later
Information in this document applies to any platform.
The following SQL error occurs on various pages in PIA when selecting against PSXLATITEM or PS_TL_RPT_LNGRD_VW:
The issue can be reproduced at will with the following steps:
1. Access the Job Data > Work Location page
2. Access someone's time sheet and then try to go back to a previous pay period
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