My Oracle Support Banner

No records are showing up in Account/Contact Duplicates view. Driver record missing in S_DEDUP_RESULTS (Doc ID 2171571.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Data Quality - Version 15.0 [IP2015] and later
Information in this document applies to any platform.

Symptoms

On :  15.0 [IP2015] version, Client Functionality

ACTUAL BEHAVIOR  
---------------
Records are not getting created in Existing Duplicates view when duplicates are found

Siebel Loyalty - OEDQ set up for Contact Deduplication, the OEDQ dedup service does not create the Contact Driver record in the S_DEDUP_RESULTS table i.e. OBJ_ID=DUP_OBJ_ID. Because of this, no records are showing up in Administration - Data Quality > Contact or Account Duplicates


EXPECTED BEHAVIOR
-----------------------
Driver record should be inserted into S_DEDUP_RESULTS table with value DUP_OBJ_ID=OBJ_ID=

STEPS
-----------------------
1. Create a new Contact record in Siebel. Ex: Row_ID = ABC
2. Create a matching record with similar First Name, Last Name etc. Ex: ROW_ID = XYZ
3. This will trigger the OEDQ matching process and raise a Pop up applet with the scored matching record.
4. But the Driver record (ROW_ID = 'XYZ') is not visible in the Administration->Data Quality->Duplicate Contacts screen, because the Driver entry does not exist in the S_DEDUP_RESULT table (OBJ_ID=DUP_OBJ_ID='ABC').
5. Only the duplicate record's details exist in the table (DUP_OBI_ID='xyz').

BUSINESS IMPACT
-----------------------
Records are not being identified as duplicates as the driver record was not inserted into S_DEDUP_RESULTS

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.