Search Results cz_rule_folders




Overview
Explore in AI Chat

Overview

The CZ_RULE_FOLDERS table is a core data structure within the Oracle E-Business Suite Configurator (CZ) module, specifically for versions 12.1.1 and 12.2.2. It implements the hierarchical organization and sequencing mechanism for business rules in the Configurator knowledge base. This table is fundamental to managing the logical grouping and execution order of rules, which define product configuration logic, constraints, defaults, and user interface behaviors. By providing a folder-based hierarchy, it enables administrators and developers to structure complex rule sets for maintainability and controlled processing.

Key Information Stored

The table's primary purpose is to define rule folder entities. Its key columns, as indicated by its primary and foreign keys, include RULE_FOLDER_ID, which uniquely identifies each folder. The DEVL_PROJECT_ID column links the folder to a specific Configurator development project, anchoring it within the correct modeling workspace. The PARENT_RULE_FOLDER_ID column establishes the self-referential hierarchical relationship, allowing for nested folder structures. The EFFECTIVITY_SET_ID links to date-effective or context-dependent rule sets (CZ_EFFECTIVITY_SETS), enabling rules to be activated based on time or other conditions. The OBJECT_TYPE column, part of the primary key, likely distinguishes between different object types that can exist within the folder hierarchy, such as rule sequences or other container types.

Common Use Cases and Queries

Primary use cases involve querying the rule hierarchy for impact analysis, auditing, or generating documentation. A common query retrieves the complete folder tree for a specific development project to understand rule organization. For example:

  • SELECT RULE_FOLDER_ID, NAME, PARENT_RULE_FOLDER_ID FROM CZ_RULE_FOLDERS WHERE DEVL_PROJECT_ID = :p_project_id START WITH PARENT_RULE_FOLDER_ID IS NULL CONNECT BY PRIOR RULE_FOLDER_ID = PARENT_RULE_FOLDER_ID;

Another critical use case is analyzing rule sequencing within a folder, which may involve joining with the CZ_RULES table on RULE_FOLDER_ID and ordering by a sequence column (implied by the table's description). Reporting on all rules governed by a specific effectivity set is also a frequent requirement, achieved by joining CZ_RULE_FOLDERS with CZ_RULES and CZ_EFFECTIVITY_SETS.

Related Objects

The CZ_RULE_FOLDERS table sits at the center of several key relationships. It has a mandatory foreign key dependency on CZ_DEVL_PROJECTS, linking folders to projects. It maintains a recursive relationship with itself via PARENT_RULE_FOLDER_ID. Crucially, it is referenced as a parent table by CZ_RULES, which stores the individual rule definitions contained within these folders, and by CZ_FUNC_COMP_SPECS, which may use folders to organize functional component specifications. The relationship with CZ_EFFECTIVITY_SETS allows rule folders and their contents to be conditionally effective. Direct manipulation of this table is typically performed through the Configurator's administrative and modeling interfaces rather than via direct SQL.