Search Results hz_match_rule_3




Overview
Explore in AI Chat

Overview

HZ_MATCH_RULE_3 is an Oracle Applications (APPS) PL/SQL package that belongs to the Oracle Trading Community Architecture (TCA) and, more specifically, to the Data Quality Management (DQM) subsystem of Oracle E-Business Suite. Its principal business function is to implement duplicate identification and party matching logic across the HZ schema. When customers, organizations, contacts, or contact points are entered or imported, the package evaluates them against defined match rules stored in HZ_MATCH_RULES_B and determines whether the records represent duplicates or matches of existing parties.

In the context of the user search "hz_party_search," HZ_MATCH_RULE_3 is directly relevant because it is a dependency of HZ_PARTY_SEARCH. The party search infrastructure invokes the matching routines in HZ_MATCH_RULE_3 to return scored and ranked candidate parties rather than relying on exact-key lookups alone. This relationship is documented in the ETRM dependency metadata, which lists APPS.HZ_PARTY_SEARCH as a referencing object and HZ_MATCH_RULE_3 as a referenced object, with mutual dependency. The package status is VALID in the APPS schema and is classified as an OTHER API.

Key Procedures and Functions

The documented API exposes 29 procedures and functions, organized around retrieval and matching of different TCA entity types.

No parameter lists are asserted here; only documented names and purposes are described.

Tables Accessed

The package reads and writes the following documented tables via APPS synonyms:

Usage Notes

HZ_MATCH_RULE_3 is not intended for direct end-user invocation. It is called from HZ_PARTY_SEARCH, which in turn supports the TCA party search and duplicate prevention flows surfaced in the Customers, Suppliers, and TCA administration forms. It is also invoked by DQM concurrent programs such as duplicate identification and merge batch processes, and by the party import interfaces. The mutual dependency between HZ_MATCH_RULE_3 and HZ_PARTY_SEARCH means changes to either object can affect the other. Custom code should call the public party search API rather than HZ_MATCH_RULE_3 directly, since the package is classified as OTHER and its internal record-mapping structures are not part of a supported public interface.