Search Results hz_imp_classifics_int




Overview
Explore in AI Chat

Overview

The HZ_IMP_CLASSIFICS_INT table is a TCA (Trading Community Architecture) interface table owned by the AR schema in Oracle E-Business Suite release 12.1.1 and 12.2.2. It serves as a staging area for bulk import of classification data that ultimately populates HZ_CODE_ASSIGNMENTS, the base table that stores code assignments for parties. Classification codes in TCA represent standardized categorizations such as industry codes (SIC, NAICS), customer classifications, and user-defined code categories assigned to parties. Because these assignments frequently arrive from external systems in high volumes, Oracle routes them through this interface table, where they are validated, enriched with error tracking, and then processed by the TCA Party Import concurrent program.

From a Data Vault modeling perspective, the mined relationship metadata suggests this object is satellite-leaning. Its structure—foreign key to a batch header plus descriptive classification attributes—mirrors the pattern of a descriptive satellite attached to a batch hub, rather than a pure hub or link. The single documented foreign key (BATCH_ID referencing HZ_IMP_BATCH_SUMMARY) reinforces this characterization: rows carry detailed, time-stamped descriptive context about a batch-driven load rather than representing an independent business entity.

Key Information Stored

The table contains 23 documented columns. The most significant are:

No unique index is documented in the ETRM metadata; the de facto business key is the combination of batch, party reference, category, and code.

Common Use Cases and Queries

The primary usage is diagnosing and monitoring classification import loads. Typical scenarios include identifying unprocessed rows, reviewing errors, and reconciling staged data against loaded HZ_CODE_ASSIGNMENTS records.

  • Checking batch-level processing status: 
    SELECT BATCH_ID, INTERFACE_STATUS, COUNT(*)
FROM   HZ_IMP_CLASSIFICS_INT
GROUP  BY BATCH_ID, INTERFACE_STATUS;
  • Listing failed interface rows for correction: 
    SELECT PARTY_ORIG_SYSTEM, PARTY_ORIG_SYSTEM_REFERENCE,
       CLASS_CATEGORY, CLASS_CODE, ERROR_ID
FROM   HZ_IMP_CLASSIFICS_INT
WHERE  INTERFACE_STATUS = 'ERROR';
  • Reporting pending classifications awaiting import, filtered by request-id for a specific concurrent program run.
  • Reconciling inserted versus updated assignments using INSERT_UPDATE_FLAG.

Related Objects

  • HZ_IMP_BATCH_SUMMARY — joined on BATCH_ID; the parent batch header controlling this interface load.
  • HZ_CODE_ASSIGNMENTS — the destination base table this interface ultimately populates.
  • HZ_PARTIES — provides party identity context via PARTY_ID and origin system references.
  • HZ_CODE_ASSIGNMENT_TYPES / HZ_CLASS_CATEGORIES — define valid classification categories referenced by CLASS_CATEGORY.
  • HZ_IMP_PARTIES_INT — companion party interface table populated in the same import cycle.
  • TCA Party Import concurrent program — the processing engine that consumes rows from this table.