Results for “forecast_remaining_quantity”

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

Overview

AMS_ACT_METRIC_FACTS_ALL is an Oracle Marketing (AMS) transactional table that stores measured or forecasted metric values for marketing activities across a defined set of analytical dimensions. Its documented purpose is to hold metric values so they can be forecast over time by dimensions such as geography, product, campaign, and time period. In Oracle EBS 12.1.1 and 12.2.2 the table resides in the AMS schema and is flagged VALID. Physically, the 12.2.2 schema documents 103 columns, reflecting a wide, denormalized analytical layout oriented toward time-series forecasting rather than normalized operational capture.

The heuristic Data Vault classification mined from the foreign key structure models this object as a link. This is a modeling suggestion rather than a native Data Vault implementation: the table sits at the intersection of multiple reference entities (metric definitions, campaigns, geographic areas, and products), and its grain is a single measured fact tied to those dimensions. The surrogate primary key is AMS_ACT_METRIC_FACTS_ALL_PK, defined on ACTIVITY_METRIC_FACT_ID.

Key Information Stored

• ACTIVITY_METRIC_FACT_ID — surrogate primary key and the identifier most often sought in searches; also the basis of unique index AMS_ACT_METRIC_FACTS_ALL_U1.
• ACTIVITY_METRIC_ID — foreign key to AMS_ACT_METRICS_ALL, identifying the metric definition being measured.
• ACT_METRIC_USED_BY_ID — foreign key to AMS_CAMPAIGNS_ALL_B, associating the fact with the campaign that consumes the metric.
• ACTIVITY_GEO_AREA_ID and ACTIVITY_PRODUCT_ID — foreign keys to AMS_ACT_GEO_AREAS and AMS_ACT_PRODUCTS, providing the geographic and product dimensions of the fact.
• FACT_VALUE and FACT_PERCENT — the core numeric measure and its percentage representation.
• TRANS_FORECASTED_VALUE and FUNC_FORECASTED_VALUE — forecasted amounts in transaction and functional currency, keyed by TRANSACTION_CURRENCY_CODE and FUNCTIONAL_CURRENCY_CODE.
• TIME_ID1 through TIME_ID53 — a repeating set of time dimension slots enabling period-by-period forecasting across the documented time axis.
• FORMULA_ID and VALUE_TYPE — identify the calculation formula and the type of value stored.
• FROM_DATE and TO_DATE — the effective window of the fact.
• ORG_ID and SECURITY_GROUP_ID — multi-org and security-group scoping (the latter referencing FND_SECURITY_GROUPS).
• ROOT_FACT_ID and PREVIOUS_FACT_ID — support fact lineage and versioning.
• STATUS_CODE and FACT_TYPE — lifecycle and categorization attributes.
• Standard audit columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, OBJECT_VERSION_NUMBER).

Common Use Cases and Queries

Typical reporting joins the fact to its metric definition and consuming campaign to produce forecast-versus-actual analyses. For example, retrieving facts by metric and campaign:

• SELECT f.ACTIVITY_METRIC_FACT_ID, f.FACT_VALUE, f.FACT_PERCENT, f.FUNC_FORECASTED_VALUE FROM AMS.AMS_ACT_METRIC_FACTS_ALL f JOIN AMS.AMS_ACT_METRICS_ALL m ON f.ACTIVITY_METRIC_ID = m.ACTIVITY_METRIC_ID WHERE f.ACT_METRIC_USED_BY_ID = :campaign_id;
• Dimension rollups by geography and product using ACTIVITY_GEO_AREA_ID and ACTIVITY_PRODUCT_ID.
• Time-series extraction across the TIME_ID columns to build period forecasts within FROM_DATE and TO_DATE.
• Multi-org reports filtered by ORG_ID and secured by SECURITY_GROUP_ID.
• Lineage tracing via ROOT_FACT_ID and PREVIOUS_FACT_ID to reconstruct fact history.

Related Objects

• AMS_ACT_METRICS_ALL — join on ACTIVITY_METRIC_ID; defines the metric being measured.
• AMS_CAMPAIGNS_ALL_B — join on ACT_METRIC_USED_BY_ID; identifies the consuming campaign.
• AMS_ACT_GEO_AREAS — join on ACTIVITY_GEO_AREA_ID; supplies geographic dimension.
• AMS_ACT_PRODUCTS — join on ACTIVITY_PRODUCT_ID; supplies product dimension.
• FND_SECURITY_GROUPS — join on SECURITY_GROUP_ID; governs row-level security.

These relationships confirm the object's role as a dimensional fact link at the center of the marketing forecasting model.