Search Results ozf_act_metric_form_ent




Overview
Explore in AI Chat

Overview

The table OZF_ACT_METRIC_FORM_ENT is a core data object within the Oracle E-Business Suite (EBS) Trade Management module (OZF). It functions as the execution detail table for activity metric formulas. In the context of trade promotions and funds management, formulas are used to calculate complex performance metrics, accruals, or settlement amounts. This table stores the individual, sequential entries or steps that constitute a single formula. Each row represents a specific operation within the formula's logic, enabling the system to process multi-step calculations for trade activities and their associated financial metrics. Its role is to decompose a high-level formula definition into executable components, ensuring accurate and auditable calculation processing.

Key Information Stored

The table's primary purpose is to define the sequence and logic of formula steps. The key columns include FORMULA_ENTRY_ID, which serves as the unique primary key for each step. The FORMULA_ID is a critical foreign key column that links each entry back to its parent definition in the OZF_ACT_METRIC_FORMULAS table. Other significant columns, while not explicitly listed in the provided metadata, typically include data such as the entry sequence number (to define execution order), the operation type (e.g., add, multiply, apply a rule), operand values or references, and conditions for the step's execution. Collectively, these fields store the complete procedural logic that the Trade Management engine follows when evaluating a metric.

Common Use Cases and Queries

This table is primarily accessed for debugging formula calculations, generating audit trails, and creating detailed operational reports. A common use case involves tracing why a specific promotion accrual or claim settlement amount was calculated. Database administrators or functional consultants may query this table to understand the formula's construction or to verify data integrity. A typical analytical query would join this table to its parent to list all steps for a given formula.

  • Sample Query: To retrieve all execution steps for a specific formula, ordered by their sequence: SELECT entry.* FROM ozf_act_metric_form_ent entry WHERE entry.formula_id = :p_formula_id ORDER BY entry.sequence_num;
  • Reporting Use Case: Creating a report that maps all formulas used in a campaign to their detailed calculation steps, useful for compliance and business process documentation.

Related Objects

The table OZF_ACT_METRIC_FORM_ENT has a direct and essential relationship with the OZF_ACT_METRIC_FORMULAS table, as defined by its foreign key constraint. The parent table (OZF_ACT_METRIC_FORMULAS) holds the header-level definition of the formula, while this child table stores its decomposed instructions. This table is also intrinsically linked to the broader activity metric and funds management data model, likely referenced by the engine that executes these formulas during promotion lifecycle events like accrual generation and funds settlement. Understanding this object requires examining it in conjunction with its parent table to gain a complete view of the formula's definition and execution logic.