My Oracle Support Banner

Mismatch Between RES_DTL and CONS_DTL Tables for ALM 8.0.5 Process Results (Doc ID 2641872.1)

Last updated on FEBRUARY 25, 2020

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.5 and later
Information in this document applies to any platform.
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)

Symptoms

On 8.0.5 version, results mismatch between RES_DTL and CONS_DTL tables

While comparing results generated in RES_DTL vs CONS_DTL for distinct combination of "Key Processing Dimension + Start Date Index + Result Type CD + Financial Element ID", it's been observed that there are couple of combinations which are available in RES_DTL but missing in CONS_DTL as well as vice-versa.

Expectation is that both the result areas should match since there is just a currency conversion which is happening for individual buckets (which is a straight forward calculation), from RES to CONS.

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!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.