My Oracle Support Banner

Excess Amount Causing Balance Issues (Doc ID 2767993.1)

Last updated on APRIL 15, 2021

Applies to:

Oracle Financial Services Lending and Leasing Cloud Service - Version and later
Information in this document applies to any platform.


On : NA version, Production Support-SET

Excess amount causing balance issues

ABL_DUE_AMT_PD(1-5) fields are not getting populated correctly during billing process where Excess is being applied to the charge on LOC accounts.

This is causing individual balances summations to go negative, where they never should. Our understanding is that individual balances should net out >= 0. If anything excess is on account it should sit in acc_due_amt_pd_excess and also be reflected as a negative in acc_outstanding_total_amt.

For example:
Account billed for $100 Overpayment is made for $150 ,$50 is in excess on account. Next billing happens and raises $100 – with $50 being applied from excess. Balance line shows $100 open and $50 paid, but ABL_DUE_AMT_PD1 still = 0. Due amount 1 = $50.So, when next payment comes in of $100 Balance line shows $100 open and $150 paid, and with $50 in excess on account.

So, on balances screen it shows -100 with -50 on balance item and -50 on credit.

System should show the balance correctly when there is an excess payment.
The issue can be reproduced at will with the following steps:
Not Mentioned.

The issue has the following business impact:
Due to this issue, users cannot have the correct balances in case of account having excess payment.


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.