Search Results cz_ui_nodes




Overview
Explore in AI Chat

Overview

The CZ_UI_NODES table is a core repository within the Oracle E-Business Suite Configurator (CZ) module, specifically for releases 12.1.1 and 12.2.2. It serves as the master definition table for all user interface elements, or "nodes," that constitute the structure and layout of a runtime configurator interface. Each record in this table represents a distinct UI component, such as a tab, region, item, button, or a reference to another UI definition. The table's primary role is to store the hierarchical and relational metadata that defines how a configurator is presented to an end-user, enabling the dynamic rendering of complex product configuration screens within Oracle EBS.

Key Information Stored

The table's structure is centered on identifying nodes and their relationships within a specific UI definition. The primary key is a composite of UI_NODE_ID and UI_DEF_ID, ensuring uniqueness within a given interface definition. Critical columns include UI_DEF_ID, which links the node to its parent CZ_UI_DEFS record, and PARENT_ID, which establishes the hierarchical parent-child relationship between nodes (e.g., a button within a region). Other significant foreign key columns define the node's functional purpose: PS_NODE_ID links to a model component in CZ_PS_NODES, PROPERTY_ID binds the node to a specific CZ_PROPERTIES record, and FUNC_COMP_ID associates it with a functional component specification. Columns like CAPTION_ID and TOOL_TIP_ID point to internationalized text in CZ_INTL_TEXTS for multilingual support.

Common Use Cases and Queries

This table is central to troubleshooting, auditing, and extending configurator interfaces. Common use cases include analyzing the complete UI structure for a given configurator, identifying all nodes bound to a specific model component, or cloning UI definitions. A typical query retrieves the node hierarchy for a UI definition:

SELECT node.ui_node_id, node.parent_id, node.ps_node_id, ps.node_name
FROM cz_ui_nodes node
LEFT JOIN cz_ps_nodes ps ON node.ps_node_id = ps.ps_node_id
WHERE node.ui_def_id = :p_ui_def_id
START WITH node.parent_id IS NULL
CONNECT BY PRIOR node.ui_node_id = node.parent_id AND node.ui_def_id = :p_ui_def_id;

Another common pattern is joining with CZ_INTL_TEXTS to extract captions for reporting or translation audits, or querying for all nodes referencing a particular property for impact analysis during model changes.

Related Objects

The CZ_UI_NODES table has extensive relationships within the Configurator schema, as evidenced by its foreign keys. Key documented dependencies include:

  • CZ_UI_DEFS: The master UI definition table, joined via UI_DEF_ID and UI_DEF_REF_ID.
  • CZ_PS_NODES: The model structure table, joined via PS_NODE_ID, CONTAINER_ID, and COMPONENT_ID.
  • CZ_PROPERTIES: The properties table, joined via PROPERTY_ID and OPTION_SORT_PROPERTY.
  • CZ_INTL_TEXTS: The internationalized text table, joined via CAPTION_ID and TOOL_TIP_ID.
  • CZ_FUNC_COMP_SPECS: The functional component specifications table, joined via FUNC_COMP_ID.
  • CZ_MODEL_REF_EXPLS: The model reference explanations table, joined via MODEL_REF_EXPL_ID.
  • Self-Referential: The table references itself via PARENT_ID and UI_NODE_REF_ID to manage hierarchy and node reuse.
  • CZ_UI_NODE_PROPS: A child table storing extended properties for UI nodes, joined on UI_NODE_ID and UI_DEF_ID.