My Oracle Support Banner

How To Identify & Merge Duplicate Data For Exist And On Going Import Data (Doc ID 2406988.1)

Last updated on SEPTEMBER 11, 2020

Applies to:

Oracle Fusion Sales Cloud Service - Version and later
Information in this document applies to any platform.


How to Identify & Merge Duplicate Data for Exist and on going Import Data

Scenario:we have about more than 13.000 customer(contact) in OSC database, and currently we still doing import customer data (using Excel file) we also use web service to inject customer data directly to database. For existing data and (of course) for on going customer import data, we need to check all those customer data, if there is any customer that duplicate. And if there is a contact that have duplicate, we need to merge then automatically.


We have names fields that used to define a duplicate customer is when the contact has exactly the same Name, Email, and Phone with other contact.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.