My Oracle Support Banner

Survivor Record Is Not Removed From UCM Existing Duplicates View After Merge Due To "Sales Rep" Visibility (Doc ID 2426312.1)

Last updated on JULY 23, 2018

Applies to:

Siebel Universal Customer Master - Version 16.11 [IP2016] and later
Information in this document applies to any platform.

Symptoms

PRODUCT VERSIONS:
------------------------------
SIEBEL VERSION:          Siebel 16.11
SIEBEL APP O/S:           Linux x86

ISSUE STATEMENT:
----------------------------

After a duplicate record has been merged, if the survivor no longer has anymore duplicates, it should be removed from the UCM Existing Duplicates View (S_DEDUP_RESULT table).

However, what is observed is that though the Merge of Suvivor and Victim records were successful, the Suvivor record is still displayed in the UCM Existing Duplicates View eventhough it no longer has any victims associated to it.

STEPS TO REPRODUCE:
---------------------------------
The behaviour occurs as follows:

1. Use Client UI to create 2 contacts with same first, last, address, etc. so that they are duplicates and show up in the UCM Existing Duplicates View.

2. Go to the UCM Existing Duplicates View > Contact > drill down to see its match > click Merge.

3. The contacts are merged together, there are no errors.

4. However, the survivor contact is still showing in the UCM Existing Duplicates View > Contact view and note removed, it still has a row for it in the S_DEDUP_RESULT table.

EXPECTED BEHAVIOR:
-------------------------------
The expected behaviour is that after the records are merged, if/since the survivor no longer has anymore duplicates, it should be removed from the UCM Existing Duplicates View (S_DEDUP_RESULT table).

LOSS OF FUNCTIONALITY / BUSINESS IMPACT:
--------------------------------------------
Since it is not removing the Survivor record, it is not accurately reflecting the state of the data.

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!


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