My Oracle Support Banner

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

Last updated on SEPTEMBER 17, 2024

Applies to:

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

Changes

 

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
Changes
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.