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