How To Identify & Merge Duplicate Data For Exist And On Going Import Data

(Doc ID 2406988.1)

Last updated on JUNE 04, 2018

Applies to:

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

Goal

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.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms