My Oracle Support Banner

Line of credit account - system not updating the account balances and CTD and YTD balance when there is excess payment and reversal of the same. Not working for backdate also (Doc ID 2719077.1)

Last updated on OCTOBER 13, 2020

Applies to:

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



For Line of credit account Excess payment posted and reversed  not getting allocated as expected and account balances are not updating as expected. Eg.Also abl_pd_ctd1. Also CTD and YTD fields not getting updated with correct balance.(e.g ABL_BAL_OPEN_CTD.)


System should allocate the excess payment and update Account balances for line of credit account. Even for reversal system should work as expected should be calculated 


The issue can be reproduced at will with the following steps:

1. Select an Line of Credit Active account
2. Execute the billing batch job .Check the balances (Current) with ITD/CTD
3. Post a payment for the billed amount. Check the balances (Current) with ITD/CTD
4. Post excess payment .Check the balances (Current) with ITD/CTD
5. Execute the billing batch job. Check the balances (Current) with ITD/CTD
6. Reverse the excess payment posted
7. Check for all possible scenarios for excess payment reversal and refund

The issue has the following business impact:
Due to this issue, users cannot process the excess payment  and reversal as the account balances are not updated correctly as expected




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.