Search Results cz_grid_cells




Overview
Explore in AI Chat

Overview

The CZ_GRID_CELLS table is a core data object within the Oracle Configurator (CZ) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as the repository for explicit compatibility rules defined within the Configurator Modeling environment. These rules, often visualized as a matrix or grid, allow modelers to specify precisely which combinations of configurable items (e.g., components, features, options) are allowed or prohibited during a configuration session. The table's primary role is to store the individual cell-level data that populates these compatibility matrices, enabling the runtime configurator engine to validate user selections against the defined business logic and constraints.

Key Information Stored

The table's structure is designed to map a specific cell within a compatibility grid to its corresponding rule data. The primary key, GRID_CELL_ID, uniquely identifies each cell record. Critical foreign key columns establish the necessary relationships to define the cell's context and content. The PS_NODE_ID links the cell to a specific model item (product structure node) in the CZ_PS_NODES table, representing the item being governed by the rule. The GRID_COL_ID references the CZ_GRID_COLS table, defining the column (or the other model item) in the compatibility relationship. The cell's content itself—typically a value indicating compatibility (e.g., "Include," "Exclude," "Default")—is stored within the table. The PREV_GRID_CELL_ID column supports versioning and historical tracking by creating a linked list to previous revisions of a cell's data.

Common Use Cases and Queries

The primary use case is the analysis and auditing of explicit compatibility rules. Administrators or modelers may query this table to generate reports on all defined constraints for a particular model or component. A common SQL pattern involves joining CZ_GRID_CELLS with CZ_PS_NODES (for item details) and CZ_GRID_COLS. For example, to list all compatibility cells for a specific model item, one might execute: SELECT gc.* FROM cz_grid_cells gc, cz_ps_nodes pn WHERE gc.ps_node_id = pn.ps_node_id AND pn.name = '<Item_Name>';. This data is also critical for troubleshooting configuration failures, as it allows technical support to verify the underlying rule that caused a selection to be invalidated. Data migration or upgrade scripts may also reference this table to transfer compatibility rules between environments.

Related Objects

The CZ_GRID_CELLS table is centrally connected to several other key Configurator schema objects, primarily through foreign key constraints as documented in the ETRM.

  • CZ_PS_NODES: Joined via CZ_GRID_CELLS.PS_NODE_ID = CZ_PS_NODES.PS_NODE_ID. This relationship identifies the model item for which the compatibility rule is defined.
  • CZ_GRID_COLS: Joined via CZ_GRID_CELLS.GRID_COL_ID = CZ_GRID_COLS.GRID_COL_ID. This relationship defines the column or the other item in the compatibility relationship within the grid.
  • CZ_GRID_CELLS (Self-Referential): Joined via CZ_GRID_CELLS.PREV_GRID_CELL_ID = CZ_GRID_CELLS.GRID_CELL_ID. This relationship manages the version history of individual cell records.