Search Results ams_met_tpl_details_uk1

Overview

The AMS_MET_TPL_DETAILS table is a core data object within the Oracle E-Business Suite (EBS) Marketing (AMS) module, specifically for releases 12.1.1 and 12.2.2. It functions as a junction table that defines the composition of a metrics grouping, known as a metric template. Its primary role is to establish the many-to-many relationship between a metric template header (which defines the grouping) and the individual performance metrics contained within it. This structure allows for the flexible assembly and reuse of standard sets of marketing metrics across various analytical and reporting contexts in the application.

Key Information Stored

The table's structure is designed to link template headers to specific metrics and enforce data integrity. The most critical columns are its primary and unique key columns, which define these relationships and prevent duplicate entries. The table stores the following key information:

• METRIC_TEMPLATE_DETAIL_ID: The primary key surrogate identifier for each record in this table.
• METRIC_TPL_HEADER_ID: A foreign key column linking to the AMS_MET_TPL_HEADERS table. This identifies the parent metric grouping or template.
• METRIC_ID: A foreign key column linking to the AMS_METRICS_ALL_B table. This identifies the specific marketing metric (e.g., response rate, cost per lead, ROI) included in the template.

The combination of METRIC_TPL_HEADER_ID and METRIC_ID is enforced as a unique key (AMS_MET_TPL_DETAILS_UK1), ensuring that a given metric can only be added once to a specific template.

Common Use Cases and Queries

This table is central to operations involving the configuration and reporting of marketing performance metrics. Common use cases include validating the structure of a metric template, generating reports that list all metrics within a specific grouping, and auditing metric usage across templates. A typical analytical query would join this table to its related master tables to produce a readable report.

Sample Query: List all metrics within a specific template:

SELECT h.template_name, m.metric_name, m.description
FROM ams_met_tpl_details d,
ams_met_tpl_headers h,
ams_metrics_all_b m
WHERE d.metric_tpl_header_id = h.metric_tpl_header_id
AND d.metric_id = m.metric_id
AND h.template_name = 'Campaign Performance Dashboard'
ORDER BY m.metric_name;

This table is also critical for underlying application logic when a user applies a saved metric template to a campaign or report, as the system queries AMS_MET_TPL_DETAILS to determine which metrics to populate.

Related Objects

AMS_MET_TPL_DETAILS is a child table with defined relationships to two key master tables in the Marketing schema, forming an integral part of the metrics management data model.

• AMS_MET_TPL_HEADERS: The parent table for the metric template definition. The foreign key on METRIC_TPL_HEADER_ID enforces that every detail record must belong to a valid template header.
• AMS_METRICS_ALL_B: The master table defining all available marketing metrics in the system. The foreign key on METRIC_ID ensures that only valid, predefined metrics can be added to a template.

These relationships ensure referential integrity, meaning that a metric cannot be added to a template that does not exist, and a template detail record cannot reference a non-existent metric.