My Oracle Support Banner

In Custom Dimensional And Fact Table Views We See Duplicates For A Unique Set Of Records (Doc ID 2766588.1)

Last updated on APRIL 13, 2021

Applies to:

Oracle Financial Services Revenue Management and Billing Analytics - Version 2.7.0.0.0 and later
Information in this document applies to any platform.

Goal

As the source base tables replicated into replications schema with HIST_TYPE_FLG=HIST will have a new entry in replication schema for each change made at source side, because of this custom dimension & fact table views are having multiple records for every unique set of record with different key values.

For example: in ci_priceitem table for price item '10001' we have two records where one record is holding jrn_flag=I and other with jrn_flag=U and in bd_product table for this price item also we have 2 records with different prd_key values. But we need to have one record in bd_product table for price item ='10001' .

Because of the multiple key values exists for every unique record in dimension and fact tables, the reports are having impact whenever any changes are made at the source side.
 

Solution

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