Search Results import_batch

Overview

HZ_BATCH_IMPORT_PKG is the batch import controller package within the Oracle E-Business Suite Trading Community Architecture (TCA) and Receivables (AR) module. Its header revision (ARHIBASS.pls 120.4, dated 2006/03/22) indicates that it belongs to the Receivables family of library units, even though the objects it manipulates reside in the HZ schema. The package exists to drive the concurrent import of a named batch of interface records into the TCA registry, orchestrating party, address, contact, relationship, classification, and credit data from the HZ_IMP_* staging and interface tables. In practice it serves as the programmatic entry point behind the TCA batch import concurrent program, allowing bulk loads of customer and party data to be validated, de-duplicated, and merged into the production registry according to configurable rules.

Key Procedures and Functions

The documented package exposes two procedures.

• import_batch — The core concurrent-program procedure for importing a batch. It accepts the batch identity and a set of import run options that determine whether batch de-duplication, registry de-duplication, address validation, and automatic merge processing are performed, along with the applicable deduplication rule identifiers and actions. It returns the generated batch identifier, a standard FND_API return status (success, error, or unexpected error), and message-stack count and text outputs. The concurrent program interface parameters (errbuf and retcode) confirm it is designed to be registered directly as a concurrent executable.
• get_current_run — A helper that, given a batch identifier, returns the current run number for that batch. This supports tracking of repeated import attempts against the same batch and is likely used internally to coordinate run sequencing or for diagnostic reporting.

Tables Accessed

The package operates primarily against interface and staging tables, which it reads to obtain incoming data and updates to record processing outcomes.

• HZ_IMP_BATCH_SUMMARY and HZ_IMP_BATCH_DETAILS — header and line-level batch records that identify the batch, its contents, and its current run state.
• HZ_IMP_ADDRESSES_INT — the address interface table used as input for address processing.
• HZ_IMP_PARTIES_SG, HZ_IMP_ADDRESSES_SG, HZ_IMP_ADDRESSUSES_SG, HZ_IMP_CONTACTS_SG, HZ_IMP_CONTACTPTS_SG, HZ_IMP_CONTACTROLES_SG, HZ_IMP_CLASSIFICS_SG, HZ_IMP_RELSHIPS_SG, HZ_IMP_FINNUMBERS_SG, HZ_IMP_FINREPORTS_SG, and HZ_IMP_CREDITRTNGS_SG — the staging tables holding party, address, contact, contact point, contact role, classification, relationship, financial number, financial report, and credit rating data pending import.
• HZ_IMP_OSR_CHANGE — records change information associated with origin source references during import.

These tables are accessed through APPS synonyms; the package itself is owned by APPS.

Usage Notes

HZ_BATCH_IMPORT_PKG is typically invoked indirectly. Its import_batch procedure is registered as the executable entry point for the TCA batch import concurrent program, so operators submit a concurrent request specifying a batch name and the desired deduplication, validation, and merge options rather than calling the package directly. The deduplication and address validation parameters correspond to rule sets configured in TCA administration, and automatic merge processing is opt-in. Custom code may call get_current_run to determine the run number of a batch before or after a submission. As an OTHER-classified API in the ETRM documentation, the package is not part of the formally supported public API surface; extensions should prefer supported TCA APIs, and the package is referenced by one other package in the documented dependency set.