Search Results hz_imp_errors_s




Overview
Explore in AI Chat

Overview

HZ_IMP_LOAD_CODE_ASSIGNMENTS is a valid PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. It belongs to the Oracle Trading Community Architecture (TCA) bulk import infrastructure, more specifically the Customer Interface / bulk party import concurrent program set. Its business function is to persist classification code assignments held on the interface staging tables into the production TCA tables. Classification codes in TCA are the flexible set of category values (for example industry codes, SIC codes, or user-defined classification categories) attached to parties, organizations, and person records via HZ_CODE_ASSIGNMENTS. The package reads rows that have been validated and held on the classifications interface table, resolves the owning entity (party or organization profile) using the batch identifiers and the surrogate keys held on the interface records, and then inserts or updates the corresponding rows in the code assignment entity. The package name follows the TCA importer naming convention HZ_IMP_<target entity>, and the ETRM classification for the package is OTHER — meaning it is an internal supporting routine rather than a published, callable public API. Oracle does not document a supported signature for external callers; it is invoked by the load wrapper that drives the import batch. References to HZ_IMP_ERRORS_S confirm the intended behaviour: rows that cannot be resolved, that duplicate an existing assignment, or that violate validation rules are recorded in the interface error tables rather than causing the whole batch to fail.

Key Procedures and Functions

The documented package exposes a single procedure, LOAD_CODE_ASSIGNMENTS, which forms the unit of work for this stage of the import. Its purpose is to perform the set-based load of code assignment records for the current import batch: it selects eligible rows from the classifications interface structures, applies the resolved ownership keys, and writes the resulting assignments to HZ_CODE_ASSIGNMENTS. ETRM records no formal parameter list, consistent with the package being driven internally by the concurrent importer, which typically passes batch and run identifiers through session context or profile state rather than through an explicit API signature. Error handling is delegated to the standard message stack (FND_MSG_PUB, FND_MESSAGE, FND_API) and to the interface error tables.

Tables Accessed

The documented object dependencies and referenced synonyms identify the following data stores. HZ_IMP_CLASSIFICS_INT and HZ_IMP_CLASSIFICS_SG are the interface tables holding incoming classification assignment rows, including batch identifiers and entity references. HZ_CODE_ASSIGNMENTS is the production TCA table into which the resolved assignments are inserted. HZ_IMP_PARTIES_INT holds the interface party rows to which the assignments relate, and HZ_PARTIES and HZ_ORGANIZATION_PROFILES are the production TCA tables consulted to resolve a valid owning party or organization profile. HZ_IMP_ERRORS, HZ_IMP_ERRORS_S, and HZ_IMP_TMP_ERRORS support rejection and error reporting for individual interface rows; the _S suffixed objects are the non-translated base variants used by the bulk import code to avoid language-sensitive lookups during the high-volume load. DUAL and PLITBLM are used for PL/SQL statement generation and name-value parsing. Support routines from HZ_IMP_CLASSIFICS_SG, HZ_IMP_LOAD_WRAPPER, HZ_DSS_UTIL_PUB, HZ_MIXNM_UTILITY, and HZ_MIXNM_CONC_DYNAMIC_PKG provide key resolution, dynamic SQL, and mix-and-match processing of assignments.

Usage Notes

This package is not intended to be called directly by customers or custom code. It is invoked by the TCA bulk import concurrent program flow through HZ_IMP_LOAD_WRAPPER, which sequences the individual loaders after the validation stage, and it is referenced by one other package in the schema. Because it is not referenced by any database object outside this dependency chain, it cannot be reached through another entry point in the documented model. Practically, users reach it indirectly by submitting the party or customer import concurrent program (often described as the Customer Interface or Bulk Import program) after their source data has been loaded into the HZ_IMP interface tables. Failures surface as rows in HZ_IMP_ERRORS and HZ_IMP_TMP_ERRORS, which is why the object is commonly discovered through a search for hz_imp_errors_s. In 12.2.2, where TCA bulk import runs under the same APPS schema on the online patching edition, the package remains valid and unchanged in classification. Because its behaviour is not a published interface, any customization should work with the interface tables and the error tables rather than attempting to call LOAD_CODE_ASSIGNMENTS directly; Oracle may change its internals across patches.