My Oracle Support Banner

Dimension Member Created Multiple Times in REV_HIER_FLATTENED Table After Running the Hierarchy Transformation Batch in 6.1.1 (Doc ID 2202733.1)

Last updated on JULY 01, 2021

Applies to:

Oracle Financial Services Enterprise Financial Performance Analytics - Version 6.1.1 to 6.1.1 [Release 6]
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
BI Reports
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.


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

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