Search Results activity_metric_fact_id

Overview

The OZF_ACT_METRIC_FACTS_ALL table is a core transactional data store within the Oracle Trade Management (OZF) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. Its primary function is to store granular, detailed allocation values for individual nodes within a trade promotion or marketing activity's hierarchical structure. This table operates as a child or detail table to the activity metric definitions, enabling the precise tracking and measurement of performance, such as funds, quantities, or costs, against specific products, customers, or other allocation entities. It is a multi-org table, as indicated by the "_ALL" suffix, meaning it stores data for all operating units.

Key Information Stored

The table's structure is designed to capture detailed allocation facts linked to a parent activity metric. The most critical column is the primary key, ACTIVITY_METRIC_FACT_ID, which uniquely identifies each detailed allocation record. Another essential foreign key column is ACTIVITY_METRIC_ID, which links each fact record to its parent definition in the OZF_ACT_METRICS_ALL table. While the full column list is not detailed in the provided metadata, based on its described purpose, the table typically contains columns for the allocated value (e.g., amount, quantity), the node identifier for the specific product or customer, and potentially columns for period, currency, and status. The table's primary key constraint is named OZF_ACT_METRIC_FACTS_ALL_PK.

Common Use Cases and Queries

This table is central to reporting and analytics on trade promotion performance and fund utilization. Common use cases include generating detailed reports on how a promotion's budget (the activity metric) was allocated and consumed across different product lines or customer segments. A typical query would join this fact table to its parent metric table and related dimension tables to analyze allocations.

• Sample Query Pattern: Retrieving all allocation details for a specific activity metric.
  SELECT fact.* FROM ozf_act_metric_facts_all fact WHERE fact.activity_metric_id = :p_metric_id;
• Reporting Use Case: A report showing the planned versus actual allocated spend per product for a marketing campaign would source the detailed allocation values from this table.
• Data Validation: Queries against this table are used to validate that the sum of detailed allocation facts rolls up correctly to the total defined in the parent OZF_ACT_METRICS_ALL record.

Related Objects

The OZF_ACT_METRIC_FACTS_ALL table has defined relationships with several other key Trade Management objects, as per the provided metadata.

• OZF_ACT_METRICS_ALL: This is the primary parent table. The foreign key on ACTIVITY_METRIC_ID enforces that every detail allocation fact must belong to a valid activity metric header.
• OZF_PRODUCT_ALLOCATIONS: This table references OZF_ACT_METRIC_FACTS_ALL via its ALLOCATION_FOR_ID column. This relationship suggests that product allocation records are created or associated with the detailed metric facts stored in this table, likely for managing product-specific funding or targets within a promotion.

Given its role, this table is also likely referenced by various Trade Management reports, online screens, and the OZF Trade Planning and OZF Funds Management APIs for creating, updating, and querying detailed allocation data.