Search Results cz_item_property_values




Overview
Explore in AI Chat

Overview

The CZ_ITEM_PROPERTY_VALUES table is a core data repository within the Oracle Configurator (CZ) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the central table for storing the specific property values assigned to configurable items. In the context of the Configurator, an item is a component within a product model, and properties define its characteristics, such as color, material, or voltage. This table establishes the many-to-many relationship between items and their defined properties, enabling the complex, rule-based product configuration for which the module is designed. Its integrity is critical for the runtime engine to validate user selections and generate valid configurations.

Key Information Stored

The table's structure is defined by its primary and foreign key relationships. The primary key is a composite of PROPERTY_ID and ITEM_ID, ensuring a unique combination of a property and an item. The PROPERTY_ID column stores the unique identifier linking to the CZ_PROPERTIES table, which holds the definition of the property itself (e.g., name, data type). The ITEM_ID column stores the unique identifier linking to the CZ_ITEM_MASTERS table, which contains the master definition of the configurable component. While the provided metadata does not list specific value columns, typical implementations include columns such as VALUE (for the actual property setting), NUMERIC_VALUE, DATE_VALUE, or a reference to a lookup list to store the property value based on its data type.

Common Use Cases and Queries

This table is primarily accessed for configuration validation, reporting on item specifications, and data migration. A common use case is to query all property values for a specific item to display its full technical specification. For example, to find all properties and their values for a given item master name, a query would join CZ_ITEM_MASTERS, CZ_ITEM_PROPERTY_VALUES, and CZ_PROPERTIES. Another critical scenario involves troubleshooting configuration issues by verifying the stored property values against expected rules. Developers also query this table extensively when extending the Configurator or building custom interfaces that need to read or set item property data, ensuring any data manipulation maintains referential integrity through the documented foreign keys.

Related Objects

The CZ_ITEM_PROPERTY_VALUES table has defined foreign key relationships with two fundamental master tables in the Configurator schema, as documented in the ETRM metadata:

  • CZ_ITEM_MASTERS: Joined via the ITEM_ID column. This table contains the master record for each configurable item or component.
  • CZ_PROPERTIES: Joined via the PROPERTY_ID column. This table defines the properties available in the system, including their data types and constraints.

These relationships enforce that a property value must be associated with a valid, existing item and a valid, existing property definition. The table is also intrinsically linked to the runtime Configurator engine and likely referenced by various CZ seed data views and APIs that manage configuration models.