Search Results cz_des_chart_columns




Overview
Explore in AI Chat

Overview

The CZ_DES_CHART_COLUMNS table is a core data object within the Oracle E-Business Suite (EBS) Configurator (CZ) module, specifically for versions 12.1.1 and 12.2.2. It functions as a repository for defining the parameters and structure of columns within Design Charts. In the context of the Configurator, a Design Chart is a user interface component used to visualize and manage complex configuration rules, dependencies, and valid combinations of product options and features. This table stores the metadata that dictates how these charts are organized, specifying which model elements (rules, options, features) are displayed as columns and their associated properties. Its role is integral to the runtime presentation and functional behavior of the configurator's design-time tools.

Key Information Stored

The table's primary purpose is to map chart columns to specific configurator model entities. While the full column list is not detailed in the provided metadata, the foreign key relationships explicitly identify the critical columns. The primary key is a composite of RULE_ID and OPTION_ID, indicating that a chart column definition is uniquely tied to a specific rule and option pairing. Other essential foreign key columns include FEATURE_ID, linking a column to a product feature, and MODEL_REF_EXPL_ID, which associates the column with a model reference explosion—a mechanism for reusing model components. Collectively, these columns define the content source for each column in a Design Chart.

Common Use Cases and Queries

Primary use cases involve administrative reporting on configurator model structure and troubleshooting Design Chart definitions. A common query would retrieve all column definitions for a specific rule to understand its chart presentation. For example:

  • SELECT * FROM cz_des_chart_columns WHERE rule_id = <RULE_ID>;

Another typical scenario is analyzing which model elements are used across multiple charts, which can be achieved by joining with the CZ_PS_NODES table on OPTION_ID or FEATURE_ID. Developers or implementers might query this table to audit or document the UI layout of complex configuration models before deployment or during an upgrade.

Related Objects

The table maintains strict referential integrity with several foundational Configurator tables, as documented by its foreign keys:

  • CZ_RULES: Joined via CZ_DES_CHART_COLUMNS.RULE_ID. This is the master table for all configuration rules.
  • CZ_PS_NODES: Joined via CZ_DES_CHART_COLUMNS.OPTION_ID. This table stores all product model items, including options.
  • CZ_PS_NODES: Also joined via CZ_DES_CHART_COLUMNS.FEATURE_ID, linking to feature definitions within the product model.
  • CZ_MODEL_REF_EXPLS: Joined via CZ_DES_CHART_COLUMNS.MODEL_REF_EXPL_ID. This table manages reusable model component references.

These relationships position CZ_DES_CHART_COLUMNS as a central hub connecting UI presentation (the chart) with the underlying configuration model logic and data.