Incorrect Cash Items Generated For a Lease When The Billing Term Start Date is 31-Dec and Frequency is Quarterly (Doc ID 1931863.1)

Last updated on MARCH 22, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, Authorizations

ACTUAL BEHAVIOR
---------------
 Incorrect cash items generated for a lease when the billing term start date is 31-Dec and frequency is Quarterly. One cash item is created in the first schedule with the whole quarter rent amount

EXPECTED BEHAVIOR
-----------------------
  instead, there should be a creation of cash item for each quarter.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1- created lease with the following data for example
 
Lease class = Revenue
Proration rule = Days/Month
commencement date = 31-Dec-2010
termination date = 30-Dec-2014

frequency = Quarterly
start_date = 31-Dec-2010
end_date = 30-Dec-2014
actual_amount = 1000
schedule day = 28
normalize = Y

2- Change lease status from Draft to Final
3- The cash items are generated with zero amount except the first item.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create leases with billing start date 31-DEC.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms