Results for “base_quantity”

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

Overview

AMS_ACT_FORECASTS_ALL (owner: AMS) is a Marketing module table that stores the forecast lines planned for a marketing activity. Each row represents a forecasted quantity for a specific activity, forecast type, period, and unit of measure, together with the supporting base-quantity, forward-buy, and quota information used by the activity forecasting engine. In Oracle EBS 12.1.1 and 12.2.2 the table participates in the multi-org data model: ORG_ID and SECURITY_GROUP_ID are present, while the ALL suffix indicates that the physical table is partitioned by operating unit through the standard _ALL synonym and policy infrastructure. The table carries the standard 11 concurrent-program audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID), OBJECT_VERSION_NUMBER for optimistic locking, and a DESCRIPTIVE_FLEXFIELD-style CONTEXT/ATTRIBUTE1-15 block for extensibility.

Based on the foreign-key topology, ETRM classification suggests this object is best modeled as a satellite-leaning entity: it holds many descriptive, forecast-specific attributes that depend on a single primary key and reference higher-level business entities (campaigns, security groups) rather than acting as a link between them. Treat FORECAST_ID as the natural business key in a Data Vault satellite design.

Key Information Stored

The primary key is FORECAST_ID, enforced by AMS_ACT_FORECASTS_ALL_PK and also mirrored by the unique index AMS_ACT_FORECASTS_ALL_U1, making FORECAST_ID both the surrogate and business-key candidate. The most significant columns are:

• FORECAST_ID — unique identifier for the forecast line; parent key for dependent cost records.
• FORECAST_TYPE — classifies the forecast (for example, activity forecast vs. base/forward-buy forecast).
• ACT_FCAST_USED_BY_ID / ARC_ACT_FCAST_USED_BY — the campaign or activity that consumes the forecast; ACT_FCAST_USED_BY_ID carries the FK to AMS_CAMPAIGNS_ALL_B.
• FORECAST_DATE, FORECAST_PERIOD_ID, PERIOD_LEVEL, FORECAST_CALENDAR — time dimension of the forecast, tying periods to a calendar.
• FORECAST_QUANTITY, FORECAST_REMAINING_QUANTITY, FORECAST_REMAINING_PERCENT — planned quantity versus remaining (unconsumed) quantity and percentage.
• BASE_QUANTITY, BASE_QUANTITY_TYPE, BASE_QUANTITY_START_DATE, BASE_QUANTITY_END_DATE, BASE_QUANTITY_REF — the baseline volume and its validity window.
• FORWARD_BUY_QUANTITY, FORWARD_BUY_PERIOD, CUMULATION_PERIOD_CHOICE, FORECAST_SPREAD_TYPE — forward-buy and spread logic used to distribute forecast quantities across periods.
• FORECAST_UOM_CODE — unit of measure for the forecasted quantities.
• HIERARCHY, HIERARCHY_LEVEL, LEVEL_VALUE — position within the activity or product hierarchy.
• INCREMENT_QUOTA, FREEZE_FLAG, FORECAST_GEN_PROGRESS, LAST_SCENARIO_ID — quota and lifecycle control flags used during generation and freezing.
• PRICE_LIST_ID, COMMENTS, DIMENTION1-3 — pricing reference and analytical dimensions.
• ORG_ID, SECURITY_GROUP_ID — multi-org and security-group scope; SECURITY_GROUP_ID references FND_SECURITY_GROUPS.
• CONTEXT, ATTRIBUTE_CATEGORY, ATTRIBUTE1-15 — descriptive flexfield columns.

Common Use Cases and Queries

Typical usage is forecasting and campaign planning: retrieving all forecast lines for a given activity, comparing planned to remaining quantities, and reporting forecast consumption by period. A representative join to the parent campaign is:

• SELECT f.FORECAST_ID, f.FORECAST_DATE, f.FORECAST_QUANTITY, f.FORECAST_REMAINING_QUANTITY FROM AMS.AMS_ACT_FORECASTS_ALL f, AMS.AMS_CAMPAIGNS_ALL_B c WHERE f.ACT_FCAST_USED_BY_ID = c.CAMPAIGN_ID;
• Filter by ORG_ID and SECURITY_GROUP_ID to respect multi-org and security-group visibility in reporting.
• Aggregate FORECAST_QUANTITY by FORECAST_PERIOD_ID, FORECAST_CALENDAR, or HIERARCHY_LEVEL for period-level and hierarchy roll-ups.
• Track generation status with FORECAST_GEN_PROGRESS and FREEZE_FLAG for batch forecast runs.

Related Objects

• AMS_CAMPAIGNS_ALL_B — referenced via AMS_ACT_FORECASTS_ALL.ACT_FCAST_USED_BY_ID; the campaign that uses the forecast.
• AMS_MISC_COST_DIS_ALL_B — references this table through FORECAST_ID, holding associated miscellaneous cost/discount detail.
• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID for data security.
• AMS_ACT_FORECASTS_ALL_PK / AMS_ACT_FORECASTS_ALL_U1 — primary key constraint and unique index on FORECAST_ID.
• ORG_ID-related org objects — operating-unit and security-group views used by the _ALL synonym layer.