Results for “cz_des_chart_cells”

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

Overview

CZ_DES_CHART_CELLS is a table within the CZ — Configurator module of Oracle E-Business Suite (validated in 12.1.1 and 12.2.2). It stores the contents of design chart cells, forming the intersection grid that governs how configurable options relate to one another within a model rule. Each row represents a single cell in a design chart, capturing the outcome defined when a primary option and a secondary option are evaluated together under a given rule. This makes the table central to the Configurator's rule-evaluation engine, where compatibility, inclusion, exclusion, and default behaviors are resolved at runtime.

From a heuristic Data Vault modeling perspective, the mined foreign-key structure classifies this object as a link table. It sits at the intersection of several hubs — rules, primary options, and secondary options — and describes the relationships among them rather than storing descriptive attributes about any single entity. This classification is a modeling suggestion derived from the FK topology, not an Oracle-imposed designation.

Key Information Stored

The table comprises 17 documented columns. The most significant are:

• RULE_ID — Identifies the configurator rule under which the cell is evaluated; part of the primary key and a foreign key to CZ_RULES.
• PRIMARY_OPT_ID — The primary option in the chart cell intersection; part of the primary key and a FK to CZ_PS_NODES.
• SECONDARY_OPT_ID — The secondary option in the intersection; part of the primary key and a FK to CZ_PS_NODES.
• SECONDARY_FEAT_EXPL_ID — Links to the model reference explanation (CZ_MODEL_REF_EXPLS); part of the primary key.
• SECONDARY_FEATURE_ID — The secondary feature node associated with the cell; FK to CZ_PS_NODES.
• MARK_CHAR — The mark or symbol placed in the chart cell, indicating the rule outcome for the option pair.
• DELETED_FLAG — Soft-delete indicator for logically removed rows.
• EFF_FROM / EFF_TO / EFF_MASK — Effective-dating controls governing when the cell definition is active.
• SECURITY_MASK — Security masking applied to the cell record.
• CHECKOUT_USER — Identifies the user who has checked out the record for modification.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns capturing who created and last modified the row.

The composite primary key CZ_DES_CHART_CELLS_PK (RULE_ID, PRIMARY_OPT_ID, SECONDARY_OPT_ID, SECONDARY_FEAT_EXPL_ID) is the surrogate identifier. Business-key uniqueness is effectively enforced through this composite, since no distinct rule/option-pair combination may repeat within the same explanation context.

Common Use Cases and Queries

Design chart cells are queried most often during rule diagnostics, configuration troubleshooting, and migration validation. A typical pattern resolves all cells for a given rule:

SELECT c.RULE_ID, c.PRIMARY_OPT_ID, c.SECONDARY_OPT_ID,
       c.MARK_CHAR, c.SECONDARY_FEATURE_ID
FROM   CZ_DES_CHART_CELLS c
WHERE  c.RULE_ID = :rule_id
AND    NVL(c.DELETED_FLAG,'N') = 'N';

Reporting scenarios frequently join to CZ_PS_NODES to translate option IDs into readable node names for both the primary and secondary sides. Effective-dating filters using EFF_FROM, EFF_TO, and EFF_MASK support point-in-time reproductions of a chart configuration. Audit queries leverage the standard who-columns to identify recently modified cells, while CHECKOUT_USER filters isolate rows currently locked for editing.

Related Objects

The table is tightly coupled to several Configurator objects through documented foreign keys:

• CZ_RULES — joined via CZ_DES_CHART_CELLS.RULE_ID = CZ_RULES.RULE_ID.
• CZ_PS_NODES — referenced three times: PRIMARY_OPT_ID, SECONDARY_OPT_ID, and SECONDARY_FEATURE_ID all resolve to node definitions in this table.
• CZ_MODEL_REF_EXPLS — joined via SECONDARY_FEAT_EXPL_ID, supplying the model reference explanation that contextualizes the cell.

Together these relationships position CZ_DES_CHART_CELLS as the operational link binding rules, option nodes, and model reference explanations into the design chart consumed by the Configurator runtime.