Search Results cz_imp_tmp_itemcat




Overview
Explore in AI Chat

Overview

CZ_IMP_TMP_ITEMCAT is a transient staging table owned by the CZ (Oracle Configurator) schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It functions as an intermediate landing area for item catalog group data during Configurator import operations, allowing data to be validated and processed before it is committed to the permanent Configurator model tables. The table is populated by the Configurator import concurrent programs and is typically emptied or purged once a run completes.

The table is a two-column structure, defined by the primary key constraint CZ_IMP_TMP_ITEMCAT_PK on (RUN_ID, ITEM_CATALOG_GROUP_ID). From a Data Vault modeling perspective, the mined relationship structure classifies this object as standalone, meaning it exhibits no foreign key dependencies on other tables. The composite primary key suggests the table behaves as a staging or link-like construct where RUN_ID identifies a specific import batch and ITEM_CATALOG_GROUP_ID identifies the catalog group being processed within that batch. This classification is heuristic; because the object is a temporary import surface rather than a durable warehouse entity, it should be treated as a transient staging object rather than a canonical hub, link, or satellite.

Key Information Stored

The documented physical schema contains only two columns, both of which participate in the composite primary key:

  • RUN_ID — A surrogate-style batch identifier assigned to each Configurator import execution. It groups all rows belonging to a single import run and is the primary partition/selection key used when reading or purging staged data.
  • ITEM_CATALOG_GROUP_ID — The identifier of the item catalog group being staged for the import run. It references the catalog grouping used by Configurator to organize importable items.

Because the documented schema exposes only these two columns, there is no separate surrogate primary key distinct from the business-key candidate. The unique index CZ_IMP_TMP_ITEMCAT_PK (RUN_ID, ITEM_CATALOG_GROUP_ID) is both the physical primary key and the only documented business-key candidate. No non-key descriptive attributes are recorded in the ETRM metadata for 12.2.2.

Common Use Cases and Queries

Typical usage centers on diagnosing and monitoring Configurator imports. Administrators query the table to confirm what was staged for a given run, to detect duplicate catalog groups within a batch, or to clear orphaned rows left behind by an aborted import.

  • Inspect the contents of a specific import run:

    SELECT RUN_ID, ITEM_CATALOG_GROUP_ID FROM CZ.CZ_IMP_TMP_ITEMCAT WHERE RUN_ID = :run_id;

  • Detect duplicate catalog groups staged within a run:

    SELECT RUN_ID, ITEM_CATALOG_GROUP_ID, COUNT(*) FROM CZ.CZ_IMP_TMP_ITEMCAT GROUP BY RUN_ID, ITEM_CATALOG_GROUP_ID HAVING COUNT(*) > 1;

  • Identify the most recent import batches by run:

    SELECT DISTINCT RUN_ID FROM CZ.CZ_IMP_TMP_ITEMCAT ORDER BY RUN_ID DESC;

  • Purge staged rows for a completed or failed run:

    DELETE FROM CZ.CZ_IMP_TMP_ITEMCAT WHERE RUN_ID = :run_id; COMMIT;

Because the table is a staging surface, reporting against it is operational rather than analytical. It is most useful as a troubleshooting aid when import processes fail validation or leave residual rows.

Related Objects

The ETRM metadata designates CZ_IMP_TMP_ITEMCAT as a standalone object with no documented foreign keys; its PK constraint CZ_IMP_TMP_ITEMCAT_PK is the only modeled relationship. The following objects are the most significant dependencies and companions based on the Configurator import domain and the RUN_ID / ITEM_CATALOG_GROUP_ID semantics:

  • CZ_IMP_TMP_ITEM — Companion staging table for items, sharing RUN_ID as the import batch key.
  • CZ_IMP_TMP_ITEMCAT_PK — The unique index enforcing uniqueness of (RUN_ID, ITEM_CATALOG_GROUP_ID).
  • CZ_ITEM_CATALOG_GROUPS — Permanent storage of item catalog groups populated after staging validation.
  • CZ_ITEM_CATALOG_GROUP_MEMBERS — Membership links tying items to catalog groups once imported.
  • CZ_IMP_RUNS — Run-level control table tracking import execution status referenced via RUN_ID.
  • CZ_CONFIG_ITEMS — Configurator item definitions that consume catalog group assignments.
  • CZ_IMP_ITEMCAT_PKG — PL/SQL package that loads, validates, and clears staged rows in this table.

These objects collectively form the Configurator item catalog import pipeline. Direct joins to CZ_IMP_TMP_ITEMCAT should be limited to operational scripts, since the table's contents are transient and are cleared after each successful import run.