Search Results channel_sum_dtl_id

Overview

The AMS_TCOP_CHANNEL_SUM_DTL table is a core data object within the Oracle E-Business Suite (EBS) Marketing (AMS) module, specifically for versions 12.1.1 and 12.2.2. It functions as a supporting detail table within the Telemarketing Campaign Optimization (TCOP) framework. Its primary role is to log the specific campaign schedules that are included in a contact summarization process. This table enables the system to maintain a granular audit trail, linking high-level contact summary records to the individual campaign execution schedules that were analyzed to generate that summary, which is critical for campaign performance reporting and resource planning.

Key Information Stored

The table stores identifiers that create relationships between summary records and their constituent schedules. The primary column is CHANNEL_SUM_DTL_ID, which serves as the unique identifier for each record in this detail table. The two most critical foreign key columns are CHANNEL_SUMMARY_ID, which links to the parent summary record in the AMS_TCOP_CHANNEL_SUMMARY table, and SCHEDULE_ID, which links to the specific campaign schedule in the AMS_CAMPAIGN_SCHEDULES_B table. Each row essentially represents one schedule that was considered for a particular summarization instance.

Common Use Cases and Queries

The primary use case is reporting and analysis of telemarketing campaign contact plans. For instance, users can analyze which schedules contributed to a summarized forecast of agent workload or contact volume. A common query would involve joining this table to its parent and schedule tables to list all schedules for a given summary. A sample SQL pattern is:

• SELECT sum_dtl.*, sched.SCHEDULE_NAME FROM AMS_TCOP_CHANNEL_SUM_DTL sum_dtl JOIN AMS_TCOP_CHANNEL_SUMMARY summ ON sum_dtl.CHANNEL_SUMMARY_ID = summ.CHANNEL_SUMMARY_ID JOIN AMS_CAMPAIGN_SCHEDULES_B sched ON sum_dtl.SCHEDULE_ID = sched.SCHEDULE_ID WHERE summ.SUMMARY_DATE = TRUNC(SYSDATE);

This table is also crucial for debugging the contact summarization process, allowing administrators to verify the input schedules for a summary that appears incorrect.

Related Objects

AMS_TCOP_CHANNEL_SUM_DTL is centrally connected to two key tables via documented foreign key constraints:

• AMS_TCOP_CHANNEL_SUMMARY: The parent table. The relationship is defined by the foreign key on AMS_TCOP_CHANNEL_SUM_DTL.CHANNEL_SUMMARY_ID referencing AMS_TCOP_CHANNEL_SUMMARY. This links detail records to their overarching summary.
• AMS_CAMPAIGN_SCHEDULES_B: The source of schedule data. The foreign key on AMS_TCOP_CHANNEL_SUM_DTL.SCHEDULE_ID references AMS_CAMPAIGN_SCHEDULES_B. This identifies the exact campaign execution schedule included in the summarization.

The table's primary key constraint, AMS_TCOP_CHANNEL_SUM_DTL_PK1, is on the CHANNEL_SUM_DTL_ID column, ensuring each detail record is unique.