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 APRIL 04, 2025

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.57 and later
Information in this document applies to any platform.

Symptoms

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

Changes

 

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