Search Results cz_sub_con_sets




Overview
Explore in AI Chat

Overview

The CZ_SUB_CON_SETS table is a data object within the Oracle E-Business Suite Configurator (CZ) module. According to the official ETRM documentation, its stated purpose is "NEVER USED," indicating it is a legacy or placeholder table with no active data population in standard implementations of releases 12.1.1 and 12.2.2. Despite this status, its defined structure and enforced relational integrity through primary and foreign keys suggest it was designed to store metadata for sets of substitution constraints, which are rules governing component replacement within a configurable model. Its current role is primarily structural, maintaining referential integrity for historical or system-defined data links.

Key Information Stored

The table's structure, as defined by its primary key, centers on a single significant column: SUB_CONS_ID. This column serves as the unique identifier (primary key) for a substitution constraint set record. While other columns are not detailed in the provided metadata, the SUB_CONS_ID is the critical foreign key referenced by other core Configurator tables. The data held in this column, therefore, acts as a pointer or grouping mechanism, potentially associating various rules and model nodes with a specific substitution logic set, even if the master record in CZ_SUB_CON_SETS itself contains no additional descriptive data.

Common Use Cases and Queries

Given the documented "NEVER USED" status, direct operational or reporting use cases for querying this table are non-existent in standard processes. Its primary utility is for technical analysis and impact assessment during system upgrades, data migrations, or custom development. Sample queries would typically involve investigating relational integrity or identifying orphaned references. For instance, a developer might check for SUB_CONS_ID values in child tables that have no corresponding parent record:

  • Identifying foreign key references in CZ_PS_NODES or CZ_RULES without a master in CZ_SUB_CON_SETS.
  • Examining the distribution of SUB_CONS_ID values across the system via a join query, which would typically return minimal or no rows from CZ_SUB_CON_SETS itself.

Any operational reporting would bypass this table, sourcing substitution constraint information directly from the application's runtime engine or other metadata repositories.

Related Objects

The CZ_SUB_CON_SETS table maintains defined relationships with two critical Configurator tables, as per the foreign key metadata:

  • CZ_PS_NODES: This table stores information about nodes in the configuration model. Its SUB_CONS_ID column references CZ_SUB_CON_SETS, linking specific model nodes to a substitution constraint set.
  • CZ_RULES: This core table stores rule definitions for the configurator. Its SUB_CONS_ID column also references CZ_SUB_CON_SETS, associating rule logic with substitution sets.

These relationships indicate that while CZ_SUB_CON_SETS may not hold active data, the SUB_CONS_ID remains a structurally important key for the schema, referenced by objects that manage the configuration model and its business rules.