Search Results ozf_act_metrics_all_pk

Overview

The OZF_ACT_METRICS_ALL table is a core transactional table within the Oracle Trade Management module (OZF) of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the central repository for storing allocated budget or quota values associated with trade promotion funds and activities. This table is fundamental to the financial tracking and performance measurement of trade spending, enabling organizations to plan, allocate, and monitor funds against specific metrics, such as sales targets or promotional budgets. As an "ALL" table, it is designed to support multi-organization structures (Multi-Org), storing data partitioned by the operating unit context.

Key Information Stored

The table's primary purpose is to hold the quantitative allocation details for a fund or activity metric. While the provided metadata does not list all columns, the primary key and foreign key relationships indicate critical data points. The ACTIVITY_METRIC_ID is the unique identifier for each allocation record. The ACT_METRIC_USED_BY_ID links to the specific fund in the OZF_FUNDS_ALL_B table to which the budget or quota is assigned. The table stores currency information via FUNCTIONAL_CURRENCY_CODE and TRANSACTION_CURRENCY_CODE, which reference FND_CURRENCIES, indicating support for multi-currency transactions. The APPLICATION_ID links to FND_APPLICATION, tying the record to a specific EBS module. Other typical columns in such a table, though not explicitly listed, would include the allocated amount, metric type (budget vs. quota), period, and the standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN).

Common Use Cases and Queries

This table is central to financial reporting and analysis within Trade Management. Common use cases include generating fund utilization reports, analyzing budget versus actual spending, and ensuring quota compliance. For instance, to retrieve the allocated budget for a specific fund, a query would join OZF_ACT_METRICS_ALL to OZF_FUNDS_ALL_B. A typical reporting pattern involves aggregating allocated amounts by fund, period, or currency. Since this table feeds into metric facts and formulas, it is also crucial for calculating performance metrics and derived values used in promotional effectiveness analysis. Sample SQL to find allocations for a fund would be:

• SELECT fam.ACTIVITY_METRIC_ID, fam.ALLOCATED_AMOUNT, ff.FUND_NAME FROM OZF_ACT_METRICS_ALL fam, OZF_FUNDS_ALL_B ff WHERE fam.ACT_METRIC_USED_BY_ID = ff.FUND_ID AND ff.FUND_NUMBER = '<FUND_NUMBER>';

Related Objects

The OZF_ACT_METRICS_ALL table is a key hub with several documented relationships. It is the parent table for OZF_ACT_METRIC_FACTS_ALL and OZF_ACT_METRIC_FORMULAS, which store detailed transactional facts and calculation rules, respectively, for each activity metric (joined on ACTIVITY_METRIC_ID). It is a child table to several master data entities: it references OZF_FUNDS_ALL_B (via ACT_METRIC_USED_BY_ID) to identify the associated fund, and FND_CURRENCIES twice (for functional and transaction currency codes). It also maintains a referential link to FND_APPLICATION via APPLICATION_ID, defining the module context. The primary key constraint OZF_ACT_METRICS_ALL_PK ensures the uniqueness of the ACTIVITY_METRIC_ID column.