How To Identify & Merge Duplicate Data For Exist And On Going Import Data
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.
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.
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