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

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
BI Reports
Oracle Business Intelligence Enterprise Edition (OBIEE)
Reporting
Custom / User Defined Dimension
Multi-language

Symptoms

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.

ACTUAL BEHAVIOR
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.

EXPECTED BEHAVIOR

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.

Cause

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