My Oracle Support Banner

Is it Possible To Bucket a Percentage of Future Period Early Redemption ALM Run-off Directly Into Bucket 001 (Doc ID 3061017.1)

Last updated on DECEMBER 09, 2024

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.1.2.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Asset Liability Management (ALM)
Income Simulation Buckets (ISB)
Interest Rate Gap Buckets (IRR)
Liquidity Buckets (LR)

Goal

The user wants respective constant early redemption rate to be taken out from the respective bucket based on the residual maturity and bucket the equivalent amount in 1 day bucket.
For example: Let's say $1000 is there in each bucket and 2% of amount bucketed in overnight to 1 month bucket is being early redeemed next day (1-day bucket) which means $20 should be bucketed in 1 day bucket, 3% of amount bucketed in over 1 month and up to 3 months bucket is being early redeemed next day (1-day bucket) which means $30 should be bucketed in 1 day bucket and so on.

Have tried using user defined tenors option in prepayment rules by selecting multiple Start Origination Date and End Origination Date ranges and selecting tenor as 1 day for each date range but due to the static nature of date changes it needs to be manually changed before every run which is making the process more time consuming and duplicating efforts. Please suggest an alternative way which can streamline the process.

Solution

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
Goal
Solution
References


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