Dimension Member Created Multiple Times in REV_HIER_FLATTENED Table After Running the Hierarchy Transformation Batch
Last updated on DECEMBER 02, 2016
Applies to:Oracle Financial Services Enterprise Financial Performance Analytics - Version 6.1.1 and later
Information in this document applies to any platform.
Oracle Financial Services Enterprise Financial Performance Analytics (EFPA/PFTBI) previously known as Oracle Financial Services Profitability Analytics
Oracle Business Intelligence Enterprise Edition (OBIEE)
Custom / User Defined Dimension
On EFPA 6.1.1 the batch_hierTransformation batch when executed for a custom Slowly Changing Dimension (SCD) Type 1 Canal dimension, multiple rows for the same dimension are inserted into the REV_HIER_FLATTENED table.
A dimension member (10101) that gets inserted 16 times in the REV_HIER_FLATTENED (all the registers are the same as Select Distinct returns only 1 row). This is a serious issue because when we try to run the SCD process we get 16 rows for a same N_canal_id.
Expect single row per dimension member.
This issue may also be encountered when running SCD as described in <Document 2170870.1> 'ORA-30926: Unable to Get a Stable Set of Rows' Error Running SCD After Installing Language Pack. The language pack is installed on this instance.
The issue can be reproduced at will with the following steps:
1. Run batch_hierTransformation batch for user defined Canal dimension.
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