Search Results cz_grid_cols




Overview
Explore in AI Chat

Overview

The CZ_GRID_COLS table is a core data structure within the Oracle E-Business Suite Configurator (CZ) module. It defines the metadata for a column within an explicit compatibility grid. These grids are used to model complex product configuration rules, specifically compatibility relationships between different features and options. The table stores the structural definition of each column, including its sequence, relationship to other columns, and linkage to the overall grid definition. Its primary role is to serve as a master reference for grid column definitions, enabling the Configurator engine to correctly interpret and enforce compatibility rules during a configuration session.

Key Information Stored

While the full column list is not detailed in the provided metadata, the primary and foreign key relationships reveal the critical data elements. The table's primary key is GRID_COL_ID, which uniquely identifies each column definition. A foreign key, GRID_ID, links the column to its parent grid definition in the CZ_GRID_DEFS table. The column PREV_GRID_COL_ID establishes a self-referential relationship, likely used to maintain the display or logical order of columns within the grid. Other essential columns, inferred from the table's purpose, would include attributes such as the column name, label, data type, and potentially a reference to the model component (like a feature) that the column represents.

Common Use Cases and Queries

This table is primarily accessed for administrative, diagnostic, and data migration purposes within the Configurator module. Common scenarios include analyzing the structure of a specific compatibility grid for troubleshooting configuration logic, or extracting metadata for custom reports. A typical query would join CZ_GRID_COLS to CZ_GRID_DEFS to list all columns for a given grid. For example:

  • SELECT gc.grid_col_id, gc.column_name, gd.grid_name FROM cz.cz_grid_cols gc, cz.cz_grid_defs gd WHERE gc.grid_id = gd.grid_id AND gd.grid_name = '<GRID_NAME>' ORDER BY gc.prev_grid_col_id;

Another use case involves identifying all compatibility rules (cells) dependent on a specific grid column, which would involve joining to CZ_GRID_CELLS. Direct operational manipulation of this table by custom code is rare, as configuration definitions are typically managed through the dedicated Configurator Developer user interface or published APIs.

Related Objects

The CZ_GRID_COLS table is central to the compatibility grid subsystem. As indicated by the foreign keys, it has several key dependencies. CZ_GRID_DEFS is the parent table, defining the overall grid. CZ_GRID_CELLS stores the actual compatibility rule values for each intersection of a grid row and a column defined in this table. CZ_COMBO_FEATURES and CZ_EXPRESSION_NODES reference grid columns, linking them to specific configurable features and expression logic within the model. The self-referencing foreign key on PREV_GRID_COL_ID indicates a linked-list structure for column ordering within the same grid.

  • Table: CZ_GRID_COLS 12.1.1

    owner:CZ,  object_type:TABLE,  fnd_design_data:CZ.CZ_GRID_COLS,  object_name:CZ_GRID_COLS,  status:VALID,  product: CZ - Configurator ,  description: Specifies a column in an explicit compatibility ,  implementation_dba_data: CZ.CZ_GRID_COLS , 

  • Table: CZ_GRID_COLS 12.2.2

    owner:CZ,  object_type:TABLE,  fnd_design_data:CZ.CZ_GRID_COLS,  object_name:CZ_GRID_COLS,  status:VALID,  product: CZ - Configurator ,  description: Specifies a column in an explicit compatibility ,  implementation_dba_data: CZ.CZ_GRID_COLS , 

  • Table: CZ_GRID_DEFS 12.1.1

    owner:CZ,  object_type:TABLE,  fnd_design_data:CZ.CZ_GRID_DEFS,  object_name:CZ_GRID_DEFS,  status:VALID,  product: CZ - Configurator ,  description: Defines the parameters of an explicit compatibility rule. ,  implementation_dba_data: CZ.CZ_GRID_DEFS , 

  • Table: CZ_GRID_DEFS 12.2.2

    owner:CZ,  object_type:TABLE,  fnd_design_data:CZ.CZ_GRID_DEFS,  object_name:CZ_GRID_DEFS,  status:VALID,  product: CZ - Configurator ,  description: Defines the parameters of an explicit compatibility rule. ,  implementation_dba_data: CZ.CZ_GRID_DEFS , 

  • Table: CZ_GRID_CELLS 12.2.2

    owner:CZ,  object_type:TABLE,  fnd_design_data:CZ.CZ_GRID_CELLS,  object_name:CZ_GRID_CELLS,  status:VALID,  product: CZ - Configurator ,  description: Contents of explicit compatibility cells ,  implementation_dba_data: CZ.CZ_GRID_CELLS , 

  • Table: CZ_COMBO_FEATURES 12.2.2

    owner:CZ,  object_type:TABLE,  fnd_design_data:CZ.CZ_COMBO_FEATURES,  object_name:CZ_COMBO_FEATURES,  status:VALID,  product: CZ - Configurator ,  description: Explicit compatibility OC/features table ,  implementation_dba_data: CZ.CZ_COMBO_FEATURES , 

  • Table: CZ_GRID_CELLS 12.1.1

    owner:CZ,  object_type:TABLE,  fnd_design_data:CZ.CZ_GRID_CELLS,  object_name:CZ_GRID_CELLS,  status:VALID,  product: CZ - Configurator ,  description: Contents of explicit compatibility cells ,  implementation_dba_data: CZ.CZ_GRID_CELLS , 

  • Table: CZ_COMBO_FEATURES 12.1.1

    owner:CZ,  object_type:TABLE,  fnd_design_data:CZ.CZ_COMBO_FEATURES,  object_name:CZ_COMBO_FEATURES,  status:VALID,  product: CZ - Configurator ,  description: Explicit compatibility OC/features table ,  implementation_dba_data: CZ.CZ_COMBO_FEATURES , 

  • Table: CZ_EXPRESSION_NODES 12.2.2

    owner:CZ,  object_type:TABLE,  fnd_design_data:CZ.CZ_EXPRESSION_NODES,  object_name:CZ_EXPRESSION_NODES,  status:VALID,  product: CZ - Configurator ,  description: Expression contents in a tree or sequential "un-parsed" node order ,  implementation_dba_data: CZ.CZ_EXPRESSION_NODES , 

  • Table: CZ_EXPRESSION_NODES 12.1.1

    owner:CZ,  object_type:TABLE,  fnd_design_data:CZ.CZ_EXPRESSION_NODES,  object_name:CZ_EXPRESSION_NODES,  status:VALID,  product: CZ - Configurator ,  description: Expression contents in a tree or sequential "un-parsed" node order ,  implementation_dba_data: CZ.CZ_EXPRESSION_NODES ,