New Columns on STG_SWAPS_CONTRACTS Are Not Being Mapped to FCT_COMMON_ACCOUNT_SUMMARY

(Doc ID 2261476.1)

Last updated on MAY 02, 2017

Applies to:

Oracle Financial Services Data Foundation - Version 8.0.4 and later
Information in this document applies to any platform.
Oracle Financial Services Data Foundation (FSDF) previously known as Oracle Financial Services Data Warehouse (FSDW)
Oracle Financial Services Analytical Applications (OFSAA)

Goal

Recent editions of the Staging area have extended the number of columns with "_pay" and "_rcv" versions in STG_SWAPS, such as;

n_rate_cap_life_pay
n_rate_cap_life_rcv
n_rate_chg_min_pay
n_rate_chg_min_rcv
n_rate_chg_rnd_fac_pay
n_rate_chg_rnd_fac_rcv
n_rate_decr_cycle_pay
n_rate_decr_cycle_rcv
n_rate_floor_life_pay
n_rate_floor_life_rcv
n_rate_incr_cycle_pay
n_rate_incr_cycle_rcv
n_rate_set_lag_pay
n_rate_set_lag_rcv
n_remain_no_of_pmts_pay
n_remain_no_of_pmts_rcv

These are not present in FCT_COMMON_ACCOUNT_SUMMARY.

Will these be aligned (along with the T2T) at some point?

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