Search Results cz_system_properties_v




Overview
Explore in AI Chat

Overview

CZ_SYSTEM_PROPERTIES_V is a read-only view owned by the APPS schema in Oracle E-Business Suite, residing within the CZ (Configurator) product family. It exposes the system property definitions that the Oracle Configurator runtime and its supporting engine rely upon when generating configurable models, resolving system-level attributes, and managing model behavior. In EBS 12.1.1 and 12.2.2, the view serves as the principal reporting and integration surface for system properties — parameters that are attached to the configuration engine rather than to user-defined, model-specific nodes. Because these definitions are seeded or otherwise administrative in nature, the view is most often consumed by internal Configurator processes and by technical reporting that audits the standard property inventory.

The view is classified as VALID and is documented in ETRM for 12.2.2. It abstracts the complexities of the underlying rule and signature storage, presenting a single denormalized row per active system property.

Underlying Base Objects

The view is defined over two base objects, referenced through APPS synonyms: CZ_RULES and CZ_SIGNATURES.

  • CZ_RULES (aliased PROP): stores the rule or property records themselves, including the identifiers, descriptive text, flags, folder and project references, and sequencing attributes.
  • CZ_SIGNATURES (aliased SIG): stores the data type and signature-level metadata associated with each property, including the collection flag and the configuration engine type.

The join is performed on PROP.SIGNATURE_ID = SIG.SIGNATURE_ID. The filter clause restricts the result set to RULE_TYPE IN (500, 501) and DELETED_FLAG = '0', meaning the view returns only the system-property rule categories and suppresses soft-deleted rows. Any property without a matching signature, or whose rule type falls outside the 500/501 range, is excluded.

Key Columns

  • RULE_ID — primary identifier of the property within CZ_RULES.
  • NAME — the property name as referenced by the Configurator engine.
  • TEMPLATE_TOKEN — token used when rendering or substituting the property in templates.
  • SIGNATURE_ID — foreign key to CZ_SIGNATURES, linking the property to its datatype definition.
  • DESC_TEXT and NOTES — descriptive and supplementary text for the property.
  • CLASS_NAME — Java or implementation class associated with the property behavior.
  • MUTABLE_FLAG, DISABLED_FLAG, SEEDED_FLAG, DELETED_FLAG — status flags controlling whether the property can be changed, is active, is Oracle-seeded, or has been logically removed.
  • DATA_TYPE, COLLECTION_FLAG, CONFIG_ENGINE_TYPE — signature-derived attributes describing the value type, whether multiple values are permitted, and the engine context in which the property is valid.
  • RULE_TYPE, RULE_FOLDER_ID, DEVL_PROJECT_ID, SEQ_NBR — organizational and sequencing attributes.

Common Use Cases and Queries

Typical scenarios include auditing seeded system properties, checking signature datatypes before extending Configurator behavior, and troubleshooting models that fail due to a missing or disabled property.

  • List all active mutable properties: SELECT name, data_type, config_engine_type FROM cz_system_properties_v WHERE mutable_flag = 'Y' AND disabled_flag = 'N';
  • Identify Oracle-seeded properties by presence and type: SELECT name, desc_text FROM cz_system_properties_v WHERE seeded_flag = 'Y';
  • Inspect properties by folder for administration: SELECT rule_id, name, seq_nbr FROM cz_system_properties_v WHERE rule_folder_id = :folder ORDER BY seq_nbr;
  • Determine collection-valued properties: SELECT name FROM cz_system_properties_v WHERE collection_flag = 'Y';

Because the view already filters out deleted and non-system rule types, queries against it are simpler and safer than querying CZ_RULES directly.