Search Results hz_party_interface_errors_s

Overview

HZ_MAP_PARTY_PUB is a public PL/SQL package body in the Oracle E-Business Suite Trading Community Architecture (TCA) schema. Its principal business function is to map, conform, and store external party information — most notably Dun & Bradstreet (DNB) hierarchy data — onto the TCA entity model. The package consumes staged data in the HZ_PARTY_INTERFACE table and transforms it into fully formed TCA registries such as parties, locations, organization profiles, contact points, financial reports, and relationship records. The header comment, dated January 2003, documents the introduction of the "conform party" procedure that aligns a purchased party to the DNB hierarchy, confirming the package's long-standing role in third-party data enrichment. The package name and modification history ($Header: ARHMAPSB.pls) indicate a Receivables-originated module that was later centralised within the HZ (Trading Community) product family.

Key Procedures and Functions

The documented public interface exposes twelve procedures, each handling a discrete stage of the mapping and loading process:

• MAP — The primary entry point that orchestrates mapping of a party interface record into the TCA data model.
• MAP_CONC_WRAPPER — A concurrent-program wrapper that drives the MAP logic across batches of interface rows.
• STORE_ORG — Persists organisation-level party and organisation profile data derived from the interface record.
• STORE_PARTY_SITE — Creates and stores party site records, linking locations to parties.
• STORE_CONTACT_POINT — Persists contact point information such as phone numbers, e-mail, and addresses.
• STORE_CREDIT_RATINGS — Writes credit rating data obtained from the external provider into the credit ratings table.
• DO_STORE_FINANCIAL_REPORT — Loads financial report records associated with the mapped party.
• DO_STORE_FINANCIAL_NUMBER — Stores discrete financial figures tied to the party and its reports.
• STORE_PARTY_REL — Establishes relationships between parties, including DNB hierarchy relationships among parent, subsidiary, and related entities.
• STORE_BUSINESS_REPORT — Persists business report classification and code assignment data.
• DO_STORE_LOCATION — Creates or updates location records used by party sites and addresses.
• STORE_CLASSIFICATION — Inserts classification code assignments, including content source type information.

Supporting private elements include the do_map and check_mosr_mapping procedures and the related_duns_rec_type record type, which carries DUNS number, name, country, address, relationship code, and main party identifiers.

Tables Accessed

The package reads and writes a focused set of TCA tables via APPS synonyms. HZ_PARTY_INTERFACE supplies the inbound staged records, with HZ_PARTY_INTERFACE_ERRORS capturing validation failures. HZ_PARTIES and HZ_ORGANIZATION_PROFILES receive the canonical party and profile rows. HZ_LOCATIONS and HZ_CONTACT_POINTS hold addresses and contact data. HZ_CODE_ASSIGNMENTS, HZ_FINANCIAL_REPORTS, HZ_FINANCIAL_NUMBERS, and HZ_CREDIT_RATINGS store classification, financial, and rating information. HZ_ORIG_SYS_REFERENCES tracks source-system lineage, while HZ_DNB_REQUEST_LOG and its sequence log external DNB requests. FND_CURRENCIES validates currency references.

Usage Notes

HZ_MAP_PARTY_PUB is typically invoked through the MAP_CONC_WRAPPER concurrent program during DNB data-loading runs, or directly from custom PL/SQL when an interface row must be conformed programmatically. Because the package holds a PUB classification it is an approved integration point, but callers should supply fully populated HZ_PARTY_INTERFACE rows and inspect the returned return status and error tables. No other packages were found to reference this package, indicating it is called predominantly from concurrent processing or standalone custom code rather than from within the standard TCA API chain.