Search Results node_disabled_flag




Overview
Explore in AI Chat

Overview

In Oracle EBS 12.1.1 and 12.2.2, CZ_PSNODES_FOR_UIELEMS_CV is an APPS-owned, VALID view within the CZ (Configurator) product. It presents configuration model Structure Nodes — the UI elements rendered during a runtime configuration session — joined with metadata that drives user-interface behavior. The view is catalogued under the CZ - Configurator implementation/DBA data set and is intended to feed the Configurator user interface layer, where each row represents a page element (PS node) with its display attributes, effective-dating information, and a computed status flag.

The view is of particular interest to developers searching for node_disabled_flag, a computed column that signals whether a structure node's page element should be rendered as disabled in the UI. This makes the view a primary reference point for diagnostics involving greyed-out or read-only Configurator options.

Underlying Base Objects

The documented 12.2.2 metadata lists the following referenced objects:

The view therefore sits above the explored-node image view and depends on Configurator's type/signature engine to resolve which UI signature applies to a given PS node.

Key Columns

Common Use Cases and Queries

Typical usage includes verifying why a Configurator option renders disabled, auditing effective-dated nodes, and confirming signature assignments before a UI extension or personalization.

  • Identify disabled nodes for a model:
SELECT ps_node_id, name, feature_type, node_disabled_flag
FROM   cz_psnodes_for_uielems_cv
WHERE  model_id = :p_model_id
AND    node_disabled_flag = 1;
  • Retrieve the page element signature and label set for an active node:
SELECT ps_node_id, name, p_page_element_type, full_image_path
FROM   cz_psnodes_for_uielems_cv
WHERE  ps_node_id = :p_ps_node_id;
  • Audit effective-dating and UI suppression together:
SELECT ps_node_id, effective_from, effective_until, ui_omit, node_disabled_flag
FROM   cz_psnodes_for_uielems_cv
WHERE  TRUNC(SYSDATE) BETWEEN effective_from AND NVL(effective_until, SYSDATE + 1);

Because NODE_DISABLED_FLAG is derived from CZ_TYPE_RELATIONSHIPS and CZ_TYPES.GET_UI_SIGNATURE_ID, queries against it reflect current setup data and should not be cached across configuration changes.