My Oracle Support Banner

SDE_RETAILCOMPETITORPRICEFACT Package Extract Duplicate Data in Staging Table (Doc ID 2579088.1)

Last updated on SEPTEMBER 03, 2019

Applies to:

Oracle Retail Merchandising Insights - Version 16.0 and later
Information in this document applies to any platform.

Symptoms

RDE SDE_RETAILCOMPETITORPRICEFACT package extract duplicate data in staging table which causue unique constraint (RADM.PK_W_RTL_COMP_PRICE_IT_LC_DY_F) violated in SIL_RETAILCOMPETITORPRICEFACT package.

Observation:
COMP_PRICE_HIST table is in ITEM, REF_ITEM,COMP_STORE,REC_DATE level. While inserting data in temp table COMP_PRICE_HIST_TMP only three columns ITEM, REF_ITEM,COMP_STORE,REC_DATE is selected from COMP_PRICE_HIST table but same item might have multiple REF_ITEM which cause duplicate record in staging table.

 


Steps To Recreate:

1. Run RDE SDE_RETAILCOMPETITORPRICEFACT.
2. Run SIL_RETAILCOMPETITORPRICEFACT.

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.