My Oracle Support Banner

STG_CASA.N_INT_ACCRUED_MTD is Wrongly Mapped to Accrued_interest in T2T_CASA (Doc ID 2384193.1)

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)
Data Mapping

Goal

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

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.