Search Results cz_ui_pages




Overview
Explore in AI Chat

Overview

CZ_UI_PAGES is a Configurator (CZ) module table in Oracle E-Business Suite that stores the definition of user-interface pages presented during a configuration session. In Oracle Configurator, a model is composed of UI definitions, and each UI definition is further decomposed into one or more pages that control how configurable options, captions, and validation behavior are rendered to the end user. CZ_UI_PAGES therefore occupies a central position in the presentation layer of the Configurator runtime: it maps logical page constructs to the underlying UI definition, tracks display and enablement conditions, and carries the metadata needed by the Configurator server (CZ) to render and validate each page. The object is owned by the CZ schema and is documented as VALID in both 12.1.1 and 12.2.2.

The metadata classifies this object as standalone from a Data Vault perspective, meaning it does not participate in a strong parent/child hub-link-satellite relationship through the documented foreign-key structure. As a modeling suggestion, this indicates CZ_UI_PAGES is best treated as a standalone satellite or reference entity rather than a link table; its relationships are expressed through denormalized *_ID columns rather than enforced multi-table referential chains.

Key Information Stored

The table contains 39 documented columns. The primary key is defined by the composite index CZ_UI_PAGES_PK over (PAGE_ID, UI_DEF_ID, ZD_EDITION_NAME), with PAGE_ID and UI_DEF_ID forming the documented PK pair. A second unique index, CZ_UI_PAGES_U1, is defined over (JRAD_DOC, ZD_EDITION_NAME) and serves as an additional business-key candidate.

Common Use Cases and Queries

Typical usage centers on diagnostics, migration, and reporting of Configurator UI structure. Common patterns include retrieving all pages for a UI definition, identifying empty or deleted pages, and auditing conditional behavior.

  • List pages for a UI definition: SELECT page_id, name FROM cz.cz_ui_pages WHERE ui_def_id = :ui_def_id AND deleted_flag = 'N';
  • Find active pages with display conditions: SELECT page_id, display_condition_comp, display_condition_value FROM cz.cz_ui_pages WHERE display_condition_id IS NOT NULL;
  • Identify empty pages: SELECT page_id, name FROM cz.cz_ui_pages WHERE empty_page_flag = 'Y';
  • Seeded vs. customer pages: SELECT seeded_flag, COUNT(*) FROM cz.cz_ui_pages GROUP BY seeded_flag;

Related Objects

The documented relationship data describes CZ_UI_PAGES as standalone; the following joins are typical through the denormalized keys present in the schema.