Search Results cz_des_chart_features




Overview
Explore in AI Chat

Overview

The CZ_DES_CHART_FEATURES table is a core data object within the Oracle Configurator (CZ) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as a junction or mapping table that defines the relationships between design charts, the rules that govern them, and the specific features they control. Its primary role is to manage the structural metadata for Design Charts, a visual modeling component used to represent complex configurable product models. By linking rules to features within the context of a specific model explanation, this table enables the Configurator runtime engine to apply the correct business logic and constraints to user selections during the configuration process.

Key Information Stored

The table's structure is defined by its composite primary key, which consists of three columns that together uniquely identify a controlling relationship within a design chart. The RULE_ID column stores a foreign key reference to a specific rule (CZ_RULES) that defines the constraint or logic to be applied. The FEATURE_ID column holds a foreign key reference to a configurable feature or item (CZ_PS_NODES) that is being controlled by the rule. The MODEL_REF_EXPL_ID column is a foreign key to a model explanation (CZ_MODEL_REF_EXPLS), which provides the specific context or instance of the configurable model where this rule-feature relationship is valid. This three-part key ensures precise control over how rules are applied to features in different modeling scenarios.

Common Use Cases and Queries

A primary use case involves troubleshooting or documenting the rule logic embedded within design charts for a given product model. Developers and implementers often query this table to understand which features are governed by specific rules. A common reporting query would join to the related descriptive tables to translate IDs into meaningful names. For example, to list all features controlled by a particular rule within a specific model explanation, one might use:

  • SELECT r.rule_name, n.node_name, m.name
  • FROM cz_des_chart_features dcf
  • JOIN cz_rules r ON dcf.rule_id = r.rule_id
  • JOIN cz_ps_nodes n ON dcf.feature_id = n.node_id
  • JOIN cz_model_ref_expls m ON dcf.model_ref_expl_id = m.model_ref_expl_id
  • WHERE dcf.model_ref_expl_id = :p_model_expl_id;

This data is critical for impact analysis when modifying a rule or feature, ensuring changes do not break existing configurations.

Related Objects

The CZ_DES_CHART_FEATURES table maintains strict referential integrity through documented foreign key relationships with three other core Configurator tables. These relationships are essential for understanding its data lineage and integration points.

  • CZ_RULES: Linked via CZ_DES_CHART_FEATURES.RULE_ID = CZ_RULES.RULE_ID. This defines the controlling business logic or constraint.
  • CZ_PS_NODES: Linked via CZ_DES_CHART_FEATURES.FEATURE_ID = CZ_PS_NODES.NODE_ID. This identifies the specific configurable product feature or component being controlled.
  • CZ_MODEL_REF_EXPLS: Linked via CZ_DES_CHART_FEATURES.MODEL_REF_EXPL_ID = CZ_MODEL_REF_EXPLS.MODEL_REF_EXPL_ID. This provides the contextual model instance for the relationship.