Search Results cz_ui_defs

Overview

The CZ_UI_DEFS table is a core repository for user interface (UI) definitions within the Oracle Configurator (CZ) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the master table for storing the structural metadata that defines the layout, appearance, and interactive behavior of configurator interfaces presented to end-users. These UI definitions are critical for rendering the guided configuration experience, allowing users to select options, features, and components for complex, configurable products. The table's central role is evidenced by its numerous foreign key relationships, linking it directly to configuration models, published projects, and the detailed UI nodes and properties that compose a complete interface.

Key Information Stored

The table's primary key is the UI_DEF_ID, a unique identifier for each UI definition record. Based on the documented foreign key relationships, other significant columns include COMPONENT_ID and DEVL_PROJECT_ID. The COMPONENT_ID links the UI definition to a specific configurable component within the product structure (CZ_PS_NODES). The DEVL_PROJECT_ID associates the UI definition with its parent development project (CZ_DEVL_PROJECTS), which is the primary container for configuration models within the Configurator Developer. While the exact full column list is not detailed in the provided metadata, the foreign keys indicate the table anchors the UI definition within the broader Configurator data model, connecting it to both the logical model and the development workspace.

Common Use Cases and Queries

This table is primarily accessed during the runtime execution of a configurator and during development and publication processes. Common operational and administrative queries involve identifying UI definitions for troubleshooting, auditing, or impact analysis. For instance, to list all UI definitions within a specific development project, a query would join CZ_UI_DEFS to CZ_DEVL_PROJECTS. Another typical use case is tracing the UI used for a specific configuration session or model publication by joining CZ_UI_DEFS to CZ_CONFIG_HDRS or CZ_MODEL_PUBLICATIONS via the UI_DEF_ID. Sample SQL to find UI definitions linked to a published model would be:

• SELECT u.UI_DEF_ID, p.PUBLICATION_NAME FROM CZ_UI_DEFS u, CZ_MODEL_PUBLICATIONS p WHERE u.UI_DEF_ID = p.UI_DEF_ID;

Related Objects

As per the ETRM metadata, CZ_UI_DEFS has extensive relationships with other key Configurator tables. It is referenced as a foreign key by CZ_CONFIG_HDRS and CZ_MODEL_PUBLICATIONS, showing its use in runtime configurations and published models. It is also referenced by CZ_UI_NODES (twice, for UI_DEF_ID and UI_DEF_REF_ID) and CZ_UI_PROPERTIES, which store the detailed hierarchical structure and specific attributes of the UI. Conversely, CZ_UI_DEFS itself holds foreign keys to CZ_PS_NODES (for the component) and CZ_DEVL_PROJECTS. This network of relationships positions CZ_UI_DEFS as a central hub between the configurator's logical model, its development environment, and the final rendered user interface.