Search Results populate_error_table




Overview
Explore in AI Chat

Overview

The APPS.HZ_IMP_LOAD_CONTACT_ROLE_PKG package body is a component of the Oracle E-Business Suite Trading Community Architecture (TCA) bulk import infrastructure. Its primary business function is to load contact role assignments from the interface staging area into the production HZ_ORG_CONTACT_ROLES base table, which stores the relationship records that link a contact to an organization with a specific role designation (such as Accounts Payable contact, buyer, or other responsibility types).

The package operates as part of the broader Customer Interface / Contact Import pipeline, in which external data is first staged in interface tables, validated, and then transferred to the base tables through a controlled loading process. In the context of the user's search term populate_error_table, this package is responsible for capturing and recording any validation or DML exceptions encountered during the load, so that failed rows can be diagnosed, corrected, and reprocessed.

Key Procedures and Functions

  • LOAD_CONTACTROLES — The principal documented procedure of the package. It drives the loading of contact role records from the interface staging tables into the base HZ_ORG_CONTACT_ROLES table. During execution it evaluates each staged row's action flag (insert, update, or delete) and performs the corresponding DML. It also handles re-run and duplicate detection logic.
  • populate_error_table — A supporting procedure (visible in the header excerpt) that records errors raised during load processing. It inspects the incoming DML record, duplicate-value exception flag, and SQL error message to classify the failure. For example, it checks for constraint violations such as the HZ_ORG_CONTACT_ROLES_U1 unique key, distinguishing genuine duplicate-value exceptions from other errors and writing the appropriate error entry into the interface error tables.

Tables Accessed

  • HZ_IMP_CONTACTROLES_INT — The primary interface (staging) table from which contact role rows are read for loading.
  • HZ_IMP_CONTACTROLES_SG — A staging/grouping table used in conjunction with the interface table during the import process.
  • HZ_ORG_CONTACT_ROLES — The TCA base table that stores the actual organization-to-contact role assignments; this is the target of the load.
  • HZ_IMP_ERRORS and HZ_IMP_ERRORS_S — The error tables into which populate_error_table writes failure details for rows that could not be loaded. The sequence HZ_IMP_ERRORS_S supplies the error ID.
  • HZ_IMP_TMP_ERRORS — A temporary error table used for intermediate error collection during processing.

Usage Notes

This package is not typically invoked directly by end users. It is called during the TCA bulk contact import flow, most commonly via the Customer Interface / Contact Import concurrent programs that process the interface tables in batches. The metadata indicates the package is referenced by one other package, reflecting its role as a load helper within a larger import driver.

Custom code or extensions integrating contact role data should populate the interface tables and then invoke the standard import concurrent program rather than calling LOAD_CONTACTROLES directly. Error rows written by populate_error_table are subsequently reviewed through the standard import error inquiry screens, where the SQL error message and duplicate-value indicators recorded by this procedure guide correction and re-submission. The package is compatible with both EBS 12.1.1 and 12.2.2, as it resides in the APPS schema and forms part of the stable TCA import framework.