Search Results invalid_flag




Overview
Explore in AI Chat

Overview

CZ_MODEL_ALL_RULEFOLDERS_V is an APPS-owned database view in the Oracle E-Business Suite Configurator (CZ) module. It consolidates the rule folder hierarchy that belongs to a configuration model by flattening two distinct sources — standard rule folders and typed rules — into a single, uniform structure. The view joins rule folder records to model project information, producing a denormalized result set that reports each rule folder in the context of its owning model, together with the depth of the folder within the model tree. Because Configurator rules, rule folders, and typed rules drive the runtime validation and guidance behavior of configured items, this view serves as a key read-only reporting and integration surface for anyone who must inspect model rule structure without navigating the underlying normalized tables.

The view is documented as VALID in the ETRM 12.2.2 metadata and is referenced in Oracle EBS 12.1.1 and 12.2.2 environments. It is intended for query access only; it exposes no DML capability and should not be treated as a maintenance path for rule folder definitions.

Underlying Base Objects

The ETRM metadata documents four referenced objects beneath this view:

  • CZ_RULE_FOLDERS (accessed through a synonym) — the primary source of rule folder rows, supplying name, description, parent folder, tree sequence, effectivity, and folder type attributes.
  • CZ_TYPED_RULES_V (view) — supplies the typed rule branch of the UNION ALL, exposing each typed rule as a rule folder row with its rule identifier, name, description, and parent folder.
  • CZ_RULETYPECODES_LKV (view) — a lookup view joined to the rule folder rows to resolve the numeric rule type code into a label and description.
  • CZ_MODEL_REF_EXPLS (synonym) — used to resolve the model project and node depth so each folder can be attributed to its model context.

The view text is a UNION ALL of two SELECT statements. The first selects from CZ_RULE_FOLDERS restricted to OBJECT_TYPE values of 'RFL', 'RSQ', and 'FNC' with DELETED_FLAG = '0', joined to CZ_RULETYPECODES_LKV. The second selects rule rows from CZ_TYPED_RULES_V. A DECODE on DEVL_PROJECT_ID against the model ID derives the REFERENCED_RULE_FOLDER_FLAG, distinguishing folders owned by the model from those referenced from another development project.

Key Columns

Common Use Cases and Queries

Typical uses include auditing the rule structure of a released model, extracting the rule hierarchy for documentation, and validating that no active rule folder is marked deleted, disabled, or invalid before a configuration goes live. Because the user search term was invalid_flag, the most frequent diagnostic query filters on that column:

  • Detect invalid rule definitions: SELECT model_id, rule_folder_id, name, invalid_flag, deleted_flag, disabled_flag FROM cz_model_all_rulefolders_v WHERE invalid_flag = '1';
  • List active rules for a model: SELECT rule_folder_id, name, rule_type_label, node_depth FROM cz_model_all_rulefolders_v WHERE model_id = :model_id AND deleted_flag = '0' AND disabled_flag = '0' AND invalid_flag = '0' ORDER BY node_depth, tree_seq;
  • Identify referenced (externally owned) folders: SELECT rule_folder_id, name, devl_project_id FROM cz_model_all_rulefolders_v WHERE referenced_rule_folder_flag = '1';

Queries should always qualify the model and status flags to avoid returning obsolete or invalid rows, since the view intentionally exposes deleted and invalid definitions for audit purposes.