My Oracle Support Banner

User Defined Redemption Tenors 'Repeat' Function Does Not Work and Prepayment Amount Too Small (Doc ID 2831894.1)

Last updated on JANUARY 24, 2022

Applies to:

Oracle Financial Services Asset Liability Management - Version and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA) 8.1.x
Oracle Financial Services Asset Liability Management (ALM) 8.1.x


When running an 8.1.x ALM Process using a Prepayment rule with User Defined Redemption Tenors, a tenor of 1 Month, and a repeat value of "4", the results only output a Prepayment to the first bucket.


The "repeat" function is not working.  A prepayment value (FE 180) is only output to the first bucket.

In addition, the prepayment value is smaller than expected for the de-annual option.

The prepayment value is calculated a Prepayment Factor * Beginning Balance.  The Prepayment Factor is calculated as follows:

Prepayment Factor = 1-(1-Prepayment Rate)^(1/Payments Per Year)

WHERE Payments per year = 365/(Current Prepayment Date - Previous Prepayment Date)

For the first bucket, you expect the Current Prepayment Date to be the Bucket End Date and the Previous Prepayment Date to be the As of Date.  However, it appears to be using the NEXT_PAYMENT_DATE value for the Previous Prepayment Date, resulting in a smaller than expected Prepayment value.


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.