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:
Setting Up DQM, Oracle Receivables Implementation Guide.
DQM Deployment Category, Oracle Trading Community Architecture Administration Guide.
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
Run the DQM Compile All Rules Program.
See also: DQM Compile All Rules Program, Oracle Trading Community Architecture Administration Guide.
Related Topics
Match Rules Overview, Oracle Trading Community Architecture Administration Guide
This match rule provides search criteria for performing a basic DQM search.
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) |
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 |
This match rule provides search criteria for performing an advanced DQM search.
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 Number | 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 |
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 Number | 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 |