Search Results hz_party_site_uses_s

Overview

HZ_IMP_LOAD_SSM_MATCHING_PKG is a public PL/SQL package body owned by the APPS schema that forms part of the Oracle Trading Community Architecture (TCA) bulk import infrastructure in Oracle E-Business Suite 12.1.1 and 12.2.2. Its purpose is to perform the "matching" phase of the Supplier/Customer (SSM — Source System Mapping) import process, reconciling the staged records held in the HZ_IMP_*_INT interface tables and their staging (_SG) counterparts against the live TCA registry entities. Rather than creating new registry records, the package compares inbound import data with existing parties, addresses, contacts, classifications and relationships so the import process can determine whether an incoming record is a new entity, a duplicate of an existing entity, or an update to an existing entity. The ETRM metadata classifies the package under the API classification OTHER and records eleven documented program units. The package is validated and is referenced by three other database objects; it does not itself reference any TCA package, which confirms its role as a leaf-level utility invoked by the higher-level import driver programs.

Key Procedures and Functions

The eleven documented program units follow a consistent, entity-oriented naming convention, each responsible for matching one logical grouping of TCA data:

• MATCH_PARTIES — matches staged party records against existing HZ_PARTIES rows to identify duplicate or related organisations and persons.
• MATCH_ADDRESSES — matches staged address data against existing party site records.
• MATCH_CONTACT_POINTS — reconciles telephone, e-mail, URL and similar contact point information against existing contact point records.
• MATCH_CREDIT_RATINGS — matches inbound credit rating information against existing credit rating records.
• MATCH_CODE_ASSIGNMENTS — matches classification code assignments between staging and registry.
• MATCH_FINANCIAL_REPORTS — matches financial report entries, operating on the HZ_FINANCIAL_REPORTS base and _S (sequence/intersection) tables.
• MATCH_FINANCIAL_NUMBERS — matches financial number values (for example, revenue or headcount figures) against existing registry records.
• MATCH_RELATIONSHIPS — matches party-to-party relationship rows such as organisational hierarchies and contact relationships.
• MATCH_CONTACTS — matches contact person records against existing org contacts.
• MATCH_CONTACTROLES — matches the roles assigned to contacts against existing contact role assignments.
• MATCH_ADDRUSES — matches address usage records that link addresses to specific business purposes.

No parameter lists are documented in the ETRM metadata; the procedures are described here by purpose only.

Tables Accessed

The package operates on two classes of objects. The first is the interface/staging layer, comprising HZ_IMP_PARTIES_INT, HZ_IMP_ADDRESSES_INT, HZ_IMP_ADDRESSUSES_INT, HZ_IMP_CLASSIFICS_INT, HZ_IMP_CONTACTPTS_INT, HZ_IMP_CONTACTROLES_INT, HZ_IMP_CONTACTS_INT, HZ_IMP_CREDITRTNGS_INT, HZ_IMP_FINNUMBERS_INT, HZ_IMP_RELSHIPS_INT and HZ_IMP_FINREPORTS_INT, together with their _SG staging counterparts. These hold the data extracted from the source system before matching. The second class is the destination registry layer: HZ_PARTIES and HZ_PARTIES_S, HZ_PARTY_SITES and HZ_PARTY_SITES_S, HZ_PARTY_SITE_USES and HZ_PARTY_SITE_USES_S, HZ_CONTACT_POINTS and HZ_CONTACT_POINTS_S, HZ_CREDIT_RATINGS and HZ_CREDIT_RATINGS_S, HZ_CODE_ASSIGNMENTS and HZ_CODE_ASSIGNMENTS_S, HZ_FINANCIAL_NUMBERS and HZ_FINANCIAL_NUMBERS_S, HZ_FINANCIAL_REPORTS and HZ_FINANCIAL_REPORTS_S, HZ_RELATIONSHIPS and HZ_RELATIONSHIPS_S, HZ_ORG_CONTACT_ROLES and HZ_ORG_CONTACT_ROLES_S, and HZ_ORG_CONTACTS_S. The package also touches HZ_ORIG_SYS_REFERENCES, which maps source-system identifiers to TCA entity identifiers — the critical linkage used to detect records already imported from the same source. The _S suffixed tables are the TCA intersection/sequence tables that store multi-row attribute sets for each entity.

Usage Notes

The package is not intended for direct invocation by end users. It is called internally by the TCA bulk import concurrent programs that read the HZ_IMP_*_INT interface tables, typically after the load and before the create/update phase. Customers performing large data conversions, supplier or customer onboarding, or data migration from legacy systems encounter this package indirectly through the standard import concurrent program. Because the package is referenced by three other database objects, it should be treated as part of the shipped TCA data model: any custom code extending the import should call the higher-level import driver rather than these matching routines directly, and the package should never be modified, since patching in 12.1.1 and 12.2.2 will overwrite non-standard changes. Tracing execution of the import concurrent request is the recommended way to observe its behaviour. The reference to HZ_FINANCIAL_REPORTS_S, the object matching the user's search string, confirms that financial report matching is one of the registry domains handled by this package.