My Oracle Support Banner

PNSCHITB: Schedules And Items Request Is Completing With Error "ORA-01861: literal does not match format string" For Revenue Lease (Doc ID 3028789.1)

Last updated on JUNE 20, 2024

Applies to:

Oracle Property Manager - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to approve revenue lease ,
the schedules and items concurrent program is completing with below error which can be seen in request log file.

ERROR
-----------------------
Cause: FDPSTP failed due to ORA-01861: literal does not match format string
ORA-06512: at "APPS.PN_SCHEDULES_ITEMS", line 10021
ORA-06512: at "APPS.FND_DATE", line 149
ORA-06512: at "APPS.PN_SCHEDULES_ITEMS", line 9551


STEPS
-----------------------
The issue can be reproduced with the following steps:
1. Property Manager Responsibility
2. Go to Leases and Documents -->Enter Leases and Documents--> Click New
3. Enter a new Lease details of Type Revenue with Lease Commencement Date >= 1-Jan-2024
4. Finalize the Lease.
5. Check Schedules and Items Program which is completed in mentioned error.

 

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
References


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