Results for “objective_type”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AMS_ACT_OBJECTIVES is a Marketing (AMS) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the objectives associated with a specific marketing activity, such as a Promotion, Media campaign, or Event. Each row represents one objective, optionally linked back to the parent activity via the ACT_OBJECTIVE_USED_BY_ID column, and optionally enriched with one or more measurable metrics through the downstream AMS_ACT_OBJ_METRICS table. This makes the table the transactional backbone for objective definition and objective-level measurement within the AMS activity lifecycle.

The ETRM relationship metadata classifies AMS_ACT_OBJECTIVES as satellite-leaning under a heuristic Data Vault model. In practice this suggests treating the table as a descriptive satellite attached to the owning activity hub (Event, Campaign, or Offer), carrying descriptive attributes and timestamps rather than acting as an independent hub or a pure link. Modeling it this way aligns with its role: it stores descriptive objective detail keyed to a business owner, not the business owner itself.

Key Information Stored

The table is physically defined with 29 columns in the AMS schema. The surrogate primary key is ACTIVITY_OBJECTIVE_ID, enforced by AMS_ACT_OBJECTIVES_PK and additionally guarded by the unique index AMS_ACT_OBJECTIVES_U1, making it both the PK and the documented business-key candidate. The most operationally significant columns are:

• ACTIVITY_OBJECTIVE_ID – surrogate primary key; joins to AMS_ACT_OBJ_METRICS.
• ACT_OBJECTIVE_USED_BY_ID – polymorphic foreign key referencing the owning activity; disambiguated by ARC_ACT_OBJECTIVE_USED_BY.
• ARC_ACT_OBJECTIVE_USED_BY – discriminator indicating which activity entity (Event, Campaign, or Offer) the ID refers to.
• OBJECTIVE_TYPE – categorizes the objective.
• DESCRIPTION – textual definition of the objective.
• RESULT_DESCRIPTION – narrative of the objective outcome or result.
• OBJECT_VERSION_NUMBER – optimistic concurrency control.
• SECURITY_GROUP_ID – multi-org/security group scoping, referencing FND_SECURITY_GROUPS.
• CREATION_DATE / CREATED_BY / LAST_UPDATE_DATE / LAST_UPDATED_BY / LAST_UPDATE_LOGIN – standard audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 – extensible descriptive flexfield storage.

The polymorphic ACT_OBJECTIVE_USED_BY_ID column maps to AMS_EVENT_HEADERS_ALL_B, AMS_CAMPAIGNS_ALL_B, or AMS_EVENT_OFFERS_ALL_B depending on the ARC_ACT_OBJECTIVE_USED_BY value.

Common Use Cases and Queries

Typical usage includes reporting objective definitions per activity, joining objective metrics for KPI dashboards, and auditing security-group scoping. A representative pattern resolves the owning activity through the discriminator:

• Objectives for a specific campaign: SELECT o.ACTIVITY_OBJECTIVE_ID, o.OBJECTIVE_TYPE, o.DESCRIPTION FROM AMS_ACT_OBJECTIVES o WHERE o.ACT_OBJECTIVE_USED_BY_ID = :campaign_id AND o.ARC_ACT_OBJECTIVE_USED_BY = 'CAMPAIGN';
• Objectives with their measured metrics: SELECT o.ACTIVITY_OBJECTIVE_ID, o.DESCRIPTION, m.* FROM AMS_ACT_OBJECTIVES o, AMS_ACT_OBJ_METRICS m WHERE o.ACTIVITY_OBJECTIVE_ID = m.ACTIVITY_OBJECTIVE_ID;
• Security-group audit: join SECURITY_GROUP_ID to FND_SECURITY_GROUPS.

Related Objects

• AMS_ACT_OBJ_METRICS – child table; join on ACTIVITY_OBJECTIVE_ID to retrieve objectives' metrics.
• AMS_EVENT_HEADERS_ALL_B – parent activity when ACT_OBJECTIVE_USED_BY_ID refers to an event.
• AMS_CAMPAIGNS_ALL_B – parent activity when the objective belongs to a campaign.
• AMS_EVENT_OFFERS_ALL_B – parent activity when the objective belongs to an event offer.
• FND_SECURITY_GROUPS – referenced via SECURITY_GROUP_ID for security scoping.