Search Results cz_global_properties_v




Overview
Explore in AI Chat

Overview

CZ_GLOBAL_PROPERTIES_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, belonging to the CZ (Configurator) product family. It is published as a VALID database object in both EBS 12.1.1 and 12.2.2. The view exposes the set of system-level "global" properties that the Oracle Configurator engine recognizes when no model-specific context is in force — that is, the properties applicable to model ID 0, the Configurator's conventional identifier for the global or system-wide modeling scope.

In Configurator terminology, a property is an attribute that can be attached to nodes, option classes, or other configuration objects, and can participate in rules, constraints, and UI behaviors. Global properties are those defined at the system level rather than within a single configuration model, and they therefore apply across models. CZ_GLOBAL_PROPERTIES_V presents these properties together with their metadata (data type, mutability, whether they are collections) and the node type to which each is attached. Because it is a view rather than a table, it provides no storage of its own; it is a read-only projection intended for queries, reports, custom validation scripts, diagnostics, and integration extracts.

Underlying Base Objects

The view text joins two CZ views and filters against a third, all resolved at runtime under the APPS schema:

Because the view is defined entirely over other views, its contents are derived at query time from the underlying Configurator repository tables. Any change to the definition or availability of these base views directly affects the results returned here.

Key Columns

  • PROPERTY_ID — the property's rule ID (aliased from SYSPROP.RULE_ID); the unique identifier for the global property.
  • PROPERTY_NAME — the property name as defined in the Configurator repository.
  • PROPERTY_TOKEN — a generated token formed as NAME appended with "()"; used where the Configurator UI or runtime expects a tokenized form of the property.
  • ATTACHED_TO_NODE_TYPE — the node/object type to which the property is attached (SYSPROP.SUBJECT_TYPE), identifying the configuration object class the property qualifies.
  • DATA_TYPE — the data type of the property (e.g., numeric, string, boolean), governing valid values in rules and UI.
  • MUTABLE_FLAG — indicates whether the property value may be changed after initial assignment, an important behavioral attribute in configuration rules.
  • COLLECTION_FLAG — indicates whether the property holds a collection of values rather than a single scalar value.
  • SYSTEM_PROPERTY_TYPE — the relationship type code (REL_TYPE_CODE) describing the nature of the attachment.
  • SEQ_NBR — ordering sequence used for deterministic display or processing order.

Common Use Cases and Queries

Because 12.1.1 and 12.2.2 typically expose differing schema details elsewhere but share this stable view definition, it is useful as a compatibility-safe source in diagnostic and reporting scripts. Typical scenarios include validating that expected system properties exist, auditing mutability and data-type settings, and enumerating the node types to which global properties are attached.

SELECT property_id,
       property_name,
       data_type,
       mutable_flag,
       collection_flag,
       attached_to_node_type,
       system_property_type
  FROM apps.cz_global_properties_v
 ORDER BY property_name;

A second common pattern filters for read-only or collection properties:

SELECT property_name, attached_to_node_type
  FROM apps.cz_global_properties_v
 WHERE mutable_flag = 'N'
    OR collection_flag = 'Y';

Note that the CONFIG_ENGINE_TYPE filter restricts results to global (model 0) compatibility, so properties defined only for specific model engine types are intentionally excluded. Queries should therefore be treated as the authoritative list of global-scope properties rather than of all Configurator properties. Oracle proprietary and confidential.