Search Results ams_tcop_contact_summary




Overview
Explore in AI Chat

Overview

The AMS_TCOP_CONTACT_SUMMARY table is a core data object within the Oracle E-Business Suite Marketing (AMS) module, specifically designed to support fatigue management and contact optimization. It stores aggregated contact summary information for a defined period, enabling the system to analyze and enforce rules regarding the frequency and volume of marketing communications sent to customers (parties). This table is critical for implementing contact policies that prevent customer fatigue by ensuring marketing outreach does not exceed configured thresholds over a specific timeframe, thereby improving campaign effectiveness and customer experience.

Key Information Stored

The table's primary purpose is to maintain a period-based summary of contact counts linked to a specific customer and fatigue rule. Its key columns, as inferred from the documented relationships, include the primary key CONTACT_SUMMARY_ID, which uniquely identifies each summary record. The PARTY_ID column stores the identifier for the customer (or prospect) from the Trading Community Architecture (TCA) model, linking to the HZ_PARTIES table. The RULE_ID column references the specific fatigue rule (AMS_TCOP_FR_RULES_SETUP) under which the contacts are being summarized. While the exact period and count columns are not detailed in the provided metadata, the table's description implies it holds aggregated metrics, such as total contact attempts or deliveries, for the party within the rule's defined evaluation period.

Common Use Cases and Queries

This table is primarily accessed for operational reporting and real-time decision-making within marketing workflows. A common use case is checking a customer's current contact level against a rule's limit before initiating a new campaign activity. A typical query would join this summary to the rule setup and party details to assess eligibility.

  • Fatigue Check Query: SELECT acs.* FROM ams_tcop_contact_summary acs, ams_tcop_fr_rules_setup fr WHERE acs.rule_id = fr.rule_id AND acs.party_id = :p_party_id AND fr.active_flag = 'Y';
  • Aggregate Reporting: Generating reports to analyze the distribution of customers across different contact frequency tiers, often joining with HZ_PARTIES for customer attributes.
  • Data Purge/Maintenance: Identifying and archiving summary records for periods that have expired based on the rule's rolling window logic.

Related Objects

The AMS_TCOP_CONTACT_SUMMARY table sits at the center of a key relationship hierarchy within the fatigue management subsystem.

  • Referenced Foreign Keys (This table references):
    • HZ_PARTIES via AMS_TCOP_CONTACT_SUMMARY.PARTY_ID: Links the summary to the customer entity.
    • AMS_TCOP_FR_RULES_SETUP via AMS_TCOP_CONTACT_SUMMARY.RULE_ID: Links the summary to the configured fatigue rule defining the period and limits.
  • Referencing Foreign Key (Table references this):
    • AMS_TCOP_CONTACT_SUM_DTL via AMS_TCOP_CONTACT_SUM_DTL.CONTACT_SUMMARY_ID: The summary record acts as a header for potentially multiple detail records (AMS_TCOP_CONTACT_SUM_DTL) that store granular, individual contact events rolled up into the period summary.