ELA: Incorrect Lease Obligation/Interest Accounting Entries When Pay Term Is Amended (Doc ID 2483084.1)

Last updated on MAY 27, 2024

Applies to:

Symptoms

A common business scenario is that a lease is originally signed for a monthly amount, and then additional space is added requiring an amendment to increase the monthly lease payment. The resulting Payment Schedule and Lease Obligation Accounting entries are incorrect when the amendment requires splitting a Base Rent term into multiple date / rate terms.
The problem is that the Lease Obligation amounts do not reduce to zero over the term of the lease.

Expected Behavior
-------------------------
The expectation is that the Lease Obligation amounts will reduce to zero over the term of the lease.

Steps
--------
This issue can be replicated by performing the following steps:

1) Create a lease starting January 1, 2019 with a 48 month term.
2) Create Base Rent Terms - with 4% Int rate for $1,000 per month for the first 24 months, and for $1,100 for the second 24 months.
3) Activate the Lease.
4) Query the Payment Schedule table and validate the Lease Obligation reduces to zero over the life of the lease.
5) In January 1, 2020 – add $500 Per month for the remaining 36 months of the Lease.
6) Activate the Amendment, and Query the Payment Schedule table

Business Impact
----------------------
There are incorrect Lease Obligation/Interest entries when the Pay Term for a Lease is amended.

Cause

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