Search Results cz_grid_defs




Overview
Explore in AI Chat

Overview

The CZ_GRID_DEFS table is a core data object within the Oracle E-Business Suite Configurator (CZ) module. It serves as the master definition table for explicit compatibility rules, which are a fundamental construct for modeling complex product configurations. These rules, often visualized as a matrix or grid, define permissible and impermissible combinations of component options or features. The table stores the essential metadata and parameters that govern the structure and behavior of each compatibility rule grid, acting as a parent record for detailed rule data. Its existence is critical for enabling guided selling, enforcing product constraints, and ensuring valid configurations during the order capture process in applications like Oracle Order Management.

Key Information Stored

The table's primary purpose is to define the rule's identity, scope, and basic properties. The most critical column is GRID_ID, which is the table's primary key and serves as the unique identifier for every explicit compatibility rule in the system. This identifier is extensively referenced by related child tables. Another essential column is DEVL_PROJECT_ID, a foreign key to CZ_DEVL_PROJECTS, which ties each rule definition to a specific Configurator development project, enforcing modular development and security. While the provided metadata does not list all columns, typical columns in such a definition table would include data for the rule's name, description, effective dates (START_DATE, END_DATE), and flags controlling its status and application (e.g., ACTIVE_FLAG).

Common Use Cases and Queries

Primary use cases involve rule administration, impact analysis, and troubleshooting configuration issues. A common query retrieves all active rule definitions for a specific project to review or audit configuration logic. For example:

  • SELECT grid_id, name FROM cz_grid_defs WHERE devl_project_id = :p_project_id AND sysdate BETWEEN start_date AND NVL(end_date, sysdate);

When diagnosing an invalid configuration, one might join CZ_GRID_DEFS to the CZ_RULES table to find the specific rule preventing a combination. Reporting often involves aggregating the number of rules per project or analyzing rule usage. The GRID_ID is the essential link in all such queries, used to join to detailed rule lines in CZ_GRID_COLS (defining the grid's axes) and CZ_RULES (defining the allowed/disallowed intersections).

Related Objects

The CZ_GRID_DEFS table sits at the center of a key relationship hierarchy. As indicated by the foreign keys, it has a direct parent-child relationship with three main objects:

  • CZ_DEVL_PROJECTS: The parent table, providing the development context for the rule.
  • CZ_GRID_COLS: A child table that defines the columns (and typically rows) of the compatibility matrix, linked via GRID_ID.
  • CZ_RULES: A critical child table that stores the actual permissible or impermissible entries within the grid's cells, also linked via GRID_ID.

Therefore, CZ_GRID_DEFS.GRID_ID is propagated to CZ_GRID_COLS.GRID_ID and CZ_RULES.GRID_ID, creating the structural backbone for the explicit compatibility rule.