Search Results ams_campaign_schedules

Overview

The AMS_CAMPAIGN_SCHEDULES table is a historical data object within the Oracle E-Business Suite (EBS) Marketing (AMS) module. According to the official ETRM documentation for versions 12.1.1 and 12.2.2, this table is explicitly marked as obsoleted and no longer in use. It was originally designed to manage scheduling information for marketing campaigns, acting as a central junction table that linked campaigns to their associated activities, deliverables, and statuses. Its role was to facilitate the planning and execution timeline of marketing initiatives. However, its functionality has been superseded by other application features or tables in later releases, rendering it a legacy artifact within the database schema.

Key Information Stored

While the table is obsolete, its structure reveals the type of scheduling data it was intended to manage. The primary key, CAMPAIGN_SCHEDULE_ID, uniquely identified each schedule record. Critical foreign key columns linked the schedule to core marketing entities: CAMPAIGN_ID (to AMS_CAMPAIGNS_ALL_B), ACTIVITY_OFFER_ID (to AMS_ACT_OFFERS), DELIVERABLE_ID (to AMS_DELIVERABLES_ALL_B), and USER_STATUS_ID (to AMS_USER_STATUSES_B). These columns indicate the table stored references to the specific campaign, its associated offer activity, the deliverable (e.g., an email or advertisement), and the current workflow status of the schedule.

Common Use Cases and Queries

As a deprecated table, there are no current operational use cases for AMS_CAMPAIGN_SCHEDULES in a standard Oracle EBS implementation. Direct interaction with this table for reporting or data manipulation is strongly discouraged, as the application logic no longer maintains it. Any historical data present would be for archival purposes only. Sample queries are provided strictly for understanding its past structure, such as identifying legacy schedule records for a specific campaign: SELECT * FROM AMS.AMS_CAMPAIGN_SCHEDULES WHERE CAMPAIGN_ID = <campaign_id>;. For any active scheduling requirements, consultants must refer to the current, supported tables and APIs within the Oracle Marketing module.

Related Objects

The foreign key relationships documented in the ETRM metadata illustrate the table's former integration points within the Marketing schema. Key related objects include:

AMS_CAMPAIGNS_ALL_B: Linked via AMS_CAMPAIGN_SCHEDULES.CAMPAIGN_ID.
AMS_ACT_OFFERS: Linked via AMS_CAMPAIGN_SCHEDULES.ACTIVITY_OFFER_ID.
AMS_USER_STATUSES_B: Linked via AMS_CAMPAIGN_SCHEDULES.USER_STATUS_ID.
AMS_DELIVERABLES_ALL_B: Linked via AMS_CAMPAIGN_SCHEDULES.DELIVERABLE_ID.
AMS_ACT_METRICS_ALL: References the schedule via AMS_ACT_METRICS_ALL.ACT_METRIC_USED_BY_ID.
AMS_ACT_SCRIPTS: References the schedule via AMS_ACT_SCRIPTS.ACT_SCRIPT_USED_BY_ID.
AMS_IBA_CAMP_POSTINGS: References the schedule via AMS_IBA_CAMP_POSTINGS.OBJECT_ID.
AMS_LIST_HEADERS_ALL: References the schedule via AMS_LIST_HEADERS_ALL.LIST_USED_BY_ID.

These relationships show the table was once a hub connecting campaigns to metrics, scripts, postings, and target lists.

Table: AMS_CAMPAIGN_SCHEDULES 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_CAMPAIGN_SCHEDULES, object_name:AMS_CAMPAIGN_SCHEDULES, status:VALID, product: AMS - Marketing , description: This table is obsoleted and no longer in use. , implementation_dba_data: AMS.AMS_CAMPAIGN_SCHEDULES ,
Table: AMS_CAMPAIGN_SCHEDULES 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_CAMPAIGN_SCHEDULES, object_name:AMS_CAMPAIGN_SCHEDULES, status:VALID, product: AMS - Marketing , description: This table is obsoleted and no longer in use. , implementation_dba_data: AMS.AMS_CAMPAIGN_SCHEDULES ,
Table: AMS_IBA_CAMP_POSTINGS 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_IBA_CAMP_POSTINGS, object_name:AMS_IBA_CAMP_POSTINGS, status:VALID, product: AMS - Marketing , description: Postings associated with campaigns. , implementation_dba_data: AMS.AMS_IBA_CAMP_POSTINGS ,
Table: AMS_ACT_SCRIPTS 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_ACT_SCRIPTS, object_name:AMS_ACT_SCRIPTS, status:VALID, product: AMS - Marketing , description: Stores the Scripts ( Inbound / Outbound ) used by a marketing activity. , implementation_dba_data: AMS.AMS_ACT_SCRIPTS ,
Table: AMS_IBA_CAMP_POSTINGS 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_IBA_CAMP_POSTINGS, object_name:AMS_IBA_CAMP_POSTINGS, status:VALID, product: AMS - Marketing , description: Postings associated with campaigns. , implementation_dba_data: AMS.AMS_IBA_CAMP_POSTINGS ,
Table: AMS_ACT_SCRIPTS 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_ACT_SCRIPTS, object_name:AMS_ACT_SCRIPTS, status:VALID, product: AMS - Marketing , description: Stores the Scripts ( Inbound / Outbound ) used by a marketing activity. , implementation_dba_data: AMS.AMS_ACT_SCRIPTS ,
Table: AMS_ACT_OFFERS 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_ACT_OFFERS, object_name:AMS_ACT_OFFERS, status:VALID, product: AMS - Marketing , description: Holds the high level details of promotional offers related to a campaign , implementation_dba_data: AMS.AMS_ACT_OFFERS ,
Table: AMS_ACT_OFFERS 12.2.2
product: AMS - Marketing , description: Holds the high level details of promotional offers related to a campaign , implementation_dba_data: Not implemented in this database ,
Table: AMS_USER_STATUSES_B 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_USER_STATUSES_B, object_name:AMS_USER_STATUSES_B, status:VALID, product: AMS - Marketing , description: Stores User status information , implementation_dba_data: AMS.AMS_USER_STATUSES_B ,
Table: AMS_LIST_HEADERS_ALL 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_LIST_HEADERS_ALL, object_name:AMS_LIST_HEADERS_ALL, status:VALID, product: AMS - Marketing , description: This table stores the name and other details about a target list. , implementation_dba_data: AMS.AMS_LIST_HEADERS_ALL ,
Table: AMS_LIST_HEADERS_ALL 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_LIST_HEADERS_ALL, object_name:AMS_LIST_HEADERS_ALL, status:VALID, product: AMS - Marketing , description: This table stores the name and other details about a target list. , implementation_dba_data: AMS.AMS_LIST_HEADERS_ALL ,
Table: AMS_USER_STATUSES_B 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_USER_STATUSES_B, object_name:AMS_USER_STATUSES_B, status:VALID, product: AMS - Marketing , description: Stores User status information , implementation_dba_data: AMS.AMS_USER_STATUSES_B ,
Table: AMS_ACT_METRICS_ALL 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_ACT_METRICS_ALL, object_name:AMS_ACT_METRICS_ALL, status:VALID, product: AMS - Marketing , description: This table stores the value for a metrics being tracked against a marketing entity e.g. the current value for metrics 'ROI' for a specific marketing campaign. , implementation_dba_data: AMS.AMS_ACT_METRICS_ALL ,
Table: AMS_ACT_METRICS_ALL 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_ACT_METRICS_ALL, object_name:AMS_ACT_METRICS_ALL, status:VALID, product: AMS - Marketing , description: This table stores the value for a metrics being tracked against a marketing entity e.g. the current value for metrics 'ROI' for a specific marketing campaign. , implementation_dba_data: AMS.AMS_ACT_METRICS_ALL ,
Table: AMS_DELIVERABLES_ALL_B 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_DELIVERABLES_ALL_B, object_name:AMS_DELIVERABLES_ALL_B, status:VALID, product: AMS - Marketing , description: This table stores the details about marketing deliverables/collaterals, collaterals are uniquely identified by deliverable name, language and version. , implementation_dba_data: AMS.AMS_DELIVERABLES_ALL_B ,
Table: AMS_DELIVERABLES_ALL_B 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_DELIVERABLES_ALL_B, object_name:AMS_DELIVERABLES_ALL_B, status:VALID, product: AMS - Marketing , description: This table stores the details about marketing deliverables/collaterals, collaterals are uniquely identified by deliverable name, language and version. , implementation_dba_data: AMS.AMS_DELIVERABLES_ALL_B ,
Table: AMS_CAMPAIGNS_ALL_B 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_CAMPAIGNS_ALL_B, object_name:AMS_CAMPAIGNS_ALL_B, status:VALID, product: AMS - Marketing , description: Base table to store the details of a campaign. , implementation_dba_data: AMS.AMS_CAMPAIGNS_ALL_B ,
Table: AMS_CAMPAIGNS_ALL_B 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_CAMPAIGNS_ALL_B, object_name:AMS_CAMPAIGNS_ALL_B, status:VALID, product: AMS - Marketing , description: Base table to store the details of a campaign. , implementation_dba_data: AMS.AMS_CAMPAIGNS_ALL_B ,