Results for “size_delta”

16 results




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

Overview

AMS_ACT_SIZES is a table owned by the AMS schema within the Oracle E-Business Suite Marketing (AMS) product family. As documented in the ETRM reference for releases 12.1.1 and 12.2.2, this table maintains the history of segments size. In practice, it serves as a historical record of the audience sizes produced by marketing activities, campaigns, and list-generation runs. Each time a segment is evaluated or refreshed, the resulting count (the activity size) is captured here, allowing marketers and analysts to track how a target audience has grown, shrunk, or otherwise changed over successive executions.

From a data-modeling perspective, the supplied metadata classifies AMS_ACT_SIZES with a heuristic Data Vault designation of standalone. This suggestion implies the table operates largely as an independent transactional record rather than as a strict hub, link, or satellite within a formal Data Vault model. Its single documented foreign key to FND_SECURITY_GROUPS indicates multi-org/security-group scoping rather than a dense web of referential dependencies, which supports the standalone classification.

Key Information Stored

The table contains 12 documented columns. The most significant are summarized below:

Common Use Cases and Queries

Typical usage centers on historical audience-size trending and campaign performance analysis. A common pattern joins the size history to the activity context and filters by delta to surface growth or shrinkage anomalies:

  • Trending a single activity's audience over time, ordered by CREATION_DATE.
  • Identifying segments with the largest positive or negative SIZE_DELTA.
  • Security-scoped reporting by joining SECURITY_GROUP_ID to FND_SECURITY_GROUPS.

Representative SQL:

SELECT ACTIVITY_SIZE_ID, ACT_SIZE, SIZE_DELTA, CREATION_DATE
FROM AMS.AMS_ACT_SIZES
WHERE ACT_SIZE_USED_BY_ID = :activity_id
ORDER BY CREATION_DATE DESC;

Related Objects

Because the documented relationship set is intentionally narrow, the most significant related object is the foreign-key target below; other dependencies (activity and segment definitions) are implied by the ACT_SIZE_USED_BY_ID and ARC_ACT_SIZE_USED_BY columns.

  • FND_SECURITY_GROUPS — Referenced by AMS_ACT_SIZES.SECURITY_GROUP_ID → FND_SECURITY_GROUPS, providing security-group scoping.
  • AMS_ACT_SIZES_PK1 / AMS_ACT_SIZES_U1 — The primary key constraint and unique index on ACTIVITY_SIZE_ID that anchor lookups.
  • Activity context objects — Tables identified through ACT_SIZE_USED_BY_ID, which resolve the marketing activity owning each size record.