My Oracle Support Banner

What Is the Best Way To Update the Prepayment Assumption on a Monthly Basis (Doc ID 3046631.1)

Last updated on SEPTEMBER 27, 2024

Applies to:

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

Goal

What is the best way to update the prepayment assumption on a monthly basis?

Business requirement is to update the prepayment assumptions at a product level on a monthly basis.
Currently this can be done within OFSAA User Interface (UI). In order to save time and ensure more accuracy from manually changing each product’s prepayment assumption, exploring more automated ways to do this.

User looked into different options such as:
- Excel utilities within OFSAA UI: creating excel-entity mappings and then running excel upload
- Running update statement to edit table FSI_M_PPMT
- Creating DIH connector to load csv file into table FSI_M_PPMT

Is there any other options and what would be the best/most accurate way to achieve this requirement?
 

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.