With word replacement, you can identify words that act like synonyms of other words for the purpose of searching and matching. Transformations can use word replacements.
Word replacement is a particularly useful technique for standardizing certain portions of your party information to minimize the effect of data entry inconsistencies on searches. You can use these word replacements in the development of transformations. In the PL/SQL functions used in transformations, code can be written to call a word replacement list.
Word replacement lists contain word pairs, each pair with an original and replacement word. The replacement word is used when the original word is identified and any specified conditions are met. Aside from using seeded conditions, you can also create your own conditions. See Creating Custom Word Replacement Conditions.
For example, this table displays possible original words for a replacement word in a word list for a specified language.
| Word List Name | Language | Original Word | Replacement Word |
|---|---|---|---|
| Person Name | American English | Bob | Robert |
| Person Name | American English | Rob | Robert |
| Person Name | American English | Robbie | Robert |
| Person Name | American English | Roberto | Robert |
| Person Name | American English | Bobby | Robert |
When you enter Rob as the value for a first name attribute of a search, the search returns records in which the first name attribute matches to the replacement word for Rob. The result of your search would return records containing Bob, Robbie, Roberto, Bobby, and Robert as well as Rob.
DQM provides word replacement lists containing over 3,000 word replacement pairs in American English. The included word lists are:
ADDRESS_DICTIONARY
DOMAIN_NAME_DICTIONARY (used for e-mail and URLs)
EXPANDED_PERSON_NAME_DICTIONARY
KEY MODIFIERS
ORGANIZATION_NAME_DICTIONARY
PERSON_NAME_DICTIONARY
US_STATE_DICTIONARY
See: Seeded Word Replacement Lists, Oracle Trading Community Architecture Reference Guide.
You can add to the lists of seeded word replacement pairs in American English or create lists in any other languages supported by Oracle Applications.
This table describes some terms in the pages used for this procedure.
Selected Terminology
| Term | Description |
|---|---|
| Identification Method | The method that the original word in a word pair is identified by:
|
| Data Source | Source of the word list, for example Seeded for seeded lists. |
To administer word replacement lists, you can:
Create, update, or copy word lists. See: Creating and Updating Word Replacement Lists.
Delete word lists only if they are not seeded.