Search Results template_primitive_flag




Overview
Explore in AI Chat

Overview

CZ_RULES is the central rules repository for the Oracle Configurator (CZ) module in Oracle E-Business Suite 12.1.1 and 12.2.2. Every configurator rule — whether a compatibility constraint, a defaulting rule, an exclusion, an inclusion, or a computed value — is persisted as a row in this table. The table captures the rule's logical definition, its expression-based antecedent and consequent, its folder placement, effectivity, and its relationships to model nodes, grid definitions, and message text. Because Configurator depends on deterministic evaluation of rules during a configuration session, CZ_RULES is one of the most heavily read objects in the CZ schema at runtime.

From a Data Vault modeling perspective, the mined heuristic classifies CZ_RULES as a hub. The surrogate primary key RULE_ID uniquely identifies each rule, and the numerous outbound foreign keys (to expressions, nodes, folders, effectivity sets) are consistent with a hub surrounded by links and satellites. This classification is a modeling suggestion only; the physical implementation is a standard normalized transactional table.

Key Information Stored

The table contains 59 documented columns. The most significant are:

The business-key candidate is the composite (RULE_FOLDER_ID, DELETED_FLAG, RULE_ID, ZD_EDITION_NAME) in CZ_RULES_U1; RULE_ID alone is the canonical surrogate.

Common Use Cases and Queries

Typical uses include extracting all rules belonging to a model, auditing disabled or deleted rules, and tracing the two expression halves of each rule.

  • List active rules for a folder: SELECT r.rule_id, r.name, r.rule_type FROM cz_rules r WHERE r.rule_folder_id = :folder AND r.deleted_flag = 'N'.
  • Join rules to their expressions: SELECT r.name, a.expr_text, c.expr_text FROM cz_rules r, cz_expressions a, cz_expressions c WHERE r.antecedent_id = a.expression_id AND r.consequent_id = c.expression_id.
  • Find rules bound to a model node: SELECT rule_id, name FROM cz_rules WHERE component_id = :node.
  • Reporting disabled or unsatisfiable rules: filter on DISABLED_FLAG = 'Y' or join to CZ_INTL_TEXTS via UNSATISFIED_MSG_ID to display the message shown to users.

Related Objects

  • CZ_EXPRESSIONS — referenced three times via ANTECEDENT_ID, CONSEQUENT_ID, AMOUNT_ID.
  • CZ_PS_NODES — node/component owning the rule (COMPONENT_ID).
  • CZ_RULE_FOLDERS — folder hierarchy (RULE_FOLDER_ID).
  • CZ_EFFECTIVITY_SETS — effectivity scope (EFFECTIVITY_SET_ID).
  • CZ_SUB_CON_SETS — sub-configuration scope (SUB_CONS_ID).
  • CZ_GRID_DEFS — grid definitions (GRID_ID).
  • CZ_INTL_TEXTS — messages and reasons (UNSATISFIED_MSG_ID, REASON_ID).
  • CZ_COMBO_FEATURES, CZ_DES_CHART_CELLS, CZ_DES_CHART_COLUMNS, CZ_DES_CHART_FEATURES, CZ_EXPRESSION_NODES, CZ_FILTER_SETS — all reference CZ_RULES.RULE_ID and depend on this table.