Search Results cz_ui_properties




Overview
Explore in AI Chat

Overview

The CZ_UI_PROPERTIES table is a core data object within the Oracle Configurator (CZ) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. Its primary function is to manage the runtime behavior and appearance of configurator user interfaces (UIs) by persistently storing property-value pairs. As indicated by its description, "Attaches property values to UIs," this table acts as a repository for UI-specific configuration settings, enabling the dynamic rendering and functional control of configurator interfaces presented to end-users during the product configuration process. It is essential for separating UI presentation logic from core configuration model data, allowing for flexible and customizable user experiences.

Key Information Stored

The table's structure centers on linking a UI definition to a specific property and its assigned value. Based on the provided metadata, the primary key is a composite of KEY_STR and UI_DEF_ID, ensuring unique property assignments per UI definition. KEY_STR likely stores the name or identifier of the configurable UI property (e.g., display labels, visibility flags, layout parameters). UI_DEF_ID is a foreign key column that links the property record to its parent user interface definition in the CZ_UI_DEFS table. While the full column list is not detailed in the excerpt, a typical implementation would include a column for the property VALUE (or a similarly named column) to store the specific setting for the KEY_STR. Additional audit columns like CREATED_BY and LAST_UPDATE_DATE are also standard in EBS tables.

Common Use Cases and Queries

This table is primarily accessed for UI customization, troubleshooting, and reporting on configurator interface settings. Common operational scenarios include modifying the default behavior of a configurator UI by updating property values or diagnosing display issues by reviewing the active properties. A fundamental query retrieves all properties for a specific UI definition:

  • SELECT key_str, value FROM cz_ui_properties WHERE ui_def_id = <ID> ORDER BY key_str;

To identify which UIs use a particular property setting, a reverse lookup is useful:

  • SELECT d.ui_def_id, d.name, p.key_str, p.value FROM cz_ui_properties p, cz_ui_defs d WHERE p.ui_def_id = d.ui_def_id AND p.key_str = '<PROPERTY_NAME>';

These queries support administrative tasks, audit reporting, and the migration of UI customizations between environments.

Related Objects

The CZ_UI_PROPERTIES table has a direct and critical relationship with the CZ_UI_DEFS table, as defined by its foreign key constraint. CZ_UI_DEFS is the master table for UI definitions, and CZ_UI_PROPERTIES stores the detailed attributes for those definitions. This relationship is foundational to the Configurator's UI architecture. While not listed in the provided metadata, it is common for other Configurator runtime and administration tables or views to reference or join with CZ_UI_PROPERTIES to resolve UI settings during a configuration session. The table is central to the CZ module's data model, and any processes that generate, deploy, or manage configurator UIs will interact with it.