My Oracle Support Banner

Partial Payment Of Component PREFIX Is Not Updating Properly In COMPOUND_INTEREST Table (Doc ID 2868139.1)

Last updated on MAY 17, 2022

Applies to:

Oracle Banking Corporate Lending - Version to [Release 14]
Information in this document applies to any platform.


On : version, Implementation Support

Issue : Partial payment of component PREFIX is not updating properly in COMPOUND_INTEREST table

Partial payment should updated properly in COMPOUND_INTEREST table for PREFIX component

A Loan contract has been created with following steps
1. - OLDTRONL New Loan contract created for Amount Financed - xxxxx.00 with Book Date - 2021-05-06, Value Date - 2020-12-10 and Maturity Date - 2021-12-13 with bullet schedule for PREFIX, POSTFIX and PRINCIPAL on 2021-12-13
2 - ONLPMNT A Payment is made on Value Date - 2021-05-06 with Limit Date as 2021-12-13 (which is schedule date of loan) for component PREFIX where Amount Due -xxxx.10 and Amount Paid - xxxx.xx. hence balance to be updated in COMPOUND_INTEREST table on 2021-05-06 should be xxx.xx However it is updated as xxx.xx
3 - in OLDPMNT when the user looks for payment with above Value date and limit date then the front end showing appropriate Amount Due of yyyy.yy for component PREFIX


 The fix provided as reducing the settled amount after basis interest calculation for derived components


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.