My Oracle Support Banner

Datafix: Update Customer Ids On Sales Fact Based On Input From Customer (Doc ID 2957816.1)

Last updated on JUNE 27, 2023

Applies to:

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

Symptoms

Data Correction to alter every customer ID on their entire sales history to match Customer Engagement.

The customer ID changes are at the transaction level and will be many-to-many changes so it is not a simple swap at the customer level.

Due to the data volumes involved, the correction scripts will have to run month by month and also handle the constraints and indexes on the target table before and after the updates.

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.