ALMBI Incorrect N_MARKET_VALUE_CLEAN_RCY Derived Entity in T2T_FCT_ALM_ACCOUNT_BORROWINGS (Doc ID 2129253.1)

Last updated on FEBRUARY 22, 2017

Applies to:

Oracle Financial Services Asset Liability Management Analytics - Version 8.0.0 to 8.0.4 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Asset Liability Management Analytics (ALMBI)
ALM BI
Reports

Symptoms

On ALMBI 8.0.1 version, N_MARKET_VALUE_CLEAN_RCY has an incorrect derived entity mapped in the T2T_FCT_ALM_ACCOUNT_BORROWINGS.

ACTUAL BEHAVIOR
Expression for the derived column N_MARKET_VALUE_CLEAN_RCY= (FSI_D_ANNUITY_CONTRACTS.MARKET_VALUE_CLEAN_C * fsi_exchange_rate_hist.exchange_rate)

EXPECTED BEHAVIOR
Expression for the derived column should have correct table mentioned: N_MARKET_VALUE_CLEAN_RCY= (FSI_D_BORROWINGS.MARKET_VALUE_CLEAN_C * fsi_exchange_rate_hist.exchange_rate)

The issue can be reproduced at will with the following steps:

1.Financial Services Asset Liability Management Analytics
Common Object Maintenance -> Data Management Tools -> Data Mapping

2. Open Process Source -> T2T_FCT_ALM_ACCOUNT_BORROWINGS

3. Check Derived Entity column mapping for N_MARKET_VALUE_CLEAN_RCY

Cause

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