Results for “sub_cons_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CZ_SUB_CON_SETS is a table owned by the CZ schema within the Oracle Configurator module (CZ) of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2 releases. The table is documented as VALID in the ETRM repository, although its published description states "NEVER USED," which indicates that the object is a legacy or reserved container that is not actively populated by standard Configurator runtime logic in current releases. Despite this designation, the physical object exists with 14 documented columns, a primary key constraint (CZ_SUB_CON_SETS_PK), and inbound foreign key relationships from four other CZ tables, so it retains structural significance in the Configurator data model.

From a Data Vault modeling perspective, the FK topology suggests a hub-leaning classification. The table is referenced by multiple dependent tables through the SUB_CONS_ID column but does not itself carry outbound foreign keys to other parent objects, which is characteristic of a hub entity that anchors a business concept — in this case, a substitution constraint set. The presence of effectivity and security mask columns is consistent with a reference or configuration definition entity rather than a transactional satellite.

Key Information Stored

The table's columns fall into three functional groups: identity, descriptive attributes, and audit/control fields.

• SUB_CONS_ID — the surrogate primary key defined by CZ_SUB_CON_SETS_PK. It is the single unique-index business-key candidate documented and is the column through which all child tables join back to this parent.
• NAME — the user-facing identifier for the substitution constraint set.
• DESC_TEXT — a descriptive free-text field that explains the purpose or content of the set.
• DELETED_FLAG — a soft-delete indicator allowing logical removal without physical row deletion.
• EFF_FROM and EFF_TO — date-based effectivity range columns that determine when the set is valid for use in configuration.
• EFF_MASK and SECURITY_MASK — bit-mask control fields typically used by Configurator to govern effectivity granularity and record-level security visibility.
• CHECKOUT_USER — identifies the user who has the record checked out, supporting concurrent-development locking.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard Oracle EBS WHO-column audit trail capturing creation and modification metadata.

Common Use Cases and Queries

Because the table is marked as never used, direct reporting against it is uncommon; however, developers and support analysts investigating legacy Configurator metadata or data-migration anomalies may query it to confirm whether the object holds any rows.

• Confirming population: SELECT COUNT(*) FROM CZ.CZ_SUB_CON_SETS;
• Listing active, non-deleted definitions: SELECT SUB_CONS_ID, NAME, EFF_FROM, EFF_TO FROM CZ.CZ_SUB_CON_SETS WHERE DELETED_FLAG = 'N';
• Identifying orphaned child references by joining to dependent tables on SUB_CONS_ID.
• Auditing recent changes via LAST_UPDATE_DATE and LAST_UPDATED_BY for troubleshooting custom Configurator extensions.

Related Objects

Four documented tables carry a SUB_CONS_ID foreign key referencing CZ_SUB_CON_SETS, indicating the objects that depend on this parent hub.

• CZ_PS_NODES — joins on CZ_PS_NODES.SUB_CONS_ID to CZ_SUB_CON_SETS.SUB_CONS_ID; associates model nodes with substitution constraint sets.
• CZ_RULES — joins on CZ_RULES.SUB_CONS_ID; links configuration rules to a constraint set.
• CZ_IMP_RULES — joins on CZ_IMP_RULES.SUB_CONS_ID; the import-side counterpart of CZ_RULES.
• CZ_IMP_PS_NODES — joins on CZ_IMP_PS_NODES.SUB_CONS_ID; the import-side counterpart of CZ_PS_NODES.

These relationships should be considered when assessing deletion, archival, or migration operations, since child rows depend on the integrity of the SUB_CONS_ID primary key.