Search Results ams_tcop_contact_sum_dtl




Overview
Explore in AI Chat

Overview

The AMS_TCOP_CONTACT_SUM_DTL table is a core data object within the Oracle E-Business Suite Marketing (AMS) module, specifically for versions 12.1.1 and 12.2.2. It functions as a supporting detail table within the campaign optimization and contact history architecture. Its primary role is to maintain a granular record of the specific campaign schedules that were aggregated to produce summarized contact counts. This table is essential for traceability, allowing the system to link high-level summary metrics back to the individual campaign execution components from which they were derived.

Key Information Stored

Based on the provided metadata, the table's structure centers on two key foreign key relationships and a primary identifier. The most critical columns are:

Each row effectively represents a single schedule's contribution to a summarized contact total, enabling a one-to-many relationship between a contact summary and its constituent schedules.

Common Use Cases and Queries

This table is primarily accessed for audit, reconciliation, and detailed analytical reporting within marketing operations. A common use case is investigating the composition of a reported contact count to understand which specific campaign deliveries contributed to it. For instance, if a summary shows 10,000 contacts, analysts can query this table to list all schedules that comprised that total. A typical SQL pattern involves joining to the related summary and schedule tables:

SELECT sum_dtl.SUMMARY_DTL_ID, sum_dtl.CONTACT_SUMMARY_ID, sum_dtl.SCHEDULE_ID, sched.SCHEDULE_NAME
FROM AMS_TCOP_CONTACT_SUM_DTL sum_dtl,
    AMS_CAMPAIGN_SCHEDULES_B sched
WHERE sum_dtl.SCHEDULE_ID = sched.SCHEDULE_ID
AND sum_dtl.CONTACT_SUMMARY_ID = :p_summary_id;

This query retrieves all schedule details for a given contact summary, providing transparency into the underlying marketing touches.

Related Objects

The AMS_TCOP_CONTACT_SUM_DTL table exists within a defined hierarchy and has explicit dependencies as documented in the ETRM metadata.

  • Parent Table (Foreign Key Reference): AMS_TCOP_CONTACT_SUMMARY. The CONTACT_SUMMARY_ID column in AMS_TCOP_CONTACT_SUM_DTL references this table. This is the primary relationship, tethering detail records to their parent summary entity.
  • Reference Table (Foreign Key Reference): AMS_CAMPAIGN_SCHEDULES_B. The SCHEDULE_ID column in AMS_TCOP_CONTACT_SUM_DTL references this base table for campaign schedules, providing the essential link to the actual marketing execution data.
  • Primary Key Constraint: AMS_TCOP_CONTACT_SUM_DTL_PK1 on the SUMMARY_DTL_ID column ensures the uniqueness of each detail record.

This table is typically populated by backend marketing processes during campaign optimization and contact history summarization routines, and is queried by standard Oracle Marketing reports and custom analytical queries.