Search Results cz_ps_prop_vals




Overview
Explore in AI Chat

Overview

The CZ_PS_PROP_VALS table is a core data object within the Oracle E-Business Suite Configurator (CZ) module, specifically for releases 12.1.1 and 12.2.2. It functions as the central repository for storing property values assigned to nodes within a configuration project. When a user configures a complex product, the system creates a runtime project structure. This table captures the specific values for configurable properties (like color, size, or technical specifications) that are selected or derived for each project node instance. Its role is critical for persisting the complete state of a configured item, enabling functions such as saving in-progress configurations, retrieving past configurations, and driving downstream processes like pricing and bill of material generation.

Key Information Stored

The table's structure is defined by a composite primary key and columns that link to related entities and store the actual value data. The primary key consists of PROPERTY_ID and PS_NODE_ID, ensuring a unique property value for each node instance. The PS_NODE_ID column is a foreign key that links the value to a specific node within the configuration project hierarchy stored in CZ_PS_NODES. The PROPERTY_ID column is a foreign key that links to the definition of the property itself in the CZ_PROPERTIES table. While the provided metadata does not list all value-holding columns, typical implementations include columns such as VALUE (for the actual property setting), NUM_VALUE, DATE_VALUE, or a CLOB for longer text, depending on the property's data type. Additional columns often track data origin, sequencing, and status.

Common Use Cases and Queries

A primary use case is the extraction of a complete configuration snapshot for reporting or integration. For instance, to generate a summary of all property values for a specific configuration project, one would join from the project's root node through the node hierarchy to this table. Another common scenario is troubleshooting or auditing configuration data, where queries identify nodes with specific property values set. A typical query pattern involves joining CZ_PS_PROP_VALS to CZ_PS_NODES and CZ_PROPERTIES to retrieve human-readable names.

SELECT n.NAME AS node_name, p.NAME AS property_name, v.VALUE
FROM CZ_PS_PROP_VALS v,
     CZ_PS_NODES n,
     CZ_PROPERTIES p
WHERE v.PS_NODE_ID = n.PS_NODE_ID
  AND v.PROPERTY_ID = p.PROPERTY_ID
  AND n.PS_NODE_ID = :specific_node_id;

Related Objects

The CZ_PS_PROP_VALS table maintains defined foreign key relationships with two fundamental Configurator tables, as documented in the ETRM metadata:

  • CZ_PROPERTIES: The relationship CZ_PS_PROP_VALS.PROPERTY_ID = CZ_PROPERTIES.PROPERTY_ID ensures every stored value references a valid, defined property within the model.
  • CZ_PS_NODES: The relationship CZ_PS_PROP_VALS.PS_NODE_ID = CZ_PS_NODES.PS_NODE_ID anchors each property value to a specific instance of a component or item within an active configuration session or saved project.

These relationships are essential for maintaining data integrity. The table is also intrinsically linked to the broader configuration runtime schema, including tables like CZ_PS_PROJECTS and CZ_PS_OUTPUTS, through the node hierarchy.