Results for “button_bar_templ_uidef_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The CZ.CZ_UI_TEMPLATES table stores UI Content Template definitions for the Oracle Configurator module (CZ) in Oracle E-Business Suite 12.1.1 and 12.2.2. It is the repository in which Configurator user-interface templates — including container, layout, button-bar, and message template definitions — are persisted and versioned. Each row describes a reusable template that governs how Configurator runtime pages, controls, and reference regions are rendered to end users during model configuration.

Based on the foreign-key topology documented in the ETRM metadata, the table exhibits hub-leaning characteristics in a Data Vault model. It is referenced by multiple downstream tables (CZ_UI_CONT_TYPE_TEMPLS, CZ_UI_PAGE_ELEMENTS, CZ_UI_REF_TEMPLATES), which is the signature of a hub acting as the integration point for several dependent satellites and links. This classification is a modeling suggestion only; the physical table remains a standard EBS transactional/definition table.

Key Information Stored

The table is owned by the CZ schema and contains 28 documented columns in the 12.2.2 schema. The most significant include:

• TEMPLATE_ID — surrogate identifier for the template; part of the composite primary key.
• UI_DEF_ID — the associated UI definition identifier; the second component of the primary key, scoping the template to a particular UI definition.
• ZD_EDITION_NAME — editioning column present in 12.2.x, used with Edition-Based Redefinition; also part of the unique index CZ_UI_TEMPLATES_PK.
• TEMPLATE_NAME, TEMPLATE_DESC — the display name and descriptive text of the template.
• TEMPLATE_TYPE, TEMPLATE_USAGE — classify the template and indicate where it is used.
• PARENT_CONTAINER_TYPE, ROOT_REGION_TYPE, ROOT_ELEMENT_SIGNATURE_ID — describe the template's structural hierarchy and root region.
• JRAD_DOC — the underlying JDeveloper/UIX document, typically a CLOB holding template markup.
• BUTTON_BAR_TEMPLATE_ID, BUTTON_BAR_TEMPL_UIDEF_ID — reference an associated button-bar template.
• MESSAGE_TYPE, MAIN_MESSAGE_ID, TITLE_ID — message and title bindings.
• SEEDED_FLAG, DELETED_FLAG — indicate Oracle-seeded versus user-defined templates and logical deletion.
• TEMPLATE_REV_NBR — revision number for template versions.
• CHECKOUT_USER, CHECKOUT_TIME — support concurrent development checkout semantics.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.

The composite primary key CZ_UI_TEMPLATES_PK is defined on (TEMPLATE_ID, UI_DEF_ID) in 12.1.1 and extended with ZD_EDITION_NAME in 12.2.2. The documented unique index therefore identifies the business-key candidates as TEMPLATE_ID, UI_DEF_ID, and ZD_EDITION_NAME.

Common Use Cases and Queries

Typical uses include auditing which templates are seeded, identifying templates checked out by a developer, and tracing template usage across content types and page elements.

• List seeded templates for a given UI definition:
  SELECT template_id, ui_def_id, template_name, template_type FROM cz.cz_ui_templates WHERE ui_def_id = :ui_def_id AND seeded_flag = 'Y' AND deleted_flag = 'N';
• Find templates currently checked out:
  SELECT template_id, template_name, checkout_user, checkout_time FROM cz.cz_ui_templates WHERE checkout_user IS NOT NULL;
• Report templates linked to content types:
  SELECT t.template_name, c.content_type_id FROM cz.cz_ui_templates t, cz.cz_ui_cont_type_templs c WHERE t.template_id = c.template_id AND t.ui_def_id = c.template_ui_def_id;

Related Objects

The following tables reference CZ_UI_TEMPLATES via documented foreign keys and are the most significant related objects:

• CZ_UI_CONT_TYPE_TEMPLS — links templates to content types via TEMPLATE_ID / TEMPLATE_UI_DEF_ID.
• CZ_UI_PAGE_ELEMENTS — references control templates through CTRL_TEMPLATE_ID / CTRL_TEMPLATE_UI_DEF_ID.
• CZ_UI_REF_TEMPLATES — holds both TEMPLATE_ID and REF_TEMPLATE_ID references, enabling template-to-template relationships.
• CZ_UI_DEFINITIONS (implied by UI_DEF_ID) — the parent UI definition owning the template set.