My Oracle Support Banner

How to Populate Interest Rate in FCT_PROCESS_CASHFLOWS Table? (Doc ID 2653770.1)

Last updated on APRIL 01, 2020

Applies to:

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

Goal

Question 1: Which column in FCT_PROCESS_CASHFLOWS table corresponds to interest rates and how can it be populated?

For a specific instrument, say term deposit, there is N_INTEREST_RATE column in STG_TD_CONTRACTS, which is mapped to INTEREST_RATE and N_CURR_GROSS_RATE in FSI_D_TERM_DEPOSITS and FCT_COMMON_ACCOUNT_SUMMARY respectively. However, no value that is related to interest is being populated in the FCT_PROCESS_CASHFLOWS table.
 
Question 2: Which column relates interest_rate in FCT_PROCESS_CASHFLOWS?

FE 420 (which is interest) cannot be found in front-end. It's present in FSI_FIN_ELEM_COL_MAP but not in Audit engine block.
 
Question 3: How is interest_rate mapped to FCT_PROCESS_CASHFLOWS table from FSI_D_TERM_DEPOSITS.CUR_GROSS_RATE column?

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.