Search Results aml_interaction_leads_pk

Overview

The AML_INTERACTION_LEADS table is a core data object within the Oracle E-Business Suite (EBS) Marketing (AMS) module. It functions as a relational junction table, formally defining and storing the associations between marketing interactions, customer responses, and generated sales leads. This table is critical for tracking the marketing funnel's effectiveness, enabling organizations to trace a specific sales lead back to the originating customer interaction and marketing campaign response. Its existence supports closed-loop marketing analysis by linking operational marketing activities directly to downstream sales opportunities within the EBS ecosystem.

Key Information Stored

The table's primary purpose is to maintain foreign key relationships, with its own surrogate primary key, INTERACTION_LEAD_ID, ensuring each relationship record is uniquely identifiable. The most significant columns are the foreign keys that create the core linkages: INTERACTION_ID links to the JTF_IH_INTERACTIONS table (Oracle Interaction Center), SALES_LEAD_ID links to the AS_SALES_LEADS table (Sales Lead Management), and IMPORT_INTERFACE_ID links to the AS_IMPORT_INTERFACE table, which is used for lead import processes. These columns collectively answer the fundamental business questions of which interaction prompted which lead and through which import mechanism, if applicable.

Common Use Cases and Queries

A primary use case is generating reports on lead source attribution. Analysts can query this table to measure campaign ROI by joining to interaction and lead data. For instance, to list all sales leads created from a specific marketing interaction, a common SQL pattern would join AML_INTERACTION_LEADS to AS_SALES_LEADS on the SALES_LEAD_ID. Another critical scenario involves data integrity checks and cleanup operations, where queries identify orphaned records—relationship entries where either the interaction or the lead no longer exists in their respective master tables. Troubleshooting lead import errors also frequently involves this table, using the IMPORT_INTERFACE_ID to trace issues back to a specific batch import job from the AS_IMPORT_INTERFACE table.

Related Objects

• JTF_IH_INTERACTIONS: The master table for customer interactions. The foreign key (INTERACTION_ID) links a lead to its originating contact event.
• AS_SALES_LEADS: The master table for sales lead data. The foreign key (SALES_LEAD_ID) links the relationship record to the actual lead being tracked.
• AS_IMPORT_INTERFACE: The interface table for importing lead data. The foreign key (IMPORT_INTERFACE_ID) indicates if the lead-relationship was created via a bulk import.
• AML_INTERACTION_LEADS_PK: The primary key constraint, uniquely identifying each record via the INTERACTION_LEAD_ID column.