Search Results control_layout

Overview

CZ_UI_DEFS is the user interface definition table within the Oracle Configurator (CZ) module of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. It stores the metadata that governs how configured products and models are rendered to end users, including layout rules, control templates, pagination behavior, sorting, navigation, and pricing display options. Each row defines a distinct UI presentation that can be attached to a configuration model or published for use at runtime.

In a Data Vault sense, the extracted foreign-key topology suggests a hub-leaning classification: the table carries its own surrogate primary key and is referenced by multiple downstream tables, making it a plausible candidate for a hub entity, while columns such as EFF_FROM, EFF_TO, MODEL_TIMESTAMP, and CONTENT_LAST_UPDATE_DATE exhibit satellite-like, time-variant characteristics. This should be treated as a heuristic modeling suggestion rather than a physical design constraint.

Key Information Stored

The primary key is CZ_UI_DEFS_PK on UI_DEF_ID, a system-generated surrogate identifier. A second unique index, CZ_UI_DEFS_UPK, spans UI_DEF_ID and ZD_EDITION_NAME, reflecting the multi-edition (ZD) architecture introduced with the 12.2 online patching model and serving as the business-key candidate.

• UI_DEF_ID — Surrogate primary key uniquely identifying each UI definition.
• NAME / DESC_TEXT — Business-facing name and description of the UI definition.
• DEVL_PROJECT_ID — Foreign key to CZ_DEVL_PROJECTS, tying the definition to a development project.
• COMPONENT_ID — Foreign key to CZ_PS_NODES, linking the definition to a configuration component node.
• ZD_EDITION_NAME — Edition identifier supporting online patching in 12.2.2.
• UI_STYLE, LOOK_AND_FEEL, PAGE_LAYOUT, CONTROL_LAYOUT, BOMUI_LAYOUT, NONBOM_UILAYOUT — Rendering and layout directives controlling presentation.
• MASTER_TEMPLATE_FLAG, SEEDED_FLAG, FROM_MASTER_TEMPLATE_ID, EMPTY_UI_FLAG — Flags governing template inheritance, Oracle-seeded content, and empty definitions.
• CONTROLS_PER_SCREEN, PAGINATION_SLOT, PAGIN_MAXCONTROLS, ROWS_PER_TABLE — Pagination and screen-density parameters.
• START_PAGE_ID, START_URL, PRIMARY_NAVIGATION, SHOW_TRAIN — Navigation entry-point and flow controls.
• OPTION_SORT_METHOD, OPTION_SORT_ORDER, OPTION_SORT_PROPERTY_ID, OPTION_SORT_SELECT_FIRST — Option ordering behavior.
• PRICE_DISPLAY, PRICE_UPDATE — Pricing presentation and update rules.
• PERSISTENT_UI_DEF_ID, UI_STATUS, GEN_VERSION — Lifecycle and versioning attributes.
• EFF_FROM, EFF_TO — Effective dating bounds for the definition.
• SEEDED_FLAG, DELETED_FLAG — Standard status and soft-delete markers.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns.

Common Use Cases and Queries

Configurator administrators and developers query CZ_UI_DEFS to audit which UI definitions exist, how they relate to development projects, and which are referenced by shipped configuration headers. A typical listing query returns the top-level identity and status columns.

SELECT UI_DEF_ID, NAME, UI_STATUS, SEEDED_FLAG, MASTER_TEMPLATE_FLAG, ZD_EDITION_NAME FROM CZ.CZ_UI_DEFS WHERE DELETED_FLAG = 'N';

To trace definitions belonging to a specific development project:

SELECT u.UI_DEF_ID, u.NAME, p.NAME FROM CZ.CZ_UI_DEFS u, CZ.CZ_DEVL_PROJECTS p WHERE u.DEVL_PROJECT_ID = p.DEVL_PROJECT_ID;

Reverse-dependency reporting identifies which published models or configuration headers consume a given definition, valuable before modifying or retiring a template. UI definitions are typically surfaced through Oracle Configurator administration and runtime UI facilities rather than a dedicated public API, so direct SQL against the base table is the common integration pattern for reporting.

Related Objects

• CZ_DEVL_PROJECTS — Referenced via CZ_UI_DEFS.DEVL_PROJECT_ID; parent development project.
• CZ_PS_NODES — Referenced via CZ_UI_DEFS.COMPONENT_ID; associated configuration component.
• CZ_UI_NODES — Child table referencing CZ_UI_DEFS.UI_DEF_ID and UI_DEF_REF_ID; holds node-level UI structure.
• CZ_UI_PROPERTIES — Child table referencing UI_DEF_ID; stores per-definition UI properties.
• CZ_CONFIG_HDRS — References UI_DEF_ID; links configuration headers to their UI definition.
• CZ_MODEL_PUBLICATIONS — References UI_DEF_ID; records published model/definition pairings.