Results for “cz_ui_node_props”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CZ_UI_NODE_PROPS is a Configurator (CZ) module table in the Oracle E-Business Suite database, owned by the CZ schema. Its documented purpose is to attach property values to UI nodes. In practice, the table stores the runtime attribute bag associated with individual nodes within a Configurator user interface definition, allowing each node to carry one or more named property/value pairs that drive rendering and behavior of the configuration UI.

The table resides at the intersection of three identifying concepts: a UI definition (UI_DEF_ID), a UI node (UI_NODE_ID), and a property key (KEY_STR). The heuristic Data Vault classification mined from the foreign-key structure is link. This classification should be treated as a modeling suggestion: the table behaves primarily as an associative entity joining UI definitions to UI nodes and to their property values, rather than as a standalone hub of business entities. It therefore carries relationship semantics plus a small amount of descriptive payload.

Key Information Stored

The documented physical schema lists 16 columns. The most significant are:

• UI_NODE_ID — identifies the UI node to which a property value is attached; also part of the primary key and a foreign key to CZ_UI_NODES.
• UI_DEF_ID — identifies the parent UI definition; part of the primary key and of the foreign key to CZ_UI_NODES.
• KEY_STR — the property name/key; part of the primary key and the business-key candidate.
• VALUE_STR — the property value stored for the given node and key.
• CONTAINER_ID — references CZ_UI_NODES, indicating the container node context for this property.
• DELETED_FLAG — soft-delete indicator for the property row.
• EFF_FROM / EFF_TO — effective dating for the property value.
• SECURITY_MASK / EFF_MASK — masking controls applied to the property and its effective dating.
• CHECKOUT_USER — the user holding the row during a configuration checkout.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns.

The unique index CZ_UI_NODE_PROPS_PK (KEY_STR, UI_DEF_ID, UI_NODE_ID) is the documented business-key candidate and serves as the primary key. The surrogate row identity is effectively the composite of those three columns, since no separate numeric surrogate is documented.

Common Use Cases and Queries

Typical uses include retrieving all properties for a node, comparing property sets across nodes in a UI definition, and auditing changes to property values.

• List properties for a specific node:
  SELECT key_str, value_str FROM cz.cz_ui_node_props WHERE ui_node_id = :node AND ui_def_id = :def AND NVL(deleted_flag,'N') = 'N';
• Find nodes sharing a property value:
  SELECT ui_node_id FROM cz.cz_ui_node_props WHERE key_str = :key AND value_str = :val;
• Join to node metadata:
  SELECT p.key_str, p.value_str, n.* FROM cz.cz_ui_node_props p JOIN cz.cz_ui_nodes n ON p.ui_node_id = n.ui_node_id AND p.ui_def_id = n.ui_def_id;
• Effective-dated reporting using EFF_FROM/EFF_TO to obtain the value in force at a point in time.

Related Objects

The principal related object is CZ_UI_NODES, referenced twice: via UI_NODE_ID and via CONTAINER_ID, both combined with UI_DEF_ID. CZ_UI_NODES is the parent node definition table and is the primary join partner for property lookups. UI_DEF_ID ties rows back to the owning UI definition, which is itself represented in the Configurator UI definition structures (for example the UI definition header table referenced by CZ_UI_NODES). Application logic in the Configurator module reads and writes these rows during UI rendering, checkout, and validation.