My Oracle Support Banner

RI Sales Promotion is Missing Records Found During Comparison Between Staging And Temp Tables (Doc ID 2767961.1)

Last updated on MAY 27, 2021

Applies to:

Oracle Retail Insights Cloud Service Suite - Version 18.0 and later
Information in this document applies to any platform.

Symptoms

RI Sales Promotion is missing records found during comparison between staging and temp tables.
 
In ODI, the Update Key on W_RTL_SLSPR_TX_IT_LC_DY_TMP is defined as below. It is not correct as they are not unique without trx_id and promo information. 

ORG_NUM
PROD_IT_NUM
DAY_DT
CO_LINE_ID

 

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