My Oracle Support Banner

Line Account - Backdated Advance Posting not able to calculated the due bucket as expected (Doc ID 2788163.1)

Last updated on JULY 04, 2021

Applies to:

Oracle Financial Services Lending and Leasing - Version and later
Information in this document applies to any platform.
Acc: ********** -- Back dated on 10th april 2021 with GL date 18th Jun 2021.
contract date 04/10/2021
1st Pmt Dt 05/10/2021
late charge grace days 5
Delq Grace Days 5
Till 06/18/2021 - Nill advance

We can see transactions (All) with post dt(06/18/2021) with Accrual/interest billed/Advance billed/DDT at the End of month for April/May/Jun with zero amount. with due date as 10th of subsequent month. balance column displays with zero amount.
Due buckets 05/10/2021 06/10/2021 displaying 0 amounts. But Oldest due date displaying 07/10/2021

On 06/18/2021 - 2000 manual advance posted with backdate transaction date
05/01/2021. to make account delinquent for 30 days.. since the current date is 18th Jun where the payment should have posted on 10th Jun. Even if we include the grace days for delinquency it is only upto 15th Jun, but system is in 18th jun.

Due buckets 05/10/2021 displaying 0 amount & 06/10/2021 with 30.18. Which is correct.
Today payoff is displaying 2018.68 = 2000(advance) + 18.68(interest to be paid immediately)
Future payoff is displaying 2022.65 = 2000(advance) + 22.65(interest to be paid on future pay off date) with future pay off date as 06/27/2021

But Oldest due date displaying 07/10/2021

Delinquency details not showing account in 30 day bucket instead it is showing -23

Account details also displays Days past due as -23(not correct) and due date history displays as 7(correct)


When Backdated advance are posted on "Line" accounts, system does not update the Oldest Due Date, Delinquency days and Delinquency condition appropriately on account.

Issue : System reverse the txns/dues, post advance on account and recalculate the Due amounts but does not populate the Oldest Due dt, Delq Condition, Delq days appropriately.

system should post the Oldest Due Date, Delinquency days and Delinquency condition appropriately on account

The issue can be reproduced at will with the following steps:
1. Create Line account and fund it backdated (assume 2 cycles)
2. Create an "Advance" batch for the account and post backdated advance on account i.e prior to 1-2 cycles)
3. Go to Customer Service ->Summary and observe Oldest Due dt, Delq Condition, Delq days.

The issue has the following business impact:

Due to this issue, users cannot test and impacting go live




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

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