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)
On ALMBI 8.0.1 version, N_MARKET_VALUE_CLEAN_RCY has an incorrect derived entity mapped in the T2T_FCT_ALM_ACCOUNT_BORROWINGS.
Expression for the derived column N_MARKET_VALUE_CLEAN_RCY= (FSI_D_ANNUITY_CONTRACTS.MARKET_VALUE_CLEAN_C * fsi_exchange_rate_hist.exchange_rate)
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms