HM IFRS Input Output Data Tables and Columns (Doc ID 1942295.1)

Last updated on APRIL 06, 2016

Applies to:

Oracle Financial Services Hedge Management and IFRS Valuations - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Hedge Management and IFRS Valuations (HM/IFRS)

Goal

Regarding HM-IFRS module for the following data columns in the staging tables:

STG_CARDS n_effective_interest_rate NUMBER(10,6)
STG_CARDS n_effective_initial_spread NUMBER(15,11)
STG_CARDS n_hm_effective_interest_rate NUMBER(15,11)
STG_CARDS n_market_value NUMBER(22,3)
STG_INVESTMENTS n_mkt_value NUMBER(22,3)
STG_INVESTMENTS n_effective_interest_rate NUMBER(15,11)
STG_INVESTMENTS n_effective_initial_spread NUMBER(15,11)
STG_LOAN_CONTRACTS n_effective_initial_spread NUMBER(15,11)
STG_LOAN_CONTRACTS n_market_value NUMBER(22,3)
STG_LOAN_CONTRACTS n_effective_interest_rate NUMBER(15,11)
STG_TD_CONTRACTS n_hm_effective_interest_rate NUMBER(15,11)
STG_TD_CONTRACTS n_market_value NUMBER(22,3)

1) What output tables is HM-IFRS populating ? What are the tables and columns where the ouputs of the HM-IFRS module run will be populated?
 
2) Why does STG_CARDS have 2 separate effective interest rate columns (n_hm_effective_interest_rate and n_effective_interest_rate)? Which one is needed to be able to run the HM-IFRS calculations? And which output table and column will effective interest rate will reside?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms