My Oracle Support Banner

Formula Results Not Consolidated to Reporting Currency in CONS_DTL_xxxxx Table (Doc ID 2301591.1)

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)

Symptoms

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.

For example:

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.

Cause

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.