My Oracle Support Banner

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

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