JavaScript is required to for searching.
Skip Navigation Links
Exit Print View
Oracle Java CAPS Master Index Processing Reference     Java CAPS Documentation
search filter icon
search icon

Document Information

Oracle Java CAPS Master Index Processing Reference

Understanding Operational Processes

The Database Structure

Working with the Java API

Overview

Java Class Types

Static Classes

Dynamic Web Services Classes

Dynamic Web Service Methods

Dynamic API Method Descriptions

activateEnterpriseRecord

Description

Syntax

Parameters

Returns

Throws

activateSystemRecord

Description

Syntax

Parameters

Returns

Throws

addSystemRecord

Description

Syntax

Parameters

Returns

Throws

deactivateEnterpriseRecord

Description

Syntax

Parameters

Returns

Throws

deactivateSystemRecord

Description

Syntax

Parameters

Returns

Throws

executeMatch

Syntax

Parameters

Returns

Throws

executeMatchUpdate

Syntax

Parameters

Returns

Throws

getEnterpriseRecordByEUID

Description

Syntax

Parameters

Returns

Throws

getEnterpriseRecordByLID

Description

Syntax

Parameters

Returns

Throws

getEUID

Description

Syntax

Parameters

Returns

Throws

getLIDs

Description

Syntax

Parameters

Returns

Throws

getLIDsByStatus

Description

Syntax

Parameters

Returns

Throws

getSBR

Description

Syntax

Parameters

Returns

Throws

getSystemRecord

Description

Syntax

Parameters

Returns

Throws

getSystemRecordsByEUID

Description

Syntax

Parameters

Returns

Throws

getSystemRecordsByEUIDStatus

Description

Syntax

Parameters

Returns

Throws

lookupLIDs

Description

Syntax

Parameters

Returns

Throws

lookupPotentialDuplicates

Description

Syntax

Parameters

Returns

Throws

mergeEnterpriseRecord

Description

Syntax

Parameters

Returns

Throws

mergeSystemRecord

Description

Syntax

Parameters

Returns

Throws

searchBlock

Description

Syntax

Parameters

Returns

Throws

searchExact

Description

Syntax

Parameters

Returns

Throws

searchPhonetic

Description

Syntax

Parameters

Returns

Throws

transferSystemRecord

Description

Syntax

Parameters

Returns

Throws

updateEnterpriseRecord

Description

Syntax

Parameters

Returns

Throws

updateSystemRecord

Description

Syntax

Parameters

Returns

Throws

Web Services Helper Classes

Enterprise Object Classes

Definition

Methods

EnterpriseObjectName

Description

Syntax

Parameters

Returns

Throws

countSystemObjectName

Description

Syntax

Parameters

Returns

Throws

deleteSystemObject

Description

Syntax

Parameters

Returns

Throws

deleteSystemObjectBean

Description

Syntax

Parameters

Returns

Throws

getEUID

Description

Syntax

Parameters

Returns

Throws

getSBRObjectName

Description

Syntax

Parameters

Returns

Throws

getStatus

Description

Syntax

Parameters

Returns

Throws

getSystemObjectName

Description

Syntax

Parameters

Returns

Throws

getSystemObjectName

Description

Syntax

Parameters

Returns

Throws

getSystemObjectNameCount

Description

Syntax

Parameters

Returns

Throws

removeSystemObject

Description

Syntax

Parameters

Returns

Throws

removeSystemObjectBean

Description

Syntax

Parameters

Returns

Throws

setEUID

Description

Syntax

Parameters

Returns

Throws

setStatus

Description

Syntax

Parameters

Returns

Throws

setSystemObjectName

Description

Syntax

Parameters

Returns

Throws

SystemObjectName

Definition

Methods

Inherited Methods

Clear Field Indicator

SystemObjectName

Description

Syntax

Parameters

Returns

Throws

getClearFieldIndicator

Description

Syntax

Parameters

Returns

Throws

getField

Description

Syntax

Parameters

Returns

Throws

getObjectName

Description

Syntax

Parameters

Returns

Throws

setClearFieldIndicator

Description

Syntax

Parameters

Returns

Throws

setField

Description

Syntax

Parameters

Returns

Throws

setObjectName

Description

Syntax

Parameters

Returns

Throws

Parent Beans

Definition

Methods

Inherited Methods

ObjectNameBean

Description

Syntax

Parameters

Returns

Throws

countChild

Description

Syntax

Parameters

Returns

Throws

countChildren

Description

Syntax

Parameters

Returns

Throws

countChildren

Description

Syntax

Parameters

Returns

Throws

deleteChild

Description

Syntax

Parameters

Returns

Throws

getChild

Description

Syntax

Parameters

Returns

Throws

getChild

Description

Syntax

Parameters

Returns

Throws

getField

Description

Syntax

Parameters

Returns

Throws

getObjectNameId

Description

Syntax

Parameters

Returns

Throws

setChild

Description

Syntax

Parameters

Returns

Throws

setChild

Description

Syntax

Parameters

Returns

Throws

setField

Description

Syntax

Parameters

Returns

Throws

setObjectNameId

Description

Syntax

Parameters

Returns

Throws

Child Beans

Definition

Methods

Inherited Methods

ChildBean

Description

Syntax

Parameters

Returns

Throws

delete

Description

Syntax

Parameters

Returns

Throws

getField

Description

Syntax

Parameters

Returns

Throws

getChildId

Description

Syntax

Parameters

Returns

Throws

setField

Description

Syntax

Parameters

Returns

Throws

setChildId

Description

Syntax

Parameters

Returns

Throws

DestinationEO

Definition

Methods

getEnterpriseObjectName

Description

Syntax

Parameters

Returns

Throws

setEnterpriseObjectName

Description

Syntax

Parameters

Returns

Throws

MergeObjectNameResult

Definition

Methods

MergeObjectNameResult

Description

Syntax

Parameters

Returns

Throws

getDestinationEO

Description

Syntax

Parameters

Returns

Throws

getSourceEO

Description

Syntax

Parameters

Returns

Throws

setDestinationEO

Description

Syntax

Parameters

Returns

Throws

setSourceEO

Description

Syntax

Parameters

Returns

Throws

SBRObjectName

Definition

Methods

SBRObjectName

Description

Syntax

Parameters

Returns

Throws

SBRObjectName

Description

Syntax

Parameters

Returns

Throws

getObjectName

Description

Syntax

Parameters

Returns

Throws

getStatus

Description

Syntax

Parameters

Returns

Throws

setObjectName

Description

Syntax

Parameters

Returns

Throws

setStatus

Description

Syntax

Parameters

Returns

Throws

SearchObjectNameResult

Definition

Methods

getEUID

Description

Syntax

Parameters

Returns

Throws

getComparisonScore

Description

Syntax

Parameters

Returns

Throws

getObjectName

Description

Syntax

Parameters

Returns

Throws

setEUID

Description

Syntax

Parameters

Returns

Throws

setComparisonScore

Description

Syntax

Parameters

Returns

Throws

setObjectName

Description

Syntax

Parameters

Returns

Throws

SourceEO

Definition

Methods

getEnterpriseObjectName

Description

Syntax

Parameters

Returns

Throws

SetEnterpriseObjectName

Description

Syntax

Parameters

Returns

Throws

SystemObjectNamePK

Definition

Methods

SystemObjectNamePK

Description

Syntax

Parameters

Returns

Throws

getLocalId

Description

Syntax

Parameters

Returns

Throws

getSystemCode

Description

Syntax

Parameters

Returns

Throws

Inbound Message Processing with Custom Logic

A.  Match Types and Field Names

Dynamic Web Service Methods

A set of Java methods are created in the Master Index EJB project for use in the client applications that call Master Index functions. These methods wrap static Java API methods, allowing them to work with the dynamic object classes. Many of these methods return objects of the dynamic object type, or they use these objects as parameters. In the following methods described for web services, ObjectName indicates the name of the parent object.

Dynamic API Method Descriptions

activateEnterpriseRecord

Description

This method changes the status of a deactivated enterprise object back to active.

Syntax
void activateEnterpriseRecord(String euid)
Parameters
Name
Type
Description
euid
String
The EUID of the enterprise object to activate.
Returns

None.

Throws

activateSystemRecord

Description

This method changes the status of a deactivated system object back to active.

Syntax
void activateSystemRecord(String systemCode, String localId)
Parameters
Name
Type
Description
systemCode
String
The processing code of the system associated with the system record to be activated.
localID
String
The local identifier associated with the system record to be activated.
Returns

None.

Throws

addSystemRecord

Description

This method adds the system object to the enterprise object associated with the specified EUID.

Syntax
void addSystemRecord(String euid, SystemObjectName sysObjBean)

where ObjectName is the name of the parent object.

Parameters
Name
Type
Description
euid
String
The EUID of the enterprise object to which you want to add the system object.
sysObjBean
SystemObjectName
The Bean for the system object to be added to the enterprise object.
Returns

None.

Throws

deactivateEnterpriseRecord

Description

This method changes the status of an active enterprise object to inactive.

Syntax
void deactivateEnterpriseRecord(String euid)
Parameters
Name
Type
Description
euid
String
The EUID of the enterprise object to deactivate.
Returns

None.

Throws

deactivateSystemRecord

Description

This method changes the status of an active system object to inactive.

Syntax
void deactivateSystemRecord(String systemCode, String localId)
Parameters
Name
Type
Description
systemCode
String
The system code of the system object to deactivate.
localid
String
The local ID of the system object to deactivate.
Returns

None.

Throws

executeMatch

executeMatch is one of two methods you can call to process an incoming system object based on the configuration defined for the Manager Service and associated runtime components (the second method is executeMatchUpdate). This process searches for possible matches in the database and contains the logic to add a new record or update existing records in the database. One of the two execute match methods should be used for inserting or updating a record in the database.

The following runtime components configure executeMatch.

Syntax
MatchColResult executeMatch(SystemObjectName sysObjBean)

where ObjectName is the name of the parent object.

Parameters
Name
Type
Description
sysObjBean
SystemObjectName
The Bean for the system object to be added to or updated in the enterprise object.
Returns

A match result object containing the results of the matching process.

Throws

executeMatchUpdate

Like executeMatch, executeMatchUpdate processes the system object based on the configuration defined for the Manager Service and associated runtime components. It is configured by the same runtime components as executeMatch. One of these two execute match methods should be used for inserting or updating a record in the database.

The primary difference between these two methods is that when executeMatchUpdate finds that an incoming record matches an existing record, only the changed data is updated. With executeMatch, the entire existing record would be replaced by the incoming record. The executeMatchUpdate method differs from executeMatch in the following ways:

Syntax
MatchColResult executeMatchUpdate(SystemObjectName sysObjBean)

where ObjectName is the name of the parent object.

Parameters
Name
Type
Description
sysObjBean
SystemObjectName
The Bean for the system object to be added to or updated in the enterprise object.
Returns

A match result object containing the results of the matching process.

Throws

getEnterpriseRecordByEUID

Description

This method returns the enterprise object associated with the specified EUID.

Syntax
EnterpriseObjectName getEnterpriseRecordByEUID(String euid)
Parameters
Name
Type
Description
euid
String
The EUID of the enterprise object you want to retrieve.
Returns

An enterprise object associated with the specified EUID or null if the enterprise object is not found.

Throws

getEnterpriseRecordByLID

Description

This method returns the enterprise object associated with the specified system code and local ID pair.

Syntax
EnterpriseObjectName getEnterpriseRecordByLID(String systemCode, String localid)
Parameters
Name
Type
Description
systemCode
String
The system code of a system associated with the enterprise object to find.
localid
String
A local ID associated with the specified system.
Returns

An enterprise object or null if the enterprise object is not found.

Throws

getEUID

Description

This method returns the EUID of the enterprise object associated with the specified system code and local ID.

Syntax
String getEUID(String systemCode, String localid)
Parameters
Name
Type
Description
systemCode
String
A known system code for the enterprise object.
localid
String
The local ID corresponding with the given system.
Returns

A string containing an EUID or null if the EUID is not found.

Throws

getLIDs

Description

This method retrieves the local ID and system pairs associated with the given EUID.

Syntax
SystemObjectNamePK[] getLIDs(String euid)
Parameters
Name
Type
Description
euid
String
The EUID of the enterprise object whose local ID and system pairs you want to retrieve.
Returns

An array of system object keys (SystemObjectNamePK objects) or null if no results are found.

Throws

getLIDsByStatus

Description

This method retrieves the local ID and system pairs that are of the specified status and that are associated with the given EUID.

Syntax
SystemObjectNamePK[] getLIDsByStatus(String euid, String status)
Parameters
Name
Type
Description
euid
String
The EUID of the enterprise object whose local ID and system pairs to retrieve.
status
String
The status of the local ID and system pairs to retrieve.
Returns

An array of system object keys (SystemObjectNamePK objects) or null if no system object keys are found.

Throws

getSBR

Description

This method retrieves the single best record (SBR) associated with the specified EUID.

Syntax
SBRObjectName getSBR(String euid)
Parameters
Name
Type
Description
euid
String
The EUID of the enterprise object whose SBR you want to retrieve.
Returns

An SBR object or null if no SBR associated with the specified EUID is found.

Throws

getSystemRecord

Description

This method retrieves the system object associated with the given system code and local ID pair.

Syntax
SystemObjectName getSystemRecord(String systemCode, String localid)
Parameters
Name
Type
Description
systemCode
String
The system code of the system object to retrieve.
localid
String
The local ID of the system object to retrieve.
Returns

A system object containing the results of the search or null if no system objects are found.

Throws

getSystemRecordsByEUID

Description

This method returns the active system objects associated with the specified EUID.

Syntax
SystemObjectName[] getSystemRecordsByEUID(String euid)
Parameters
Name
Type
Description
euid
String
The EUID of the enterprise object whose system objects you want to retrieve.
Returns

An array of system objects associated with the specified EUID.

Throws

getSystemRecordsByEUIDStatus

Description

This method returns the system objects of the specified status that are associated with the given EUID.

Syntax
SystemObjectName[] getSystemRecordsByEUIDStatus(String euid, String status)
Parameters
Name
Type
Description
euid
String
The EUID of the enterprise object whose system objects you want to retrieve.
status
String
The status of the system objects you want to retrieve.
Returns

An array of system objects associated with the specified EUID and status, or null if no system objects are found.

Throws

lookupLIDs

Description

This method first looks up the EUID associated with the specified source system and source local ID. It then retrieves the local ID and system pairs of the specified status that are associated with that EUID and are from the specified destination system. Note that both systems must be of the specified status or an error will occur.

Syntax
SystemObjectNamePK[] lookupLIDs(String sourceSystemCode, String sourceLID, 
String destSystemCode, String status)
Parameters
Name
Type
Description
sourceSystemCode
String
The system code of the known system and local ID pair.
sourceLID
String
The local ID of the known system and local ID pair.
destSystemCode
String
The system from which the local ID and system pairs to retrieve originated.
status
String
The status of the local ID and system pairs to retrieve.
Returns

An array of system object keys (SystemObjectNamePK objects).

Throws

lookupPotentialDuplicates

Description

This method returns an array of potential duplicate result records based on the criteria contained in the potential duplicate search object.

Syntax
PotentialDuplicateResult[] lookupPotentialDuplicates(PotentialDuplicateSearchObjectBean pdsoBean)
Parameters
Name
Type
Description
pdsoBean
PotentialDuplicateSearchObjectBean
An object containing the criteria for a potential duplicate search.
Returns

An array of PotentialDuplicateResult objects representing the matches to a potential duplicate search.

Throws

mergeEnterpriseRecord

Description

This method merges two enterprise objects, specified by their EUIDs.

Syntax
MergeObjectNameResult mergeEnterpriseRecord(String fromEUID, String toEUID, 
boolean calculateOnly)
Parameters
Name
Type
Description
fromEUID
String
The EUID of the enterprise object that will not survive the merge.
toEUID
String
The EUID of the enterprise object that will survive the merge.
calculateOnly
boolean
An indicator of whether to commit changes to the database or to simply compute the merge results. Specify false to commit the changes.
Returns

A merge result object containing the results of the merge.

Throws

mergeSystemRecord

Description

This method merges two system objects, specified by their local IDs, from the specified system. The system objects can belong to a single enterprise object or to two different enterprise objects.

Syntax
MergeObjectNameResult mergeSystemRecord(String systemCode, String sourceLID, 
String destLID, boolean calculateOnly)
Parameters
Name
Type
Description
systemCode
String
The processing code of the system to which the two system objects belong.
sourceLID
String
The local ID of the system object that will not survive the merge.
destLID
String
The local ID of the system object that will survive the merge.
calculateOnly
boolean
An indicator of whether to commit changes to the database or to simply compute the merge results. Specify false to commit the changes.
Returns

A merge result object containing the results of the merge.

Throws

searchBlock

Description

This method performs a blocking query against the database using the blocking query specified in the master.xmland the criteria contained in the specified object bean.

Syntax
SearchObjectNameResult[] searchBlock(ObjectNameBean objBean)
Parameters
Name
Type
Description
objBean
ObjectNameBean
The search criteria for the blocking query.
Returns

An array of search result records.

Throws

searchExact

Description

This method performs an exact match search using the criteria specified in the object bean. Only records that exactly match the search criteria are returned in the search results object.

Syntax
SearchObjectNameResult[] searchExact(ObjectNameBean objBean)
Parameters
Name
Type
Description
objBean
ObjectNameBean
The search criteria for the exact match search.
Returns

An array of search result records.

Throws

searchPhonetic

Description

This method performs search using phonetic values for some of the criteria specified in the object bean. This type of search allows for typographical errors and misspellings.

Syntax
SearchObjectNameResult[] searchPhonetic(ObjectNameBean objBean)
Parameters
Name
Type
Description
objBean
ObjectNameBean
The search criteria for the phonetic search.
Returns

An array of search result records.

Throws

transferSystemRecord

Description

This method transfers a system record from one enterprise record to another enterprise record.

Syntax
void transferSystemRecord(String toEUID, String systemCode, String localID)
Parameters
Name
Type
Description
toEUID
String
The EUID of the enterprise record to which the system record will be transferred.
systemCode
String
The processing code of the system record to transfer.
localID
String
The local ID of the system record to transfer.
Returns

None.

Throws

updateEnterpriseRecord

Description

This method updates the fields in an existing enterprise object with the values specified in the fields the enterprise object passed in as a parameter. When updating an enterprise object, attempting to change a field that is not updateable will cause an exception. This method does not update the SBR; the survivor calculator updates the SBR once the changes are made to the associated system records.

Syntax
void updateEnterpriseRecord(EnterpriseObjectName eoBean)
Parameters
Name
Type
Description
eoBean
EnterpriseObjectName
The enterprise object containing the values that will update the existing enterprise object.
Returns

None.

Throws

updateSystemRecord

Description

This method updates the existing system object in the database with the given system object.

Syntax
void updateSystemRecord(SystemObjectName sysObjBean)
Parameters
Name
Type
Description
sysObjBean
SystemObjectName
The system object to be updated to the enterprise object.
Returns

None.

Throws