Search Results option_sort_method




Overview
Explore in AI Chat

Overview

CZ_UI_NODES is a Configurator (CZ) module table in the Oracle E-Business Suite 12.1.1 and 12.2.2 releases. It describes each UI node — the individual building blocks that make up a Configurator user interface, such as containers, components, captions, tool tips, and their positional and styling attributes. Together with CZ_UI_DEFS (which defines the overall user interface) and CZ_PS_NODES (the underlying product structure nodes), CZ_UI_NODES acts as the physical and logical layout repository that the Configurator runtime uses to render configuration screens. It is a core structural table for any Configurator implementation, sitting between the model definition layer and the presentation layer.

The table resides in the CZ schema and is documented as VALID. It is owned by the Configurator product and is not an interface or temporary table. The heuristic Data Vault classification mined from the foreign-key structure is satellite-leaning, which suggests modeling it as a satellite attached to the associated UI definition and product structure hubs rather than as an independent hub or link. This is offered as a modeling suggestion; in the EBS operational context the table is simply a transactional definition table keyed by UI node and UI definition.

Key Information Stored

The table documents 59 columns. The most significant include:

The documented unique indexes are CZ_UI_NODES_PK (UI_NODE_ID, UI_DEF_ID) and CZ_UI_NODES_U2 (PARENT_ID, UI_DEF_ID, UI_NODE_ID). Additional columns such as REL_TOP_POS, REL_LEFT_POS, WIDTH, HEIGHT, FONTNAME, FONTSIZE, BACKGROUND_COLOR, and TAB_ORDER control the visual layout of each node.

Common Use Cases and Queries

Typical scenarios include troubleshooting a Configurator UI that renders incorrectly, verifying the node hierarchy for a given interface, and auditing which product structure nodes are exposed to end users. A representative query extracts all nodes belonging to a UI definition:

SELECT UI_NODE_ID, UI_NODE_TYPE, PARENT_ID, PS_NODE_ID, CAPTION_ID
FROM   CZ.CZ_UI_NODES
WHERE  UI_DEF_ID = :ui_def_id
AND    DELETED_FLAG = 'N';

A recursive query using CONNECT BY PRIOR walks the parent/child tree via PARENT_ID to reconstruct the node hierarchy. Joining to CZ_INTL_TEXTS on CAPTION_ID resolves display captions for reporting, while joining to CZ_PROPERTIES on PROPERTY_ID returns property metadata. Effective-dating filters on EFF_FROM and EFF_TO support point-in-time reporting. Extension and migration scripts commonly insert or update rows here when deploying new Configurator interfaces.

Related Objects

The most significant related objects, based on documented foreign-key relationships, are:

  • CZ_UI_DEFS — joined by Z_UI_NODES.UI_DEF_ID and UI_DEF_REF_ID; parent user interface definition.
  • CZ_PS_NODES — joined by PS_NODE_ID, CONTAINER_ID, and COMPONENT_ID; product structure node references.
  • CZ_INTL_TEXTS — joined by CAPTION_ID and TOOL_TIP_ID; translatable text.
  • CZ_PROPERTIES — joined by PROPERTY_ID and OPTION_SORT_PROPERTY.
  • CZ_FUNC_COMP_SPECS — joined by FUNC_COMP_ID.
  • CZ_MODEL_REF_EXPLS — joined by MODEL_REF_EXPL_ID.
  • CZ_UI_NODE_PROPS — references this table via UI_NODE_ID and CONTAINER_ID.
  • CZ_UI_NODES — self-referential via PARENT_ID and UI_NODE_REF_ID.