Error "Lease termination date cannot be earlier than the end date of normalized term" while trying to Terminate a Lease
(Doc ID 2780202.1)
Last updated on MAY 28, 2021
Applies to:Oracle Property Manager - Version 12.1.3 and later
Information in this document applies to any platform.
When attempting to terminate a lease
the following error occurs.
Error 1 : Warning of a NULL column in an aggregate function.
On Clicking OK,the below error occurs
Error 2 : Lease termination date cannot be earlier than the end date of normalized term
The issue can be reproduced at will with the following steps:
a) Create a Lease
b) Provided below dates
LEASE_COMMENCEMENT_DATE : 01-MAY-21
LEASE_TERMINATION_DATE : 30-APR-22
LEASE_EXECUTION_DATE : 27-AUG-20
c) Save the record.
d) Schedules Concurrent program gets fired
e) Using Amend Functionality change the LEASE_TERMINATION_DATE to 01-May-2021 and save.
(Navigation > Leases and Documents > Main Leas > Enter Lease and Documents > Find Lease > Amend)
Observe the error
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