Search Results secondary_opt_id

Overview

The CZ_DES_CHART_CELLS table is a core data structure within the Oracle Configurator (CZ) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the repository for the contents of design chart cells, which are fundamental components of the Configurator's constraint-based modeling engine. This table physically stores the relationships and rules defined within a configurator model's design charts, enabling the runtime engine to validate user selections and enforce compatibility rules between configurable options. Its role is critical for ensuring that only valid product configurations can be created, directly supporting complex product configuration processes.

Key Information Stored

The table's primary function is to link rules to specific combinations of configurable items. Its structure is defined by a composite primary key and several foreign key relationships. The most significant columns include RULE_ID, which links the cell to a specific constraint rule defined in the CZ_RULES table. The PRIMARY_OPT_ID and SECONDARY_OPT_ID columns are foreign keys to the CZ_PS_NODES table, storing references to the primary and secondary option nodes involved in the rule relationship. The SECONDARY_FEAT_EXPL_ID links to the CZ_MODEL_REF_EXPLS table, providing a reference to an explanation or a specific instance of a feature. An additional foreign key, SECONDARY_FEATURE_ID, also references CZ_PS_NODES, pointing to the secondary feature itself. The combination of these keys precisely defines the allowable or prohibited interactions between model elements within a design chart matrix.

Common Use Cases and Queries

This table is primarily accessed during configuration validation and model administration. A common use case is troubleshooting or analyzing the constraint rules defined for a specific primary option. For instance, to find all design chart rules where a particular option acts as the primary component, one would query using the PRIMARY_OPT_ID. The search term "primary_opt_id" from the user's request highlights this exact scenario.

Sample Query:
SELECT cell.rule_id, rule.rule_type, sec_opt.node_name AS secondary_option
FROM cz_des_chart_cells cell
JOIN cz_rules rule ON cell.rule_id = rule.rule_id
JOIN cz_ps_nodes sec_opt ON cell.secondary_opt_id = sec_opt.node_id
WHERE cell.primary_opt_id = :p_primary_option_node_id;

This query retrieves all constraint rules and the associated secondary options for a given primary option, which is essential for model debugging, impact analysis, and documentation.

Related Objects

• CZ_RULES: The central rules table. CZ_DES_CHART_CELLS.RULE_ID is a foreign key to CZ_RULES.RULE_ID, linking each cell to its governing constraint logic.
• CZ_PS_NODES: The master table for all configurable model items (features, options, etc.). CZ_DES_CHART_CELLS references it four times (PRIMARY_OPT_ID, SECONDARY_OPT_ID, SECONDARY_FEATURE_ID, and implicitly for the primary feature).
• CZ_MODEL_REF_EXPLS: Provides explanatory references for model elements. Linked via the SECONDARY_FEAT_EXPL_ID column.
• CZ_DES_CHART_CELLS_PK: The primary key constraint on the table, typically defined on (RULE_ID, PRIMARY_OPT_ID, SECONDARY_OPT_ID, SECONDARY_FEAT_EXPL_ID).