Search Results cz_ui_cont_type_templs




Overview
Explore in AI Chat

Overview

The CZ_UI_CONT_TYPE_TEMPLS table is a core data object within the Oracle Configurator (CZ) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as a mapping table that defines the relationship between user interface (UI) content types and their corresponding UI templates. This table is essential for the runtime rendering of configurable models, as it dictates which visual template is applied to a specific type of content—such as a feature, option, or rule—within a configured UI definition. By maintaining these associations, it enables a consistent and structured presentation of the configuration experience to end-users.

Key Information Stored

The table's primary purpose is to store template assignments for UI content types. Its structure is defined by a composite primary key and foreign key relationships. The critical columns are:

  • UI_DEF_ID: A foreign key that uniquely identifies the parent UI definition to which this template mapping belongs.
  • CONTENT_TYPE: Specifies the type of UI element (e.g., a specific model component) that requires templating.
  • TEMPLATE_ID: A foreign key column, used in conjunction with TEMPLATE_UI_DEF_ID, to identify the specific UI template record.
  • TEMPLATE_UI_DEF_ID: A foreign key column that, together with TEMPLATE_ID, points to the applicable template definition in the CZ_UI_TEMPLATES table.

The composite primary key on UI_DEF_ID and CONTENT_TYPE ensures that each content type within a given UI definition is linked to only one template.

Common Use Cases and Queries

This table is primarily accessed during the development and administration of Configurator UIs. A common use case is auditing or modifying template assignments for a specific UI definition. For instance, a developer might query all template mappings for a particular UI to understand its structure or to copy configurations. A typical SQL query would join this table with CZ_UI_TEMPLATES to retrieve the template details:

SELECT ct.UI_DEF_ID, ct.CONTENT_TYPE, t.TEMPLATE_NAME
FROM CZ.CZ_UI_CONT_TYPE_TEMPLS ct,
CZ.CZ_UI_TEMPLATES t
WHERE ct.TEMPLATE_ID = t.TEMPLATE_ID
AND ct.TEMPLATE_UI_DEF_ID = t.UI_DEF_ID
AND ct.UI_DEF_ID = :p_ui_def_id;

Another critical scenario is during the runtime configuration session, where the Configurator engine references this table to determine the correct visual template to apply for each piece of content displayed to the user, ensuring the UI renders according to the designed specifications.

Related Objects

The CZ_UI_CONT_TYPE_TEMPLS table has defined dependencies within the CZ schema, primarily through foreign key constraints. The documented relationships are:

  • Primary Key: CZ_UI_CONT_TYPE_TEMPLS_PK on columns (UI_DEF_ID, CONTENT_TYPE).
  • Foreign Key to CZ_UI_TEMPLATES: The table references the CZ_UI_TEMPLATES table via a composite foreign key. The columns CZ_UI_CONT_TYPE_TEMPLS.TEMPLATE_ID and CZ_UI_CONT_TYPE_TEMPLS.TEMPLATE_UI_DEF_ID map to the primary key columns of CZ_UI_TEMPLATES. This relationship ensures that every template referenced is a valid, existing template definition.

This table is a child of a UI definition and is intrinsically linked to the template repository, forming a bridge between UI structure and presentation logic in Oracle Configurator.