Search Results ui_node_type

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:

• UI_NODE_ID and UI_DEF_ID — together these form the composite primary key CZ_UI_NODES_PK. UI_DEF_ID ties each node to its parent user interface definition in CZ_UI_DEFS; UI_NODE_ID is the surrogate identifier for the node itself.
• PARENT_ID — self-referencing foreign key that establishes the node hierarchy (a node's parent node). The unique index CZ_UI_NODES_U2 on (PARENT_ID, UI_DEF_ID, UI_NODE_ID) reinforces this hierarchical path.
• PS_NODE_ID — foreign key to CZ_PS_NODES, linking the UI node to the product structure node it presents.
• CONTAINER_ID and COMPONENT_ID — additional references to CZ_PS_NODES that identify the container and component semantics of the node.
• UI_NODE_TYPE, UI_NODE_SUBTYPE, and CONTROLTYPE — classify the node's rendering behavior and widget type.
• CAPTION_ID and TOOL_TIP_ID — foreign keys to CZ_INTL_TEXTS providing translatable display text and tool tips.
• PROPERTY_ID and OPTION_SORT_PROPERTY — foreign keys to CZ_PROPERTIES used to bind property definitions and option-sorting behavior.
• FUNC_COMP_ID — reference to CZ_FUNC_COMP_SPECS, associating the node with functional component rules.
• MODEL_REF_EXPL_ID and UI_DEF_REF_ID — foreign keys to CZ_MODEL_REF_EXPLS and CZ_UI_DEFS respectively, supporting model reference explanations and UI definition references.
• UI_NODE_REF_ID — self-referencing foreign key used when a node refers to another node.
• EFF_FROM, EFF_TO, DELETED_FLAG — effective dating and soft-delete indicators.
• CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY — standard EBS audit columns.

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.