Search Results ams_act_partners

Overview

AMS_ACT_PARTNERS is a marketing (AMS) module table in Oracle E-Business Suite that stores the participating partners associated with a marketing activity. In EBS 12.1.1 and 12.2.2, the table resides in the AMS schema and holds the linkage between a marketing activity context — a campaign, event header, or event offer — and the partner party defined in the trading community model. Activities in Oracle Marketing are frequently co-executed with channel partners, resellers, and agencies, and AMS_ACT_PARTNERS is the persistence point that records which of those parties participate, in what capacity, and whether a given partner is the primary participant for the activity.

From a data-modeling perspective, the mined foreign-key structure suggests this object functions as a link (associative) entity rather than a hub or satellite. The heuristic Data Vault classification is link: the row does not carry an independent business identity of its own but resolves a many-to-many relationship between a marketing activity (campaign, event header, or event offer) and an HZ_PARTIES partner record, with descriptive attributes attached to that association.

Key Information Stored

The surrogate primary key is ACTIVITY_PARTNER_ID, enforced by AMS_ACT_PARTNERS_PK and also covered by the unique index AMS_ACT_PARTNERS_U1, which makes it the documented business-key candidate for row-level addressing. The most significant business columns are:

ACT_PARTNER_USED_BY_ID — the activity-side identifier. This column carries the foreign-key relationship to AMS_CAMPAIGNS_ALL_B, AMS_EVENT_HEADERS_ALL_B, and AMS_EVENT_OFFERS_ALL_B, indicating the parent activity record for which the partner is registered.
ARC_ACT_PARTNER_USED_BY — an archive/context discriminator that disambiguates which of the parent activity tables the ACT_PARTNER_USED_BY_ID value refers to.
PARTNER_ID — the partner party, foreign-keyed to HZ_PARTIES; this is the trading-community-side of the association.
PARTNER_TYPE — classifies the role or category of the participating partner.
PARTNER_ADDRESS_ID and PRIMARY_CONTACT_ID — the partner's address and designated contact for the activity.
PRIMARY_FLAG — marks whether the partner is the primary participant for the activity.
DESCRIPTION and ATTRIBUTE_CATEGORY / ATTRIBUTE1–ATTRIBUTE15 — the standard EBS descriptive flexfield and free-text extensibility columns.
SECURITY_GROUP_ID — foreign-keyed to FND_SECURITY_GROUPS for multi-org/security-group data segregation.
PREFERRED_VAD_ID — the preferred address reference for the partner operating unit context.
LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER — the standard WHO columns and optimistic-locking version stamp.

Common Use Cases and Queries

Typical reporting scenarios include listing all partners attached to a campaign or event, identifying the primary partner for an activity, and reconciling activity participation against the HZ_PARTIES master. A representative query joins the activity identifier and the partner master:

Partners by campaign: SELECT ap.PARTNER_ID, ap.PARTNER_TYPE, ap.PRIMARY_FLAG FROM AMS.AMS_ACT_PARTNERS ap WHERE ap.ACT_PARTNER_USED_BY_ID = :campaign_id
Partner details: SELECT hp.PARTY_NAME, ap.PARTNER_TYPE FROM AMS.AMS_ACT_PARTNERS ap JOIN HZ_PARTIES hp ON hp.PARTY_ID = ap.PARTNER_ID
Primary partner drill-down: filter on PRIMARY_FLAG = 'Y' to surface the lead participant per activity.

These patterns support partner scorecarding, activity cost/participation reporting, and integration extracts feeding downstream CRM or partner-management systems.

Related Objects

AMS_CAMPAIGNS_ALL_B — joined via AMS_ACT_PARTNERS.ACT_PARTNER_USED_BY_ID; defines campaign activities that own partners.
AMS_EVENT_HEADERS_ALL_B — joined via ACT_PARTNER_USED_BY_ID; event activities that own partners.
AMS_EVENT_OFFERS_ALL_B — joined via ACT_PARTNER_USED_BY_ID; offer-level activities that own partners.
HZ_PARTIES — joined via AMS_ACT_PARTNERS.PARTNER_ID; the trading-community party master providing partner identity.
FND_SECURITY_GROUPS — joined via SECURITY_GROUP_ID; enforces security-group partitioning.

Collectively these relationships confirm AMS_ACT_PARTNERS as the activity-to-partner association link within Oracle Marketing.

Table: AMS_ACT_PARTNERS 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_ACT_PARTNERS, object_name:AMS_ACT_PARTNERS, status:VALID, product: AMS - Marketing , description: Holds the information about the participating partners for a marketing activity. , implementation_dba_data: AMS.AMS_ACT_PARTNERS ,
Table: AMS_ACT_PARTNERS 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_ACT_PARTNERS, object_name:AMS_ACT_PARTNERS, status:VALID, product: AMS - Marketing , description: Holds the information about the participating partners for a marketing activity. , implementation_dba_data: AMS.AMS_ACT_PARTNERS ,
APPS.AMS_ACTPARTNER_PVT SQL Statements 12.2.2
APPS.AMS_ACTPARTNER_PVT SQL Statements 12.1.1
VIEW: AMS.AMS_ACT_PARTNERS# 12.2.2
owner:AMS, object_type:VIEW, object_name:AMS_ACT_PARTNERS#, status:VALID,
SYNONYM: APPS.AMS_ACT_PARTNERS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:AMS_ACT_PARTNERS, status:VALID,
SYNONYM: APPS.AMS_ACT_PARTNERS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:AMS_ACT_PARTNERS, status:VALID,
VIEW: AMS.AMS_ACT_PARTNERS# 12.2.2
TABLE: AMS.AMS_ACT_PARTNERS 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_ACT_PARTNERS, object_name:AMS_ACT_PARTNERS, status:VALID,
TABLE: AMS.AMS_ACT_PARTNERS 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_ACT_PARTNERS, object_name:AMS_ACT_PARTNERS, status:VALID,
PACKAGE BODY: APPS.AMS_CPYUTILITY_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AMS_CPYUTILITY_PVT, status:VALID,
PACKAGE BODY: APPS.AMS_CPYUTILITY_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AMS_CPYUTILITY_PVT, status:VALID,
PACKAGE BODY: APPS.AMS_ACTPARTNER_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AMS_ACTPARTNER_PVT, status:VALID,
PACKAGE BODY: APPS.AMS_ACTPARTNER_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AMS_ACTPARTNER_PVT, status:VALID,
PACKAGE BODY: APPS.AMS_PARTY_MERGE_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AMS_PARTY_MERGE_PVT, status:VALID,
PACKAGE BODY: APPS.AMS_PARTY_MERGE_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AMS_PARTY_MERGE_PVT, status:VALID,
PACKAGE BODY: APPS.PV_BG_PARTNER_MATCHING_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PV_BG_PARTNER_MATCHING_PUB, status:VALID,
Table: AMS_EVENT_HEADERS_ALL_B 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_EVENT_HEADERS_ALL_B, object_name:AMS_EVENT_HEADERS_ALL_B, status:VALID, product: AMS - Marketing , description: Stores the definition of a Marketing Event. (Master Event or Event Template) , implementation_dba_data: AMS.AMS_EVENT_HEADERS_ALL_B ,
PACKAGE BODY: APPS.PV_BG_PARTNER_MATCHING_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PV_BG_PARTNER_MATCHING_PUB, status:VALID,
Table: AMS_EVENT_OFFERS_ALL_B 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_EVENT_OFFERS_ALL_B, object_name:AMS_EVENT_OFFERS_ALL_B, status:VALID, product: AMS - Marketing , description: Stores information about an Event Offering. .This table also holds the data for all the Agenda Items for the Event Offerings. , implementation_dba_data: AMS.AMS_EVENT_OFFERS_ALL_B ,
Table: AMS_EVENT_HEADERS_ALL_B 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_EVENT_HEADERS_ALL_B, object_name:AMS_EVENT_HEADERS_ALL_B, status:VALID, product: AMS - Marketing , description: Stores the definition of a Marketing Event. (Master Event or Event Template) , implementation_dba_data: AMS.AMS_EVENT_HEADERS_ALL_B ,
Table: AMS_EVENT_OFFERS_ALL_B 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_EVENT_OFFERS_ALL_B, object_name:AMS_EVENT_OFFERS_ALL_B, status:VALID, product: AMS - Marketing , description: Stores information about an Event Offering. .This table also holds the data for all the Agenda Items for the Event Offerings. , implementation_dba_data: AMS.AMS_EVENT_OFFERS_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 ,
PACKAGE BODY: APPS.AMS_COPYELEMENTS_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AMS_COPYELEMENTS_PVT, status:VALID,
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 ,
PACKAGE BODY: APPS.AMS_COPYELEMENTS_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AMS_COPYELEMENTS_PVT, status:VALID,
APPS.AMS_COPYELEMENTS_PVT SQL Statements 12.1.1
PACKAGE BODY: APPS.AMS_ACTPARTNER_PVT 12.2.2
APPS.AMS_COPYELEMENTS_PVT SQL Statements 12.2.2
PACKAGE BODY: APPS.AMS_ACTPARTNER_PVT 12.1.1
PACKAGE BODY: APPS.HZ_PURGE_GEN 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:HZ_PURGE_GEN, status:VALID,
PACKAGE BODY: APPS.HZ_PURGE_GEN 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:HZ_PURGE_GEN, status:VALID,
12.2.2 DBA Data 12.2.2
APPS.AMS_PARTY_MERGE_PVT SQL Statements 12.1.1
APPS.AMS_PARTY_MERGE_PVT SQL Statements 12.2.2
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
APPS.AMS_CPYUTILITY_PVT SQL Statements 12.2.2
APPS.AMS_CPYUTILITY_PVT SQL Statements 12.1.1
12.2.2 FND Design Data 12.2.2
12.1.1 FND Design Data 12.1.1
APPS.PV_BG_PARTNER_MATCHING_PUB SQL Statements 12.1.1
APPS.PV_BG_PARTNER_MATCHING_PUB SQL Statements 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
APPS.PV_BG_PARTNER_MATCHING_PUB dependencies on AMS_ACT_PARTNERS 12.2.2
APPS.AMS_ACTPARTNER_PVT dependencies on AMS_ACT_PARTNERS 12.2.2