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 |