Skip Headers

Oracle Receivables Reference Guide
Release 12.1
Part Number E13512-04
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Seeded Match Rules

Seeded Search Match Rules

Two seeded match rules, SAMPLE: BASIC SEARCH RULE and SAMPLE: ADVANCED SEARCH RULE, are provided for you to use for the Customer Search page. These rules let you search with the same criteria as in a non-DQM search, but with the robust Data Quality Management matching functionality.

You set either of these two seeded match rules, or one that you define yourself using the Data Quality Management Search Profile Options. See:

The acquisition portion of the match rule determines the displayed search criteria and potential matches. Each acquisition attribute corresponds to a search criterion. The scoring portion scores and ranks the search results.

Prerequisite

Related Topics

Match Rules Overview, Oracle Trading Community Architecture Administration Guide

SAMPLE: BASIC SEARCH RULE

This match rule provides search criteria for performing a basic DQM search.

Acquisition

This table shows the seeded attributes and transformation functions for the acquisition part of the matching process.

Attribute Name Entity Filter Attribute Match Transformation Name
Name Party No Match All Attributes SOUNDEX WR + CLEANSE
Registry ID Party No Match All Attributes EXACT
Address Address No Match All Attributes WR ADDRESS + CLEANSE
City Address No Match All Attributes CLEANSE
State Address No Match All Attributes WR STATE
Country Address No Match All Attributes EXACT
All Account Names Party No Match All Attributes CLEANSE
Contact Name Contact No Match All Attributes SOUNDEX WR PERSON + CLEANSE
Phone Number Flexible Format Contact Point No Match All Attributes EXACT
e-mail Address Contact Point No Match All Attributes CLEANSE (EMAIL)
Site Number Address No Match All Attributes EXACT
All Account Numbers Party No Match All Attributes EXACT (NUMBER)

Scoring

This table shows the seeded thresholds for the scoring part of the matching process.

Threshold Value
Match Threshold 450
Override Threshold  
Automatic Merge Threshold  

This table shows the seeded attributes and transformations for the scoring part of the matching process.

Attribute Name Entity Score Transformation Name Weight (%) Type Similarity (%)
Name Party 50 WR NAMES + CLEANSE 100 Exact  
      SOUNDEX 70 Exact  
Registry ID Party 100 EXACT 100 Exact  
Address Address 70 WR ADDRESS 100 Exact  
      WR ADDRESS + CLEANSE 70 Exact  
City Address 20 CLEANSE 70 Exact  
State Address 10 WR STATE 100 Exact  
Country Address 10 EXACT 100 Exact  
All Account Names Party 60 WR NAMES 100 Exact  
      WR NAMES + CLEANSE 80 Exact  
Contact Name Contact Point 50 WR PERSON + CLEANSE 100 Exact  
      SOUNDEX 70 Exact  
Phone Number Flexible Format Contact Point 80 EXACT 100 Exact  
e-mail Address Contact Point 80 EXACT (EMAIL) 100 Exact  
      CLEANSE (EMAIL) 70 Exact  
Site Number Address 50 EXACT 100 Exact  
All Account Numbers Party 90 EXACT (NUMBER) 100 Exact  

SAMPLE: ADVANCED SEARCH RULE

This match rule provides search criteria for performing an advanced DQM search.

Acquisition

This table shows the seeded attributes and transformation functions for the acquisition part of the matching process.

Attribute Name Entity Filter Attribute Match Transformation Name
Name Party No Match All Attributes SOUNDEX WR NAMES + CLEANSE
Registry ID Party No Match All Attributes EXACT
Tax Name Party No Match All Attributes CLEANSE
Party Type Party Yes Match All Attributes EXACT
Category Code Party No Match All Attributes EXACT
SIC Code Party No Match All Attributes EXACT
SIC Code Version Party No Match All Attributes EXACT
Tax Registration Num Party No Match All Attributes EXACT
City Address No Match All Attributes CLEANSE
State Address No Match All Attributes WR STATE
Postal Code Address No Match All Attributes EXACT
County Address No Match All Attributes CLEANSE
Province Address No Match All Attributes CLEANSE
Country Address No Match All Attributes EXACT
All Account Names Party No Match All Attributes WR NAMES + CLEANSE
Phone Number Contact Point No Match All Attributes EXACT
All Account Numbers Party No Match All Attributes EXACT (NUMBER)
Reference Use Flag Party No Match All Attributes EXACT
Corporation Class Party No Match All Attributes EXACT

Scoring

This table shows the seeded thresholds for the scoring part of the matching process.

Threshold Value
Match Threshold 480
Override Threshold  
Automatic Merge Threshold  

This table shows the seeded attributes and transformation functions for the scoring part of the matching process.

Attribute Name Entity Score Transformation Name Weight (%) Type Similarity (%)
Name Party 50 WR NAMES + CLEANSE 80 Exact  
Name Party 50 WR NAMES 100 Exact  
Name Party 50 SOUNDEX 60 Exact  
Registry ID Party 100 EXACT 100 Exact  
Tax Name Party 30 CLEANSE 100 Exact  
Reference Use Flag Party 20 EXACT 100 Exact  
Category Code Party 10 EXACT 100 Exact  
SIC Code Party 30 EXACT 100 Exact  
SIC Code Version Party 10 EXACT 100 Exact  
Tax Registration Num Party 80 EXACT 70 Exact  
Corporation Class Party 30 EXACT 100 Exact  
City Address 30 CLEANSE 70 Exact  
State Address 20 WR STATE 80 Exact  
Postal Code Address 30 EXACT 100 Exact  
County Address 20 CLEANSE 70 Exact  
Province Address 10 CLEANSE 70 Exact  
Country Address 30 EXACT 100 Exact  
All Account Names Party 50 EXACT 100 Exact  
Phone Area Code Contact Point 30 EXACT 100 Exact  
All Account Numbers Party 100 EXACT (NUMBER) 100 Exact  
Phone Number Contact Point 50 EXACT 100 Exact  
Phone Country Code Contact Point 10 EXACT 100 Exact