Oracle Customer Hub (UCM) Master Data Management Reference > Configuring Oracle Customer Hub (UCM) to Resolve Duplicate Records > Administering Duplication Resolution Functionality >

About Merge and Unmerge


Merge requests can be made for Contact and Account records in the Oracle Customer Hub (UCM) user interface, and through Web services. You can capture any two records in the user interface to perform a merge. You can capture associated information during the merge. The associated information will be available and restored to the victim record after the records are unmerged. After the data steward processes the merge request, the requestors receive a merge result message providing that the requestor is registered with the publish and subscribe service.

When Oracle Customer Hub (UCM) is the customer master application and also the service provider, service requestors can invoke only the Submit Merge Request service. Only a data steward can process the merge request and decide whether it is a valid merge request and process the merge. The following conditions must exist:

  • The interface of the service must contain the external system survivor ID and the victim ID.
  • The two records in the merge request must be in the Oracle Customer Hub (UCM) database. Otherwise, the merge request will be rejected.
  • The Merge Request service will be put in the request table and waits for the data steward to review and execute the merge operation.
  • The Process Merge Request service will be invoked by the data steward only. It calls the Survivorship service to generate an updated version of the survivor record if the Survivorship Engine is enabled. It updates all foreign key fields linked to the victim record to survivor record in the Oracle Customer Hub (UCM) database.
  • UCM Submit Merge Request service provides an asynchronous response of the merge results, but the requestor receives a synchronized response for the request status, such as Pending, Rejected and so on. After the data steward processes the merge request, the requestors will get the merge result only if they registered with the publish and subscribe service.
Oracle Customer Hub (UCM) Master Data Management Reference Copyright © 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices.