Search Results key_str




Overview
Explore in AI Chat

Overview

The CZ_UI_NODE_PROPS table is a core data object within the Oracle Configurator (CZ) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It serves as a junction table that attaches specific property values to user interface (UI) nodes. In the Configurator runtime environment, UI nodes represent the visual and interactive elements displayed to users during a configuration session. This table is essential for defining the runtime behavior, appearance, and validation rules of these UI elements by storing key-value pairs of properties. Its role is to bridge the logical model of a configurable product with its presentation layer, enabling dynamic and rule-driven user interfaces.

Key Information Stored

The table's structure is designed to associate properties with specific nodes within a UI definition. The primary key is a composite of KEY_STR, UI_DEF_ID, and UI_NODE_ID, ensuring uniqueness for each property assignment. The KEY_STR column is critical, as it holds the name or identifier of the property being set (e.g., visibility conditions, display text, or data validation rules). The UI_DEF_ID and UI_NODE_ID columns are foreign keys that link the property to a specific node within a particular UI definition. An additional notable column is CONTAINER_ID, which, along with UI_DEF_ID, forms a foreign key relationship to CZ_UI_NODES, supporting hierarchical UI structures. The table typically includes a column for the property value itself, though it is not explicitly listed in the provided metadata excerpt.

Common Use Cases and Queries

This table is primarily accessed for troubleshooting UI behavior, auditing configuration rules, and generating reports on Configurator interface definitions. A common scenario involves investigating why a UI element behaves unexpectedly by querying its assigned properties. A sample query to retrieve all properties for a specific UI node would be:

  • SELECT key_str, property_value FROM cz_ui_node_props WHERE ui_def_id = &def_id AND ui_node_id = &node_id ORDER BY key_str;

Another frequent use case is identifying all nodes where a particular property, such as a specific enabling condition, is applied. This is valuable for impact analysis when modifying underlying configuration logic. The query pattern would filter on the KEY_STR column.

Related Objects

The CZ_UI_NODE_PROPS table has integral relationships with other core Configurator schema objects. Its primary foreign key dependencies are on the CZ_UI_NODES table, linking via the (UI_NODE_ID, UI_DEF_ID) and (CONTAINER_ID, UI_DEF_ID) column pairs. CZ_UI_NODES defines the structure and hierarchy of the UI elements themselves. The table is governed by the primary key constraint CZ_UI_NODE_PROPS_PK. While not listed in the excerpt, it is often referenced by Configurator runtime engine APIs and seed data scripts within the CZ schema. Direct modifications to this table should be performed with extreme caution, typically through supported Configurator authoring tools or APIs.