Search Results cz_properties_pk




Overview
Explore in AI Chat

Overview

The CZ_PROPERTIES table is a core data object within the Oracle E-Business Suite Configurator (CZ) module. It serves as the master repository for all property definitions used in the configuration modeling environment. A property, in this context, is a user-defined attribute that can be assigned to configurable items, components, or features to capture specific characteristics, such as color, material, power rating, or any other descriptive element. This table's primary role is to define the metadata for these properties, establishing them as reusable entities that can be consistently applied across the product configuration model to enable rule-based logic, validation, and user interface display.

Key Information Stored

While the provided metadata does not list specific columns, the structure and foreign key relationships indicate the table's critical components. The central column is PROPERTY_ID, which serves as the unique primary key (CZ_PROPERTIES_PK) for every property definition. Other columns typically found in such a master definition table include the property name (PROPERTY_NAME), data type (e.g., NUMBER, VARCHAR2, DATE), default values, and flags controlling behavior (e.g., required flag, searchable flag). The table essentially holds the blueprint for each property, defining how it is stored, validated, and referenced throughout the configuration model, while the actual instance values for specific items are stored in related child tables.

Common Use Cases and Queries

This table is fundamental for administrative and diagnostic tasks within the Configurator. Common use cases include auditing the complete list of defined properties across all models, troubleshooting configuration rules that reference properties, and generating data dictionaries for configuration models. A typical query would involve joining CZ_PROPERTIES with related tables to analyze property usage. For example, to list all properties and the item types they are assigned to, one might use a query such as:

Another critical scenario involves identifying properties used in expression rules for debugging logic, which would involve joining with CZ_EXPRESSION_NODES on PROPERTY_ID.

Related Objects

As evidenced by the foreign key constraints, CZ_PROPERTIES is a central hub referenced by numerous key Configurator tables. Major related objects include:

  • CZ_ITEM_TYPE_PROPERTIES: Links properties to specific item types, defining which attributes are available for a class of configurable components.
  • CZ_ITEM_PROPERTY_VALUES: Stores the actual assigned values for properties on specific configured item instances.
  • CZ_EXPRESSION_NODES: References properties used within conditional logic and calculation rules of the configuration model.
  • CZ_PS_NODES & CZ_PS_PROP_VALS: Reference properties within the runtime configuration session data (PS tables).
  • CZ_UI_NODES: References properties for defining user interface behavior, such as the property used to sort option lists (OPTION_SORT_PROPERTY).