Search Results formula_entry_id




Overview
Explore in AI Chat

Overview

The AMS_ACT_METRIC_FORM_ENT table is a core data object within the Oracle E-Business Suite Marketing (AMS) module, specifically for versions 12.1.1 and 12.2.2. It functions as a repository for the individual components that constitute a formula used in marketing campaign analysis. In the context of Oracle Marketing, formulas are critical for calculating key performance metrics, such as return on investment (ROI), conversion rates, or cost per lead, for marketing activities and campaigns. This table stores the set of executable entries that define the calculation logic for these formulas. Its role is to provide the structural definition for how a complex metric is computed, linking the abstract formula to the specific data points and operations required for its execution.

Key Information Stored

The table's primary purpose is to define the sequence and logic of a formula's calculation. The key column is FORMULA_ENTRY_ID, which serves as the unique primary key for each entry row. The most critical relational column is FORMULA_ID, a foreign key that links each entry to its parent definition in the AMS_ACT_METRIC_FORMULAS table. While the provided metadata does not list all columns, typical data stored in such a structure includes the order of execution (e.g., SEQUENCE_NUMBER), the type of operation or operand (e.g., OPERATOR, METRIC_ID, CONSTANT_VALUE), and references to other metrics or database values. Each row in this table represents a single step—such as adding two metrics, multiplying by a constant, or applying a function—in the overall formula calculation.

Common Use Cases and Queries

This table is primarily accessed for formula definition, validation, and execution. Common use cases include troubleshooting incorrect metric calculations by reviewing the formula's construction, or cloning complex formulas for new campaign types. A typical query would join this table to the parent formula table to retrieve the complete calculation logic. For example:

  • To list all entries for a specific formula: SELECT * FROM AMS.AMS_ACT_METRIC_FORM_ENT WHERE FORMULA_ID = <id> ORDER BY SEQUENCE_NUMBER;
  • To analyze the components of formulas used in active campaigns: SELECT f.FORMULA_NAME, e.* FROM AMS_ACT_METRIC_FORMULAS f, AMS_ACT_METRIC_FORM_ENT e WHERE f.FORMULA_ID = e.FORMULA_ID AND f.ENABLED_FLAG = 'Y';

Direct reporting on this table is rare for end-users; its data is typically consumed by the marketing engine's calculation routines or through dedicated formula management interfaces.

Related Objects

The AMS_ACT_METRIC_FORM_ENT table has a direct and essential relationship with the AMS_ACT_METRIC_FORMULAS table, as defined by its foreign key constraint. This establishes a one-to-many relationship where a single formula header contains multiple execution entries. It is also intrinsically linked to the broader marketing metrics and campaign performance infrastructure. Related objects likely include the AMS_ACT_METRICS_B table (which stores the metric definitions that may be referenced within a formula entry) and the AMS_ACT_METRIC_FORMULA_PKG or similar PL/SQL APIs responsible for parsing and evaluating the stored formula logic. Understanding this table is key to customizing or extending the standard marketing calculation engine.