Search Results ast_grp_campaigns




Overview
Explore in AI Chat

Overview

AST_GRP_CAMPAIGNS is a TeleSales (AST) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the mapping between resource groups and campaigns. Its documented purpose is precisely this association: it records which resource groups — teams of TeleSales agents or telesales representatives — are assigned to which marketing campaigns. In practice, this makes the table the operational bridge between campaign definitions owned by Oracle Marketing (AMS) and the resource hierarchy owned by Oracle Resource Manager (JTF/RS).

From a Data Vault modeling perspective, the FK structure mined from the metadata suggests this object behaves as a link table. It resolves a many-to-many relationship between two business entities — campaigns and resource groups — and carries descriptive attributes (START_DATE, END_DATE, ENABLED_FLAG) that qualify the association rather than defining either entity independently. The table is therefore best understood as an associative/intersection entity, not a hub or satellite.

Key Information Stored

The table contains 12 documented columns. The most significant include:

The business-key candidate is GROUP_CAMPAIGN_ID via AST_GRP_CAMPAIGNS_U1; the true logical uniqueness typically rests on the combination of GROUP_ID and CAMPAIGN_ID together with the date range.

Common Use Cases and Queries

Typical uses include identifying which telesales teams are assigned to a campaign, reporting campaign coverage by resource group, and validating agent eligibility during call handling. A common join pattern is:

  • Join AST_GRP_CAMPAIGNS.GROUP_ID to JTF_RS_GROUPS_B.GROUP_ID to retrieve group names.
  • Join AST_GRP_CAMPAIGNS.CAMPAIGN_ID to AMS_CAMPAIGNS_ALL_B.CAMPAIGN_ID (or its _TL/_B counterpart) for campaign details.
  • Filter on ENABLED_FLAG = 'Y' and SYSDATE BETWEEN START_DATE AND END_DATE for active mappings.

Reporting queries often aggregate the count of distinct GROUP_ID values per CAMPAIGN_ID to measure campaign staffing breadth, or conversely count campaigns per group to assess workload.

Related Objects

The most significant related objects, derived from the documented FK relationships, are:

  • AMS_CAMPAIGNS_ALL_B — joined on CAMPAIGN_ID; the campaign master table.
  • JTF_RS_GROUPS_B — joined on GROUP_ID; the resource group master table.
  • FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID; governs data security partitioning.
  • JTF_RS_GROUP_MEMBERS and JTF_RS_RESOURCE_EXTNS — used downstream to expand a group to its individual resources for agent-level reporting.

These relationships confirm AST_GRP_CAMPAIGNS as a central associative table linking Oracle Marketing campaign definitions to Resource Manager group definitions within the TeleSales application.