How Source System Confidence Levels Work With Survivorship Rules

You can use source system confidence levels for creating survivorship rules. Survivorship rules are used to retain master records during merge, insert, or update operations.

Source system confidence levels

You can import data from legacy or source systems into the application. The legacy or source systems usually store data associated with the same attributes across systems. Similarly, multiple source systems may have data related to the same account.

Source system confidence levels let you indicate how much you trust the data from a specific source system for an attribute. For example, you may trust the customer address data coming from a financial system more than the same data from a marketing system. Similarly, you may trust the employee name data coming from the Human Relationships system more than the same data coming from the Marketing system. While specifying source system confidence levels, you must ensure that only the most reliable data is selected as the master data.

Survivorship rules

Oracle CX Sales and Fusion Service uses a central data model updated by authorized users from multiple applications. Often, different applications or source systems update the same data resulting in a data conflict.

Survivorship rules are custom business rules that determine how conflicts should be automatically resolved while merging or updating duplicate records from different source systems or applications. For example, you can create a survivorship rule to select the latest customer address data when there are duplicate records.

Relationship between source system confidence levels and survivorship rules

Source system confidence levels enable you to build your survivorship rules to resolve duplicate data associated with specific attributes. For example, you could create survivorship rules to:

  • Select the record from a source system with confidence values of 80 and above as the master record.

  • Automatically reject records from source systems with confidence values of 30 and below.

Synchronization of Attribute Change History for New Attributes

When a new attribute is configured for source confidence, you can synchronize the survivorship on update with that attribute's change history. Synchronization is relevant for the first-time a given attribute is configured with source confidence. Changes to an attribute's existing source confidence setup don't require synchronization. Synchronization isn't required to track changes later.

Here's how you synchronize an attribute's source history:

  1. In the Setup and Maintenance work area, go to the following:

    • Offering: Customer Data Management

    • Functional Area: Customer Hub

    • Task: Manage Source System Confidence

  2. Click Synchronize.

    The sync dialog provides information about the most recently run synchronization job.

  3. Select the Object you want to synchronize on the Synchronize Attribute Source History.

  4. You can select the Recommended synchronization start date option or select Specify the synchronization start date option and specify a date.

  5. (Optional) Select Send Notifications to receive notifications when the synchronization job completes.

  6. Click Submit.

Note: The time taken for this process to complete depends on the number of records to be processed. If this process is taking a long time complete, you can view Last Sync Date and Sync Request ID columns and refresh the page to see the progress. You can also go to the Scheduled Processes page to check the status using the Sync Request ID.