Unable To Get The Right Attributes For Work And Mobile Phone While Configuring Duplicate Identification Rules

(Doc ID 2130772.1)

Last updated on JULY 30, 2017

Applies to:

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


On : version, Data Quality, Customer Hub

For Contact Duplicate Identification, we need Work Number and Mobile Number (either of it can be Primary on Contact) fields to Match. We could use Fields from EDQ and Sales Cloud to build keys between them. But when we Review Results we get 4 Contacts (2 Contacts Getting Repeated).

A Contact can have a mobile number and/or a work number and either could be primary. The rules as setup are not identifying the duplicates as desired.

The issue can be reproduced at will with the following steps:
1) Login to Fusion Application
2) Click on Navigator > Setup and Maintenance
3) Search for a task called 'Manage Enterprise Data Quality Matching Configurations'
4) In the results for that task, click on 'Go to Task'
5) Under "Match Configurations", click on the link to "Contact Duplicate Identification"
6) Map workphone to PrimaryPhoneNumber
7) Map mobilephone to PhoneNumber

The issue has the following business impact:
Need to get the matching rules defined correctly to finish the Data Quality task.


 DQ Rules configuration.


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