Search Results cz_rules




Overview
Explore in AI Chat

Overview

The CZ_RULES table is the central repository for all rule definitions within the Oracle Configurator (CZ) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It stores the logical constraints, dependencies, and business logic that govern the configuration of complex products. These rules define the relationships between components, features, and options, ensuring that user selections during a configuration session are valid, consistent, and manufacturable. The table's extensive foreign key relationships to other core Configurator entities, such as expressions, projects, and folders, underscore its foundational role in the configurator engine's operation.

Key Information Stored

The table's primary identifier is the RULE_ID. Its structure links a rule to its logical components and metadata. Key foreign key columns define a rule's structure and behavior: ANTECEDENT_ID and CONSEQUENT_ID link to the CZ_EXPRESSIONS table, storing the conditional "IF" and resultant "THEN" parts of the rule logic. The COMPONENT_ID associates the rule with a specific model component in CZ_PS_NODES. Administrative columns like DEVL_PROJECT_ID and RULE_FOLDER_ID organize rules within development projects and folder hierarchies. The table also stores references for user messaging (UNSATISFIED_MSG_ID, REASON_ID), effectivity dates (EFFECTIVITY_SET_ID), and specialized data for grid-based or combinatorial logic (GRID_ID, SUB_CONS_ID).

Common Use Cases and Queries

Primary use cases involve rule analysis, impact assessment, and troubleshooting during configuration model development and deployment. Common queries include listing all rules within a specific development project, analyzing rules associated with a particular component, or identifying rules that trigger specific messages. For example, to audit rules in a project, one might use:

  • SELECT rule_id, component_id FROM cz_rules WHERE devl_project_id = <project_id>;

To investigate the logic of a rule causing an error, a join to the expressions table is essential:

  • SELECT r.rule_id, ant.text antecedent, cons.text consequent FROM cz_rules r, cz_expressions ant, cz_expressions cons WHERE r.antecedent_id = ant.expression_id AND r.consequent_id = cons.expression_id AND r.rule_id = <rule_id>;

Related Objects

The CZ_RULES table has a highly interconnected schema. It is a parent table to several entities that extend rule functionality, including CZ_COMBO_FEATURES, CZ_DES_CHART_CELLS, and CZ_EXPRESSION_NODES. Its core logic is built upon the CZ_EXPRESSIONS table for rule conditions and results. It is a child table to master data objects such as CZ_DEVL_PROJECTS, CZ_PS_NODES (components), and CZ_RULE_FOLDERS. This network of relationships illustrates that CZ_RULES sits at the crossroads of configurator model structure, logic, and presentation.