Search Results ams_iba_campaign_rules_u1

Overview

The AMS.AMS_IBA_CAMPAIGN_RULES table is a core data structure within the Oracle E-Business Suite (EBS) Marketing (AMS) module, specifically for versions 12.1.1 and 12.2.2. It functions as a junction or mapping table that establishes relationships between marketing campaigns and the business rules that govern their execution. Its primary role is to associate display rules (from the Intelligent Banner Ad framework) with specific marketing campaigns and activity offers, thereby defining the conditional logic for campaign targeting and content presentation. The table's storage in the APPS_TS_ARCHIVE tablespace and the documented warning indicate it is an internal applications table, and direct data manipulation outside of standard Oracle Applications programs is unsupported.

Key Information Stored

The table stores relationship metadata and standard EBS audit columns. The most critical columns are the foreign keys that define the relationships and the qualifier type. The primary identifier is the CAMPAIGN_RULE_ID, which is enforced by a unique index (AMS_IBA_CAMPAIGN_RULES_U1). Key transactional columns include RULE_ID, which references a specific display rule; CAMPAIGN_ID, linking to a marketing campaign; and ACTIVITY_OFFER_ID, associating the rule with a particular offer. The QUALIFIER_TYPE column is significant for determining the context or classification of the rule association. Standard EBS columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER, SECURITY_GROUP_ID) manage record lifecycle, auditing, and multi-org security.

Common Use Cases and Queries

This table is central to queries that analyze the rule-based logic applied to marketing campaigns. A common use case is auditing all rules associated with a specific campaign for validation or impact analysis. Another is identifying which campaigns and offers utilize a particular display rule, which is essential for change management. Reporting often involves joining this table to its referenced master tables to produce human-readable lists.

• Sample Query: Find all rules for a campaign:
  SELECT cr.*, r.rule_name, c.campaign_name
  FROM ams.ams_iba_campaign_rules cr,
       ams.ams_iba_display_rules r,
       ams.ams_campaigns_all_b c
  WHERE cr.campaign_id = :p_campaign_id
  AND cr.rule_id = r.rule_id
  AND cr.campaign_id = c.campaign_id;
• Sample Query: List campaigns using a specific rule:
  SELECT campaign_id, qualifier_type
  FROM ams.ams_iba_campaign_rules
  WHERE rule_id = :p_rule_id;

Related Objects

The table's integrity is defined by its primary key and its foreign key relationships to central marketing entities, as documented in the provided relationship data.

• Primary Key: AMS_IBA_CAMPAIGN_RULES_PK (CAMPAIGN_RULE_ID)
• Foreign Key References (Child of):
  • TABLE: AMS.AMS_IBA_DISPLAY_RULES via column RULE_ID
  • TABLE: AMS.AMS_CAMPAIGNS_ALL_B via column CAMPAIGN_ID
  • TABLE: AMS.AMS_ACT_OFFERS via column ACTIVITY_OFFER_ID
• Indexes: The table has one unique index (U1) on CAMPAIGN_RULE_ID and three non-unique indexes (N1 on CAMPAIGN_ID, RULE_ID; N2 on RULE_ID; N3 on ACTIVITY_OFFER_ID) to optimize query performance on these key foreign key columns.