Search Results generate_full_table_key

Overview

HZ_FUZZY_PUB is the public PL/SQL package within the Oracle Trading Community Architecture (TCA) that provides fuzzy matching services for party and location records in Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its principal business purpose is duplicate prevention and detection: before a new party (organization, person, or group) or address is created, applications call this package to determine whether a sufficiently similar record already exists, and to generate the normalized search keys used to perform that comparison.

The package exposes both key-generation utilities and match-evaluation functions. Key generation transforms raw name and address attributes into a canonical form based on the fuzzy matching rules configured in the TCA word lists and word replacements, while the duplicate-check functions apply those keys against existing data. The package header identifies it as a public API (HZ_FUZZY_PUB), and ETRM records eight other packages that reference it, confirming its role as a shared foundation for deduplication across TCA consumers such as customer, supplier, and contact registration flows.

The package defines two record types, party_rec_type and location_rec_type, which carry the attributes used for key generation, along with two index-by tables, location_tbl_type and party_tbl_type, for returning collections of location and party identifiers. Fields default to FND_API.G_MISS_NUM and FND_API.G_MISS_CHAR, consistent with the standard EBS API convention for unspecified attributes.

Key Procedures and Functions

• GENERATE_KEY — Generates a fuzzy match key for a single party or address. The p_key_type argument must be one of ORGANIZATION, PERSON, GROUP, or ADDRESS; for organization and group keys the party name is required, and for address keys the address lines and postal code are required.
• GENERATE_FULL_TABLE_KEY — Produces keys across a full set of source attributes, supporting batch-style key population rather than single-record generation.
• IS_DUPLICATE_PARTY — Evaluates whether a candidate party matches an existing party according to the configured fuzzy match rules; this is the party-level counterpart to the location check the user searched for.
• IS_DUPLICATE_LOCATION — Evaluates whether a candidate address matches an existing location record, returning an indication of duplication so that callers can suppress or flag redundant address creation.
• FUZZY_SEARCH_ADDRESS — Performs a fuzzy search across location data, returning matching location identifiers for review or selection by the caller.
• FUZZY_SEARCH_PARTY — Performs a fuzzy search across party data, returning matching party identifiers.

Tables Accessed

• HZ_PARTIES — The master party table; read to compare candidate names against existing organizations, persons, and groups.
• HZ_LOCATIONS — The address repository; read to compare candidate addresses against existing locations.
• HZ_WORD_LISTS — Stores the token lists that define how name and address strings are segmented for matching.
• HZ_WORD_REPLACEMENTS — Stores substitution rules (for example, standardizing abbreviations such as "ST" for "STREET") applied during normalization.
• PLITBLM — The standard EBS multibyte/character-handling table used for string processing.

Usage Notes

HZ_FUZZY_PUB is invoked from Oracle Forms and from custom PL/SQL during party and location creation to warn users of potential duplicates before data is committed. It also supports concurrent-program and batch processes that search and score existing records, and it is called by the eight dependent packages identified in ETRM. Because the package is classified as PUB, its documented procedures are supported entry points, although the header carries an older revision stamp, so implementations should validate behavior against the target release.