Results for “act_size”
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:
- ACTIVITY_SIZE_ID — The surrogate primary key, enforced by constraint AMS_ACT_SIZES_PK1 and also carried by the unique index AMS_ACT_SIZES_U1. This is the single business-key candidate documented for the table.
- ACT_SIZE_USED_BY_ID and ARC_ACT_SIZE_USED_BY — Columns describing the owning/using activity context and its archival counterpart, indicating which activity the recorded size pertains to.
- ACT_SIZE — The measured size (count) of the segment/activity audience at the time of capture.
- SIZE_DELTA — The change in size relative to a prior measurement, enabling trend and variance reporting without recomputation.
- DESCRIPTION — Free-text description of the size record.
- SECURITY_GROUP_ID — The security group scoping column, establishing the documented foreign key to FND_SECURITY_GROUPS.
- Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN provide the standard EBS WHO-column audit trail.
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.
-
This table maintains the history of segments size.
-
This table maintains the history of segments size.
-
VIEW: AMS.AMS_ACT_SIZES# 12.2.2
-
VIEW: AMS.AMS_ACT_SIZES# 12.2.2
-
TABLE: AMS.AMS_ACT_SIZES 12.1.1
-
TABLE: AMS.AMS_ACT_SIZES 12.2.2
-
eTRM - AMS Tables and Views 12.2.2
This table is used to store tracking data for web advertisement and offer type schedules
-
eTRM - AMS Tables and Views 12.1.1
This table is used to store tracking data for web advertisement and offer type schedules