Search Results replace_word

Overview

HZ_FUZZY_PUB is the public PL/SQL package that implements Oracle E-Business Suite's fuzzy matching engine for Trading Community Architecture (TCA) data. Its business purpose is to determine whether an inbound or manually entered party (organization or person) or address is a probable duplicate of an existing record, even when the two values are not textually identical due to misspellings, punctuation differences, transposed characters, or abbreviations. Oracle's DQM (Data Quality Management) and customer/party maintenance flows rely on this logic to prevent redundant party and location records from accumulating in HZ_PARTIES and HZ_LOCATIONS. The package body is organized around a set of private cleansing and key-generation routines — notably a cleanse function that collapses double consonants and strips interior vowels, and the header comment documents global translation strings that "replace punctuation characters" using a TRANSLATE-based substitution. These private helpers feed the public entry points that callers are permitted to invoke.

Key Procedures and Functions

• GENERATE_KEY — Produces a fuzzy match key from an input text value. The key is a normalized, derived representation used downstream for comparison rather than exact textual equality.
• GENERATE_FULL_TABLE_KEY — Generates keys in bulk for an entire set of records, supporting table-level or batch key population rather than single-record processing.
• IS_DUPLICATE_PARTY — Evaluates whether a candidate party corresponds to an existing party record, returning the duplicate determination used to gate party creation.
• IS_DUPLICATE_LOCATION — Performs the analogous duplicate determination for location records.
• FUZZY_SEARCH_PARTY — Executes the fuzzy search against party data, using the generated keys to retrieve probable matches.
• FUZZY_SEARCH_ADDRESS — Executes the corresponding fuzzy search against address/location data.

The private cleanse function is documented as being called solely from the Replace_Word path, and the body caches word-list identifiers for the ORGANIZATION_NAME_DICTIONARY, PERSON_NAME_DICTIONARY, and ADDRESS_DICTIONARY into package globals (g_org_word_list_id, g_per_word_list_id, g_add_word_list_id).

Tables Accessed

• HZ_PARTIES — Source of existing party records against which candidate parties are compared by IS_DUPLICATE_PARTY and FUZZY_SEARCH_PARTY.
• HZ_LOCATIONS — Source of existing location records used by IS_DUPLICATE_LOCATION and FUZZY_SEARCH_ADDRESS.
• HZ_WORD_LISTS — Stores the name dictionaries (organization, person, address) whose identifiers are cached in package globals for word-level matching.
• HZ_WORD_REPLACEMENTS — Supplies the special-character and word substitution pairs loaded into the g_original_key / g_replacement_key associative arrays.
• PLITBLM — Oracle's standard PL/SQL table-name utility, referenced internally (commonly for table/column metadata lookups).

Usage Notes

HZ_FUZZY_PUB is classified as a public (PUB) API and is referenced by eight other packages, indicating that the standard TCA party and location maintenance flows call it rather than duplicating the matching logic. Typical invocation points include the party and customer maintenance forms, duplicate-detection logic during party or account creation, and concurrent or batch programs that invoke GENERATE_FULL_TABLE_KEY to populate keys across existing data. Custom code should call only the six documented public routines and should not depend on the private cleanse/Replace_Word internals, whose behavior is driven by configuration held in HZ_WORD_LISTS and HZ_WORD_REPLACEMENTS. Because the package maintains session-level cached globals for the dictionary word-list identifiers, callers should expect the first invocation in a session to incur lookup overhead. Note that the header revision (120.9) is considerably older than the 12.1.1/12.2.2 releases, so functionality should be validated against the installed patch level.