JavaScript is required to for searching.
Skip Navigation Links
Exit Print View
Master Index Data Manager User's Guide     Java CAPS Documentation
search filter icon
search icon

Document Information

Master Index Data Manager User's Guide

Related Topics

About the Master Index Data Manager

About Oracle Java CAPS Master Index

About Master Index Applications

Features of Master Index Applications

Functions of the Master Index Data Manager

Learning about MIDM Object Profiles

MIDM Object Profile Components

Source Records

Single Best Record

Survivor Calculator

Source Record and SBR Components in a Master Index

Identification Numbers for each Entity in the Master Index

EUID

Local ID

Auxiliary ID

Working with the Master Index Data Manager

Requirements

Logging in to the Master Index Data Manager

To Log in to the MIDM

Master Index Data Manager Security Permissions

Master Index Data Manager Navigation Tips

Navigating the MIDM Functions

Navigating the MIDM Detail Pages

Logging Out of the MIDM

Using the MIDM Dashboard

Viewing Summary Information From the Dashboard

To View Summary Information

Accessing Reports and Audit Logs From the Dashboard

To Access Reports and Audit Logs From the Dashboard

Performing a Quick Search (EUID Lookup)

To Perform Quick Search

Performing an EUID Comparison Lookup

To Perform an EUID Comparison Lookup

Learning About Object Queries on the MIDM

About the MIDM Search Function

Simple Lookup

Advanced Alphanumeric Lookup

Advanced Phonetic Lookup

EUID Comparison Lookup

The Search Results List

Searching by Ranges on the MIDM

Required Fields on the MIDM

Searching for Object Profiles on the MIDM

Performing an EUID Lookup

To Perform an EUID Lookup

Performing a Local ID Lookup

To Perform a Local ID Lookup

Performing an Alphanumeric Search

To Perform an Alphanumeric Search

Performing a Phonetic Search

To Perform a Phonetic Search

Performing an EUID Comparison Lookup

To Perform an EUID Comparison Lookup

Working with Search Results on the MIDM

Viewing the Results of a Search

Selecting a Profile from the Results List

Sorting the Results of Your Search

Learning About Object Profile Views on the MIDM

Object Profile Details on the MIDM

Source Record Details on the MIDM

Object Profile and Source Record Comparisons

Object Profile Transaction Histories

Object Profile Merge Histories on the MIDM

The Master Index Audit Log

Viewing Object Information on the MIDM

Viewing Object Profiles on the MIDM

To View an Object Profile

Viewing a Source Record on the MIDM

To View a Source Record

Comparing Object Information on the MIDM

Comparing Two or More Object Profiles

Comparing Source Records From Object Profile Views

Comparing Source Records From One Source System

Viewing Transaction Histories on the MIDM

To View a Complete Transaction History For an Object Profile

To View Transaction History Records from the Transactions Page

About Transaction History Search Fields on the MIDM

About Transaction History Results Fields on the MIDM

Transaction History Transaction Types on the MIDM

Viewing a Profile's Merge History on the MIDM

To View an Object's Merge History

Viewing Merged Profiles for an Object Profile

To View Merged Profiles for an Object Profile

Viewing the MIDM Audit Log

To View the Audit Log

About Audit Log Search Fields on the MIDM

About Audit Log Results Fields on the MIDM

Audit Log Functions on the MIDM

Adding an Object Profile on the MIDM

Step 1: Obtain Information about the Object

Step 2: Specify a System and Local ID

To Specify a System and Local ID

Step 3: Specify Parent Object Information

To Specify Parent Object Information

Step 4: Specify Child Object Information

To Specify Child Object Information

Step 5: Save the Object Profile

To Save the Object Profile

Learning About MIDM Maintenance Tasks

Matching Probability Weights

Merging Profiles on the MIDM

Surviving and Non-Surviving Profiles

Source Record Merges

Undoing a Merge

Assumed Matches

Potential Duplicates

Handling Potential Duplicates on the MIDM

Merge

Resolve

Survivor Calculator Overrides

Linking Source Record Fields to the SBR

Locking Field Values in the SBR

Concurrent Users on the MIDM

Modifying Profile Information on the MIDM

Modifying Information in an Object Profile

Modifying Parent Object Information in a Profile

Adding a Child Object to an Object Profile

Modifying a Child Object in a Profile

Deleting a Child Object From a Profile

Modifying Information Directly in a Source Record

Modifying the Parent Object in a Source Record

Adding a Child Object to a Source Record

Modifying a Child Object in a Source Record

Deleting a Child Object From a Source Record

Overwriting SBR Field Values

Locking an SBR Field

Unlocking an SBR Field

Overriding the Survivor Calculator's SBR

Linking an SBR Field to a Specific Source Record

Unlinking an SBR Field From a Source Record

Adding a Source Record to an Object Profile

To Add a Source Record to an Object Profile

Deactivating a Profile or Source Record

Deactivating an Object Profile

Deactivating a Source Record

Reactivating a Profile or Source Record

Reactivating an Object Profile

Reactivating a Source Record

Working with Potential Duplicate Profiles on the MIDM

Finding Potential Duplicate Profiles on the MIDM

To Find Potential Duplicates

About Duplicate Records Search Fields on the MIDM

Merging Potential Duplicate Profiles

To Combine Duplicate Profiles From the Comparison Page

Resolving Potential Duplicate Profiles on the MIDM

To Resolve Potential Duplicate Profiles From the Results List

To Resolve Potential Duplicate Profiles From the Comparison Page

Unresolving Potential Duplicate Profiles on the MIDM

To Unresolve Potential Duplicate Profiles From the Results List

To Unresolve Potential Duplicate Profiles From the Comparison Page

Working with Assumed Matches on the MIDM

Finding Assumed Matches on the MIDM

To Find Assumed Matches

About Assumed Matches Search Fields

About Assumed Match Results Fields on the MIDM

Reversing an Assumed Match on the MIDM

To Reverse an Assumed Match

Combining Object Information on the MIDM

Merging Object Profiles on the MIDM

To Merge Object Profiles

Merging Source Records on the MIDM

To Merge Source Records

Unmerging Object Information on the MIDM

Unmerging Object Profiles on the MIDM

To Unmerge Object Profiles

Unmerging Source Records on the MIDM

To Unmerge Two Merged Source Records

Learning About MIDM Reports

MIDM Production Reports

MIDM Activity Reports

Configuring MIDM Reports

Masked Data and MIDM Reports

Running MIDM Reports

To Run Reports From the MIDM

About Report Search Fields on the MIDM

Working with Potential Duplicate Profiles on the MIDM

The Duplicate Records function of the MIDM allows you to view any object profiles that are marked as potential duplicates of each other by the master index application. You can search for and view potential duplicate profiles on the MIDM, and then fix the potential duplication by either merging or resolving the two profiles. You can view potential duplicates that are resolved, but not those that are merged.

Perform any of the following tasks to monitor and fix potential duplicate profiles.

Finding Potential Duplicate Profiles on the MIDM

Potential duplicate profiles are determined based on the matching probability weight that indicates how closely two profiles match. You can easily find and compare potential duplicate profiles using the MIDM Duplicate Record function.

Figure 47 Potential Duplicate Comparison Page

image:Figure shows two potential duplicate profiles displayed in a side-by-side comparison.

To Find Potential Duplicates

  1. Obtain information about the object whose potential duplicates you want to view, such as a system in which they are registered or the login ID of the user who created the object profile.
  2. In the MIDM tabbed headings, click Duplicate Records.

    The Duplicate Records basic search page appears.


    Figure 48 Duplicate Records Basic Search Page

    image:Figure shows the Duplicate Records basic search page.
  3. Do one of the following:
    1. To search by date range only, enter the date range in the basic search fields and then click Search.
    2. To use additional criteria for the search, select Advanced Search from the Search Type field, enter your search criteria, and then click Search.

      For more information about advanced search fields, see About Duplicate Records Search Fields on the MIDM.

      The Duplicate Records results list appears with key information for each potential duplicate record displayed.

  4. In the results list, compare the displayed information to determine whether you want to view a detailed comparison of the potential duplicate profiles.

    Figure 49 Potential Duplicate Search Results List

    image:Figure shows the results of a Potential Duplicate search.
  5. To view a detailed comparison for a set of potential duplicate profiles, click the Preview button to the right of the profiles.

    Tip - The Preview button is the blue chevron button to the right of the potential duplicate profiles.


  6. To view the source records associated with any of the displayed profiles, click View Sources beneath that profile. To return to the duplicate record comparison view, click View Sources again.
  7. To view a transaction history for a displayed profile, click View History beneath that profile. To return to the comparison page, click View History again.
  8. To mark a profile as not being a duplicate of the main profile, see Resolving Potential Duplicate Profiles on the MIDM.
  9. To merge two or more profiles, see Merging Potential Duplicate Profiles.
  10. To start a new search for potential duplicate records, click Advanced Search at the top of the page.

About Duplicate Records Search Fields on the MIDM

The fields located on the Duplicate Records search page allow you to specify information about the potential duplicate profiles you want to view.

Table 7 Duplicate Records Search Fields

In this field …
type or select ...
EUID
The enterprise-wide unique identification number of one of the profiles you want to view.
System
The external system with which the object profile that caused the potential duplicate flag is associated.
Local ID
The local ID associated with the object profile in the specified system. The name of this field might be different for your implementation.
Create Date From
A beginning create date for the profiles you want to view. The query is performed for transactions that were created between the Create Date From (and Create Time From) and the To Create Date (and To Create Time).
To Create Date
The ending create date for the profiles you want to view.
Create Time From
The beginning create time for the profiles you want to view (using 24-hour notation). If no time is entered, the default value is 00:01 (12:01 A.M.).
To Create Time
The ending create time for the profiles you want to view (using 24-hour notation). If no time is entered, the default value is 24:00.
Status
The potential duplicate status of the profiles you want to view. Possible values for this field are Unresolved, Resolved, or Permanently Resolved.

Merging Potential Duplicate Profiles

When you compare potential duplicate profiles, you might find that the object profiles represent the same entity, or that a source record from one profile actually belongs in the other profile. You can perform either an object profile merge or a source record merge to correct this. When you merge profiles, the SBR of the surviving profile is automatically recalculated based on the source records involved in the merge. You can combine up to four profiles.

This topic only describes object profile merges. For more information about merging object profiles, see Combining Object Information on the MIDM. To learn how to merge source records, see Merging Source Records on the MIDM.

To Combine Duplicate Profiles From the Comparison Page

  1. Perform a search for potential duplicates on the Duplicate Records page, as described in Finding Potential Duplicate Profiles on the MIDM.
  2. To view a detailed comparison for a set of potential duplicate profiles, click the Preview button to the left of the profiles.

    Tip - The Preview button is the blue chevron button to the left of the potential duplicate profiles.


  3. On the Duplicate Records comparison page, determine which of the displayed profiles you want to keep and then click the EUID of that profile.
  4. Click the EUIDs of any other associated profile you want to merge into the profile you selected above.

    Each profile changes color to indicate it is selected.


    Figure 50 Duplicate Records – Selecting Profiles to Merge

    image:Figure shows two potential duplicate records selected for a merge.
  5. Under the far right column, click Preview.

    The merge preview profile appears, allowing you to view the profile as it will appear after the merge.


    Figure 51 Duplicate Records – Merge Preview Profile

    image:Figure shows the merge preview profile for two potential duplicate profiles.
  6. Compare the field values in the profiles to be merged to determine which values to populate into the kept profile. Click any values you want to keep.

    Note - Selecting a value to keep in the merge result profile creates a link from the SBR to the source record field that populated the field. For example, if the first name field from Record A is populated from Source Record 1, and you merge Record A into Record B and select the first name value from Record A, a link is created from the first name field in the resulting SBR to the first name field in Source Record 1. For more information on linking SBR fields to source record fields, see Overriding the Survivor Calculator's SBR.


  7. Review the merge preview profile, and then click Merge to finalize the merge.
  8. On the confirmation dialog box that appears, click OK.

    The surviving profile appears.

  9. Review the surviving object profile to determine whether any source records need to be merged or deactivated.

Resolving Potential Duplicate Profiles on the MIDM

When you compare two potential duplicate profiles and determine that they do not represent the same object, you can resolve the two profiles to flag the profiles as not being potential duplicates. There are two types of resolution. Resolve removes a potential duplicate flag, but if one of the resolved profiles is updated the records might be listed as potential duplicates again. Resolve Permanently flags the two profiles as being permanently resolved regardless of whether one of the resolved profiles is updated.

To Resolve Potential Duplicate Profiles From the Results List

If the fields on the Duplicate Records search results list are sufficient to determine that two profiles do not represent the same object, you can resolve the profiles from the search results list.

  1. Perform a search for potential duplicates on the Duplicate Records page, as described in Finding Potential Duplicate Profiles on the MIDM, and display the results list.

    The results list displays key identification fields that might provide enough information for you to determine whether the profiles should be resolved.


    Figure 52 Duplicate Records Search Result Entry

    image:Figure shows an entry in the results of a Duplicate Records search.
  2. Scroll through the results until you see the profiles you want to resolve.
  3. Beneath the duplicate profile you want to resolve from the Main EUID (the profile in the far left column), click Different Records.

    Tip - The Different Records icon is the brown icon beneath each profile.


  4. On the confirmation dialog box that appears, do one of the following:
    • To flag the potential duplicate profiles as resolved but still allow the potential duplicate listing to be reinstated in the future, select Resolve Until Recalculation.
    • To flag the potential duplicate profiles as resolved and never allow the potential duplicate listing to be reinstated, click Resolve Permanently.
  5. On the confirmation dialog box, click OK.

    The status of the potential duplicate entry is changed to Resolved and the profiles are no longer regarded as potential duplicates of one another.

  6. Repeat this for each duplicate profile you want to resolve from the main profile.
  7. If you resolve a profile in error, click Potential Duplicate beneath that profile in the results list to mark it as a potential duplicate again.

To Resolve Potential Duplicate Profiles From the Comparison Page

If you need to view detailed information about two profiles to determine whether they are a match, view them on the Duplicate Records comparison screen before you resolve them.

  1. Display a set of potential duplicates on the Duplicate Records comparison page, as described in Finding Potential Duplicate Profiles on the MIDM.

    Figure 53 Duplicate Records Comparison Page

    image:Figure shows potential duplicate profiles in a side-by-side comparison view.
  2. Beneath the duplicate profile you want to resolve from the Main EUID (the profile in the far left column), click Different Records.

    A confirmation dialog box appears.

  3. On the confirmation dialog box that appears, do one of the following:
    • To flag the potential duplicate profiles as resolved but still allow the potential duplicate listing to be reinstated in the future, select Resolve Until Recalculation.
    • To flag the potential duplicate profiles as resolved and never allow the potential duplicate listing to be reinstated, click Resolve Permanently.
  4. On the confirmation dialog box, click OK.

    The status of the potential duplicate entry is changed to Resolved and the profiles are no longer regarded as possible duplicates of one another.

  5. Repeat this for each duplicate profile you want to resolve from the main profile.
  6. If you resolve a profile in error, click Potential Duplicate beneath that profile in the results list to mark it as a potential duplicate again.

Unresolving Potential Duplicate Profiles on the MIDM

If two profiles were resolved and flagged as not being potential duplicates in error, you can undo the resolve transaction and mark them as potential duplicates once more. You can perform this from either the results list or the comparison page.

To Unresolve Potential Duplicate Profiles From the Results List

If the fields on the Duplicate Records search results list are sufficient to determine that a resolve transaction was performed in error, you can unresolve the profiles in the search results list.

  1. Perform a search for potential duplicates on the Duplicate Records page, as described in Finding Potential Duplicate Profiles on the MIDM, and display the results list.

    The results list displays key identification fields that might provide enough information for you to determine whether the profiles should be unresolved.


    Figure 54 Duplicate Records Search Result Entry

    image:Figure shows an entry in the results of a Duplicate Records search.
  2. Scroll through the results until you see the profiles you want to unresolve.
  3. Beneath the duplicate profile you want to mark as a potential duplicate with the Main EUID (the profile in the far left column), click Potential Duplicate.

    The status of the potential duplicate entry is changed from Resolved and the profiles are once again regarded as potential duplicates of one another.

To Unresolve Potential Duplicate Profiles From the Comparison Page

If you need to view detailed information about two profiles to determine whether they should be unresolved, view them on the Duplicate Records comparison screen.

  1. Display a set of potential duplicates on the Duplicate Records comparison page, as described in Finding Potential Duplicate Profiles on the MIDM.
  2. Beneath the duplicate profile you want to mark as a potential duplicate with the Main EUID (the profile in the far left column), click Potential Duplicate.

    Figure 55 Unresolving Potential Duplicate Records

    image:Figure shows a potential duplicate listing to be unresolved.
  3. On the confirmation dialog box, click OK.

    The status of the potential duplicate entry is changed from Resolved and the profiles are once again regarded as possible duplicates of one another.