Results for “cz_ui_cont_type_templs”

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

Overview

CZ_UI_CONT_TYPE_TEMPLS is a Configurator (CZ) module table that lists the templates associated with each content type within a user interface definition. In the Oracle E-Business Suite Configurator, a UI definition groups the content types and presentation templates that drive how configurable models and their runtime selections are rendered to users. This table acts as the association or mapping table that binds a given UI definition and content type combination to a specific template stored in CZ_UI_TEMPLATES.

From a Data Vault modeling perspective, the mined foreign key structure classifies this object as satellite-leaning. That classification is a heuristic suggestion rather than an enforced design: the table carries descriptive attributes (flags and audit columns) that qualify a parent business key, which is characteristic of satellite treatment. The business key is composed of UI_DEF_ID and CONTENT_TYPE, with the edition discriminator ZD_EDITION_NAME present in the physical unique indexes. The object holds the status VALID in the CZ schema and is documented as part of the Configurator product in both Oracle EBS 12.1.1 and 12.2.2, where the edition-aware columns reflect the 12.2.2 multi-edition (ZD_EDITION_NAME) physical model.

Key Information Stored

The table contains 14 documented columns. The most significant include:

• UI_DEF_ID — Identifies the user interface definition to which the content type template mapping belongs. This is a component of the primary key.
• CONTENT_TYPE — The content type within the UI that the template renders. This is the second component of the primary key.
• TEMPLATE_ID — The template from CZ_UI_TEMPLATES associated with this content type; a referential link to the template master.
• TEMPLATE_UI_DEF_ID — The UI definition context of the referenced template, paired with TEMPLATE_ID in the unique index and FK relationship.
• MASTER_TEMPLATE_FLAG — Indicates whether the mapped template is the master (default) template for the content type.
• SEEDED_FLAG — Marks whether the mapping row was supplied as seeded Oracle data versus customer-created data.
• WRAP_TEMPLATE_FLAG — Indicates whether the template wraps its content within an enclosing presentation structure.
• DELETED_FLAG — Soft-delete indicator, allowing logical removal without physical deletion.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns tracking row creation and maintenance.
• ZD_EDITION_NAME — The edition discriminator present in 12.2.2, included in both unique indexes.

The surrogate primary key is CZ_UI_CONT_TYPE_TEMPLS_PK, defined over UI_DEF_ID, CONTENT_TYPE, and ZD_EDITION_NAME. The unique index CZ_UI_CONT_TYPE_TEMPLS_N1 (CONTENT_TYPE, UI_DEF_ID, TEMPLATE_ID, TEMPLATE_UI_DEF_ID, ZD_EDITION_NAME) provides an additional candidate business-key constraint across the template pairing.

Common Use Cases and Queries

Typical use cases involve resolving which template renders a content type for a given UI, validating template coverage, and identifying seeded versus customer mappings.

• Resolve templates for a UI definition:

  SELECT content_type, template_id, template_ui_def_id, master_template_flag
  FROM   cz.cz_ui_cont_type_templs
  WHERE  ui_def_id = :ui_def_id
  AND    deleted_flag = 'N';

• Locate master templates per content type within a UI scope.
• Audit configuration by separating seeded rows (SEEDED_FLAG) from custom rows.
• Join to CZ_UI_TEMPLATES on TEMPLATE_ID and TEMPLATE_UI_DEF_ID to retrieve template names and properties.
• Detect duplicate or orphaned mappings via the CZ_UI_CONT_TYPE_TEMPLS_N1 candidate key.

Reporting commonly filters on DELETED_FLAG = 'N' and, in 12.2.2, on ZD_EDITION_NAME to isolate the active edition.

Related Objects

• CZ_UI_TEMPLATES — The referenced template master; joined via TEMPLATE_ID and TEMPLATE_UI_DEF_ID.
• CZ_UI_DEFINITIONS — The UI definition parent implied by UI_DEF_ID, providing UI-level context.
• CZ_UI_CONTENT_TYPES — The content type catalog referenced by CONTENT_TYPE.
• CZ_UI_CONT_TYPE_TEMPLS_PK — The primary key constraint enforcing unique UI/content type mappings.
• CZ_UI_CONT_TYPE_TEMPLS_N1 — The unique index supporting the template-pairing business key.
• CZ_CONFIGURATOR APIs — Configurator runtime and UI-generation logic that consumes these mappings when rendering configurable models.