Search Results hz_imp_classifics_sg




Overview
Explore in AI Chat

Overview

HZ_IMP_CLASSIFICS_SG is a staging and processing table in the Oracle E-Business Suite Trading Community Architecture (TCA) data model, owned by the AR (Receivables) schema. It supports the bulk import and batch processing of party classification assignments, specifically the codes that define a trading community entity's membership in a classification category. The table functions as an internal working area for information first loaded into HZ_IMP_CLASSIFICS_INT, the interface table that receives external or batched classification data prior to validation and promotion into the base TCA tables.

The "_SG" suffix denotes a staging table (sometimes described as a "stage" or "staging group" table) used within the TCA batch import framework. Records flow from the interface table into this staging structure, where the import program applies validation rules, resolves or generates surrogate identifiers, and reconciles each row before committing it to the primary classification assignment store. The table therefore plays a transient, processing-oriented role rather than serving as a long-term system of record.

From a data modeling perspective, the supplied metadata classifies this object heuristically as standalone, indicating that its foreign-key footprint is limited and that it does not naturally resolve into a hub, link, or satellite construct without additional context. A Data Vault practitioner may reasonably treat it as a transient staging object rather than a persistent modeled entity, since its rows represent in-flight import work rather than durable business state.

Key Information Stored

The table contains 15 documented columns, capturing both batch-control metadata and the classification attributes being imported. The most significant columns fall into three groups.

The documented foreign key links CODE_ASSIGNMENT_ID to HZ_CODE_ASSIGNMENTS. No unique index or alternate business key is documented in the supplied metadata, so CODE_ASSIGNMENT_ID should be regarded as the primary surrogate reference, with PARTY_ORIG_SYSTEM plus PARTY_ORIG_SYSTEM_REFERENCE, CLASS_CATEGORY, and CLASS_CODE acting as the practical business-key combination for reconciliation.

Common Use Cases and Queries

Typical usage centers on monitoring and troubleshooting classification imports. Error diagnostics commonly filter on ERROR_FLAG, while batch reconciliation groups rows by BATCH_ID and ACTION_FLAG to confirm expected volumes. A representative query retrieving failed rows for a batch follows:

  • SELECT batch_id, int_row_id, party_id, class_category, class_code, error_flag FROM hz_imp_classifics_sg WHERE batch_id = :p_batch_id AND error_flag = 'Y';
  • Joining back to the interface table on INT_ROW_ID to recover raw source values for correction and reprocessing.
  • Joining to HZ_CODE_ASSIGNMENTS on CODE_ASSIGNMENT_ID to verify that staging assignments resolved correctly against the base classification store.

Because staging content is transient, reporting should target the base TCA tables once the import completes successfully. Direct queries against this table are most valuable during load windows and error resolution.

Related Objects

The following objects are most significant to the operation of this table:

  • HZ_IMP_CLASSIFICS_INT — the interface table supplying source rows; correlated via INT_ROW_ID.
  • HZ_CODE_ASSIGNMENTS — the base classification assignment table referenced by the CODE_ASSIGNMENT_ID foreign key.
  • HZ_CLASS_CATEGORIES — defines the categories referenced by CLASS_CATEGORY.
  • HZ_CODE_ASSIGNMENTS-related TCA classification tables and the classification import concurrent program that drives the batch.
  • HZ_PARTIES — supplies the resolved PARTY_ID against which assignments are ultimately stored.