Search Results ams_act_lists

Overview

The AMS_ACT_LISTS 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 serves as the central repository for storing detailed information about Target Groups and Invite Lists. In the context of marketing campaigns and events, these lists define the specific audience or recipients for marketing activities. The table functions as a junction or detail table, linking list definitions to the specific campaigns, schedules, or event offers where they are utilized. Its primary role is to manage the association between a list's header information and the various marketing objects that consume it, enabling precise targeting and audience management.

Key Information Stored

The table's structure is designed to establish and track these critical relationships. While the full column list is not provided in the metadata, the documented foreign keys and primary key reveal its essential components. The primary key, ACT_LIST_HEADER_ID, uniquely identifies each record in this table. Two foreign key relationships are explicitly defined. The LIST_HEADER_ID column links to the AMS_LIST_HEADERS_ALL table, connecting the list usage instance to the master definition of the list itself. The LIST_USED_BY_ID column is a polymorphic foreign key that links the list to the specific marketing object employing it, which can be either a campaign schedule (AMS_CAMPAIGN_SCHEDULES_B) or an event offer (AMS_EVENT_OFFERS_ALL_B). This design allows a single list definition to be reused across multiple marketing executions.

Common Use Cases and Queries

This table is central to reporting and auditing list usage across marketing initiatives. Common operational queries involve identifying all campaigns or events that target a specific audience list, or conversely, listing all target groups associated with a particular campaign schedule. For example, a report to find the usage details for a specific list header would join AMS_ACT_LISTS to both its parent and child tables. Sample SQL patterns often include filtering on the LIST_USED_BY_ID and joining to AMS_LIST_HEADERS_ALL for list details, and then to either AMS_CAMPAIGN_SCHEDULES_B or AMS_EVENT_OFFERS_ALL_B based on context to retrieve the marketing object name and details. Data integrity checks also frequently query this table to ensure all list references point to valid parent records.

Related Objects

The AMS_ACT_LISTS table sits at the intersection of several key AMS entities. Its most direct relationships, as per the provided metadata, are:

• AMS_LIST_HEADERS_ALL: The master table for list definitions. AMS_ACT_LISTS.LIST_HEADER_ID is a foreign key to this table.
• AMS_CAMPAIGN_SCHEDULES_B: A core table for campaign scheduling. Records in AMS_ACT_LISTS where the list is used by a campaign schedule reference this table via LIST_USED_BY_ID.
• AMS_EVENT_OFFERS_ALL_B: The base table for event offers. Records where the list is used by an event offer reference this table via LIST_USED_BY_ID.

This network of relationships underscores the table's critical function in connecting audience management (lists) with execution management (campaigns and events) within the Marketing module.