JavaScript is required to for searching.
Skip Navigation Links
Exit Print View
Working With the EDM for Oracle Java CAPS Master Index     Java CAPS Documentation
search filter icon
search icon

Document Information

Working With the EDM for Oracle Java CAPS Master Index

Related Topics

About the Enterprise Data Manager

About Oracle Java CAPS Master Index (Repository)

About Master Index Applications (Repository)

Features of Master Index Applications (Repository)

Functions of the Enterprise Data Manager

Learning about EDM Object Profiles

EDM Object Profile Components

System Records

Single Best Record

Survivor Calculator

Object Profile Indicators on the EDM

System Record and SBR Components in a Master Index (Repository)

Identification Numbers for each Entity in the Master Index (Repository)

EUID

Local ID

Working with the Enterprise Data Manager

Logging in to the Enterprise Data Manager

To Log in to the EDM

Enterprise Data Manager Security Permissions

Enterprise Data Manager Navigation Tips

Navigating the EDM Functions

Navigating the EDM Search Pages

Navigating the EDM Detail Pages

Logging Out of the EDM

Learning About Object Queries on the EDM

About the EDM Search Function

The Lookup Page

The Search Page

The Comparison Lookup Page

The Search Result Page

Types of EDM Searches

EUID Lookup

Local ID Lookup

Advanced Search

Comparison Lookup

Searching by Ranges on the EDM

Required Fields on the EDM

Searching for Object Profiles on the EDM

Performing an EUID Lookup on the EDM

To Perform an EUID Lookup

Performing a Local ID Lookup on the EDM

To Perform a Local ID Lookup

Performing an Alphanumeric Search on the EDM

To Perform an Alphanumeric Search

Performing a Phonetic Search on the EDM

To Perform a Phonetic Search

Performing a Blocker Search on the EDM

To Perform a Blocker Search

Performing an EUID Comparison Lookup on the EDM

To Perform an EUID Comparison Lookup

Working with Search Results on the EDM

Viewing the Results of a Search

Sorting the Results of Your Search

Selecting a Profile from the Results List

Creating and Printing a Search Result Report

Learning About Object Profile Views on the EDM

Object Profile Details on the EDM

The Tree View

Information Fields

Object Profile Comparisons on the EDM

Object Profile Transaction Histories on the EDM

Object Profile Merge Histories on the EDM

The EDM Audit Log

Viewing Object Profile Information on the EDM

Viewing Object Profiles on the EDM

To View Object Information

Comparing Object Information on the EDM

Comparing two Object Profiles

Comparing Records in one Object Profile

Viewing a Profile's Transaction History on the EDM

To View a Transaction History

About Transaction History Search Fields on the EDM

About Transaction History Results Fields on the EDM

Transaction History Transaction Types on the EDM

Viewing a Profile's Merge History on the EDM

Viewing a Merge History Tree

Viewing an Object Profile From a Merge History Tree

Viewing the EDM Audit Log

To View the Audit Log

About Audit Log Search Fields on the EDM

About Audit Log Results Fields on the EDM

Audit Log Functions on the EDM

Adding an Object Profile on the EDM

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 EDM Maintenance Tasks

Matching Probability Weights

Merging Profiles on the EDM

Surviving and Non-surviving Profiles

System Record Merges

Undoing a Merge

Assumed Matches

Potential Duplicates

Handling Potential Duplicates on the EDM

Merge

Resolve

Update Tips for the EDM

Concurrent Users

Updating the SBR versus System Records

Modifying Profile Information on the EDM

Modifying Parent Object Information

To Modify Parent Object Information

Adding a Child Object on the EDM

To Add a Child Object

Modifying a Child Object on the EDM

To Modify a Child Object

Deleting a Child Object on the EDM

To Delete a Child Object

Updating the Single Best Record Directly on the EDM

Locking an SBR Field

Unlocking an SBR Field

Adding a System Record to an Object Profile on the EDM

To Add a System Record to an Object Profile

Deactivating a Profile or System Record on the EDM

Deactivating an Object Profile

Deactivating a System Record

Reactivating a Profile or System Record on the EDM

Reactivating an Object Profile

Reactivating a System Record

Working with Potential Duplicate Profiles on the EDM

Finding Potential Duplicate Profiles on the EDM

To Find Potential Duplicates

About Matching Review Search Fields on the EDM

About Potential Duplicate Results Fields on the EDM

Merging Potential Duplicate Profiles on the EDM

To Combine Object Profiles

To Combine System Records

Resolving Potential Duplicate Profiles on the EDM

To Resolve two Potential Duplicate Profiles

Working with Assumed Matches on the EDM

Finding Assumed Matches on the EDM

To Find Assumed Matches

About Assumed Match Results Fields on the EDM

Reversing an Assumed Match on the EDM

To Reverse an Assumed Match

Combining Object Information on the EDM

Merging Object Profiles on the EDM

To Merge Object Profiles

Merging System Records on the EDM

To Merge System Records

Unmerging Object Information on the EDM

Unmerging Object Profiles on the EDM

To Unmerge two Merged Object Profiles

Unmerging System Records on the EDM

To Unmerge two Merged System Records

Learning About EDM Reports

EDM Production Reports

EDM Activity Reports

EDM Search Result Reports

Configuring EDM Reports

Masked Data and EDM Reports

Running EDM Reports

To Run Reports From the EDM

About Report Search Fields on the EDM

Learning about EDM Object Profiles

The information about an object in a master index application is stored in an object profile. The profile includes information from all of the system records for that object and also includes a record that contains the best information about the object according to a master index application. See the following topics for information about object profiles.

EDM Object Profile Components

An object profile, also known as an enterprise record, is a set of information that describes characteristics of an individual object in the master index application. Figure 1 illustrates an EUID tree for an object profile, which shows all components of a profile.

Figure 1 Object Profile Components

image:Figure shows the expanded tree view of an object profile.

A profile contains two types of records:

System Records

System records are different from the SBR in that each system record contains a system and local ID pair and only contains data from a specific system. The information in the system records of an object profile is used to determine the best value for the SBR in that profile. If an object profile only contains one system record, the SBR will be identical to that system record. However, if an object profile contains multiple system records, the SBR might be identical to one system record but will more likely include a combination of information from all system records. Certain actions against a system record will cause the SBR to be changed, such as updating, deactivating, or merging a system record. Each active object profile must have at least one active system record. If all system records in a profile are deactivated, then the entire profile will also be deactivated.

Single Best Record

The single best record (SBR) for an object profile is made up of a combination of information from all active system records associated with that object profile. The SBR represents the information that is determined by the master index application to be the most reliable and current of all system records in an object profile. The SBR is dynamic and is recalculated each time an update is made to an associated system record, a merge or unmerge affects the object profile, or a system record in the profile is deactivated or reactivated. You can use the overwrite capability of the EDM to update the SBR directly or you can update a system record and allow the survivor calculator to determine how to update the SBR (for more information, see Survivor Calculator).

If you use the overwrite capability to update a field, that field remains locked and cannot be updated by changes to system records until the field is unlocked. For more information about the overwrite function and locked fields, see Updating the SBR versus System Records.

Survivor Calculator

The survivor calculator determines which information from each system record in an object profile is stored in the SBR for that profile. The calculator uses information defined by the system administrator to calculate the SBR. By default, the survivor calculator uses a weighted strategy for most fields, using the relative reliability assigned to each system in combination with the reliability given to the most recently updated value.

For some fields, such as alias and auxiliary IDs, a union strategy is typically used. This means that all unique alias names and auxiliary IDs from all systems are included in the SBR. For detailed information about the survivor calculator and configuring the survival strategy, see Understanding Oracle Java CAPS Master Index Configuration Options (Repository) and Configuring Oracle Java CAPS Master Indexes (Repository).

Object Profile Indicators on the EDM

In a master index application, an object profile or system record can have three different statuses: active, inactive, or merged. The EDM uses special characters in the EUID tree to indicate profiles or system records that have a status other than active. The EDM also uses indicators in the EUID tree to denote the type of profile you are viewing when a side-by-side comparison of the same EUID is displayed. For example, when a transaction history is displayed, the previous image of the profile appears in parentheses. Table 1 lists and describes each indicator.

Table 1 Object Profile Indicators

Indicator
Status
No indicator.
The status of the profile or system record is active.
Tilde (~)
The status of the profile or system record is inactive. For example, EUID=~1001002135. In addition to the tilde, the EUID appears in fuchsia typeface.
Asterisk (*)
The status of the profile or system record is merged. For example, EUID=*1001002135. In addition to the asterisk, the EUID appears in brown typeface.

Note - When an asterisk appears next to a profile on the Transaction History Search Results page, it means the transaction history could not be accessed.


Brackets ([])
Brackets indicate that the records displayed are the same version of the same profile. This is used on the Comparison page when comparing different components of the same profile. The EUID on the left appears in brackets. For example, EUID=[1001002135].
Parentheses ( () )
When a transaction or merge history is displayed, the EUID representing the previous version of the displayed profile appears in parentheses. This profile represents the status of the profile before the transaction or merge occurred. For example, EUID=(1001002135).

System Record and SBR Components in a Master Index (Repository)

In a master index application, each system record and SBR in an object profile contains a set of sub-objects that store different types of information about the object. Generally, a record contains a parent object and several child objects. A record can have only one parent object, but can have multiple child objects and multiple instances of each child object with each instance being identified by a unique field. For example, in a master person index a record can only contain one person name and social security number (contained in the parent object), but could have multiple addresses and telephone numbers (contained in child objects). Each address must be of a different type, such as a home address, billing address, or mailing address.

Identification Numbers for each Entity in the Master Index (Repository)

Each object profile in a master index application is assigned a unique identification number in addition to the local IDs assigned by individual systems. Each object has one unique identification number throughout your organization, and a unique identification number within each system with which they are registered.

EUID

Every object profile in the master index system is assigned an enterprise-wide unique identification number. This number is the same for that object regardless of the system from which the object information originates. This number is called the enterprise-wide unique identifier (EUID) and is used to cross-reference object profiles in order to accurately identify the objects throughout your organization.

Local ID

A local ID is a unique local identification number that is assigned to an object in each system at which it is registered. These numbers are assigned using a numbering system unique to each local system, and are used internally by the systems to identify each object. A master index application uses an object’s EUID to cross-reference its local IDs in different systems. Note that the name of the Local ID field is configurable and might be different for your implementation.