STG_CASA.N_INT_ACCRUED_MTD is Wrongly Mapped to Accrued_interest in T2T_CASA
Last updated on JUNE 11, 2018
Applies to:Oracle Financial Services Asset Liability Management - Version 8.0.2 to 8.0.6 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Asset Liability Management (ALM)
Table to Table (T2T)
In the OFSAA 8.0.2, T2T_CASA - STG_CASA.N_INT_ACCRUED_MTD is mapped to FSI_D_CASA.ACCRUED_INTEREST.
According to definition of N_INT_ACCRUED_MTD - This column stores the interest accrued on an account, month till date. This is the total interest accrued on that account since last one month and is cumulative in nature.
The correct column to be consistent is N_ACCRUED_INTEREST_AMT - This column stores the accrued interest amount associated with the contract. This is the interest that has accumulated on an instrument since the last interest payment up to, but not including, the settlement date.
Recommendation: Mapping for accrued interest in T2T_CASA - STG_CASA & T2T_STG_CASA_CAS should be the same as the mapping for T2T_CORRESPONDENT_CASA & T2T_CORRESPONDENT_CAS (shown below) (i.e.) with STG_CASA.N_INT_ACCRUED similar to STG_CORRESPONDENT_ACCOUNT.N_INT_ACCRUED instead of STG_CASA.N_ACCRUED_INTEREST_AMT in order to be consistent across tables.
Currently in CASA>
In the T2T_CASA - STG_CASA.N_INT_ACCRUED_MTD is mapped to FSI_D_CASA.ACCRUED_INTEREST
In T2T_STG_CASA_CAS, STG_CASA.N_INT_ACCRUED_MTD is mapped to FCT_COMMON_ACCOUNT_SUMMARY.N_ACCRUED_INTEREST
Currently in Correspondent Accounts>
In T2T_CORRESPONDENT_CASA, STG_CORRESPONDENT_ACCOUNT.N_INT_ACCRUED is mapped to FSI_D_CASA.ACCRUED_INTEREST.
In T2T_CORRESPONDENT_CAS, STG_CORRESPONDENT_ACCOUNT.N_INT_ACCRUED is mapped to FCT_COMMON_ACCOUNT_SUMMARY.N_ACCRUED_INTEREST
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