Results for “cz_des_chart_columns”

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

Overview

CZ_DES_CHART_COLUMNS is a Configurator (CZ) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the parameters governing the columns displayed on a Design Chart. Design Charts are used within Oracle Configurator to present the structure of a configurable model — its features, options, and their relationships — in a tabular, hierarchical layout. Each row in CZ_DES_CHART_COLUMNS controls how an individual column of that chart is rendered and which model element it represents, effectively decoupling chart presentation metadata from the underlying configuration model definition.

From a Data Vault modeling perspective, the FK structure suggests CZ_DES_CHART_COLUMNS behaves as a link table. Its composite primary key pairs a rule with an option node, and it carries additional foreign keys to feature and model-reference-explanation entities. This pattern is characteristic of an associative entity that resolves many-to-many relationships among rules, configuration nodes, and explanation records rather than acting as a standalone hub or pure descriptive satellite.

Key Information Stored

The documented physical schema contains nine columns. The most significant are:

• RULE_ID — Part of the composite primary key; identifies the configurator rule the chart column is associated with. Foreign key to CZ_RULES.
• OPTION_ID — The second component of the composite primary key; references the option node from CZ_PS_NODES whose chart placement is being defined.
• FEATURE_ID — References a feature node in CZ_PS_NODES, indicating the feature to which the chart column belongs.
• MODEL_REF_EXPL_ID — Foreign key to CZ_MODEL_REF_EXPLS, linking the column to the model reference explanation that drives its content.
• COLUMN_WIDTH — Presentation attribute controlling the rendered width of the column in the Design Chart UI.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard EBS audit columns that record who created and last modified each row and when.

The surrogate/business key is CZ_DES_CHART_COLUMNS_PK, defined on the (RULE_ID, OPTION_ID) pair via unique index. No separate single-column surrogate identifier is documented; the composite business key serves as the unique row identifier.

Common Use Cases and Queries

Typical scenarios include auditing which options appear as columns on a design chart, verifying column widths during UI customization, and tracing explanation records back to their associated rules and options. A representative query joining the primary chart metadata to its parents:

• SELECT c.RULE_ID, c.OPTION_ID, c.FEATURE_ID, c.COLUMN_WIDTH FROM CZ_DES_CHART_COLUMNS c WHERE c.RULE_ID = :rule_id;
• Join to CZ_RULES to retrieve rule descriptions for the chart columns: SELECT c.OPTION_ID, r.RULE_NAME FROM CZ_DES_CHART_COLUMNS c, CZ_RULES r WHERE c.RULE_ID = r.RULE_ID;
• Join to CZ_PS_NODES on both OPTION_ID and FEATURE_ID to resolve node labels for reporting, and to CZ_MODEL_REF_EXPLS on MODEL_REF_EXPL_ID to surface explanation text.

Reporting use cases center on documenting the effective layout of a model's design chart, comparing column configurations across rules, and supporting migration or cloning of configurator models where chart presentation must be preserved.

Related Objects

The following objects are directly related through documented foreign keys and should be considered when querying or maintaining this table:

• CZ_RULES — joined via RULE_ID; the parent rule definition.
• CZ_PS_NODES — joined twice, via OPTION_ID and FEATURE_ID; supplies option and feature node definitions.
• CZ_MODEL_REF_EXPLS — joined via MODEL_REF_EXPL_ID; supplies model reference explanation content.
• CZ_DES_CHART_COLUMNS_PK — the unique index enforcing the composite key.

Together these objects form the metadata layer that Oracle Configurator uses to render Design Charts and to maintain consistency between rule definitions, node structures, and explanatory text.