Search Results cz_ui_page_elements




Overview
Explore in AI Chat

Overview

The CZ_UI_PAGE_ELEMENTS table is a core repository for user interface (UI) component definitions within the Oracle Configurator (CZ) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as the metadata store for all individual UI controls—such as input fields, buttons, labels, and images—that are assembled to construct a configurator page. This table is essential for the runtime rendering of the interactive configuration interface, which allows end-users to select and customize products. By defining the properties, layout, and behavior of each UI element, it directly enables the dynamic and guided user experience central to the Configurator application.

Key Information Stored

The table's structure organizes UI element metadata through a composite primary key and descriptive columns. The primary key consists of UI_DEF_ID, PAGE_ID, and ELEMENT_ID, which together uniquely identify a specific element within a page of a UI definition. Key columns include ELEMENT_ID for the component's unique identifier, and the foreign key columns CTRL_TEMPLATE_ID and CTRL_TEMPLATE_UI_DEF_ID. These foreign key columns link an element to its source template in the CZ_UI_TEMPLATES table, allowing for reusable control definitions and consistent styling. Additional columns, implied by its role, typically store data such as the element's display sequence, associated model item or action, positional coordinates, and visual attributes.

Common Use Cases and Queries

Primary use cases involve troubleshooting, auditing, and enhancing configurator interfaces. Developers and functional consultants query this table to understand the composition of a configurator page or to identify all elements using a particular control template. A common reporting need is to list all UI elements for a specific page to verify layout or dependencies. A sample SQL pattern to achieve this is:

  • SELECT element_id, ctrl_template_id FROM cz_ui_page_elements WHERE ui_def_id = <definition_id> AND page_id = <page_number> ORDER BY <sequence_column>;

Another critical scenario is analyzing the impact of modifying a UI template by identifying all page elements that inherit from it, using a join on CTRL_TEMPLATE_ID and CTRL_TEMPLATE_UI_DEF_ID.

Related Objects

The CZ_UI_PAGE_ELEMENTS table maintains defined relationships with other key Configurator metadata tables, primarily through foreign key constraints. As documented in the provided metadata:

  • CZ_UI_TEMPLATES: This is the primary related table. The foreign key defined on columns (CTRL_TEMPLATE_ID, CTRL_TEMPLATE_UI_DEF_ID) in CZ_UI_PAGE_ELEMENTS references the CZ_UI_TEMPLATES table. This relationship allows a UI page element to inherit its core structure and properties from a reusable template.

Logically, this table also has a strong hierarchical relationship with the parent UI page and UI definition tables (though not explicitly listed in the provided FKs), where UI_DEF_ID and PAGE_ID would typically be foreign keys to those parent entities.