Formula Results Not Consolidated to Reporting Currency in CONS_DTL_xxxxx Table
Last updated on SEPTEMBER 01, 2017
Applies to:Oracle Financial Services Asset Liability Management - Version 8.0.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
In Oracle Financial Services Asset Liability Management (ALM) 8.0.2, after installing <Patch 25728080> - FORMULA RESULTS NOT OUTPUT TO CONSOLIDATION DETAIL TABLE, when you run an ALM Process that includes a Formula Results rule and has the "Consolidate to Reporting Currency" option selected in Output Preferences, rows for the Formula Results are output to the CONS_DTL_xxxxxx table but the rows are not converted into the reporting currency.
Reporting Currency = USD
In RES_DTL_xxxxx, a Formula Result row exists with RESULT_TYPE_CD = 2 and ISO_CURRENCY_CD = 'TRY'.
In CONS_DTL_xxxxx, you expect this row to be converted to the USD currency. Instead, in CONS_DTL_xxxxx, there is a row with the same amount and same Currency of ISO_CURRENCY_CD = 'TRY'. The row is not converted to the reporting currency.
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