Formula Results Not Consolidated to Reporting Currency in CONS_DTL_xxxxx Table
(Doc ID 2301591.1)
Last updated on MARCH 28, 2019
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document