Search Results ams_dm_performance




Overview
Explore in AI Chat

Overview

The AMS_DM_PERFORMANCE table is a core data object within the Oracle E-Business Suite (EBS) Marketing (AMS) module. It functions as a results repository, specifically designed to store the output generated by the performance matrix report for data mining models. In the context of Oracle EBS 12.1.1 and 12.2.2, this table plays a critical role in the analytical and predictive capabilities of the Marketing module. It enables the quantitative assessment of model accuracy by persistently storing the predicted outcomes alongside the actual, observed values, thereby facilitating performance analysis, model validation, and comparative reporting for marketing campaigns and initiatives.

Key Information Stored

The table is structured to uniquely identify each performance record and link it to its originating predictive model. The primary columns, as defined by its primary and unique keys, are central to its function. The PERFORMANCE_ID column serves as the unique system-generated identifier for each record. The MODEL_ID is a foreign key that associates the performance data with a specific data mining model defined in the AMS_DM_MODELS_ALL_B table. The PREDICTED_VALUE and ACTUAL_VALUE columns are the core data points, holding the model's forecasted result and the corresponding real-world outcome, respectively. This pairing is essential for calculating key performance metrics like lift, accuracy, and error rates.

Common Use Cases and Queries

The primary use case is generating and analyzing the performance matrix report to evaluate the effectiveness of a deployed predictive model, such as a customer response or churn model. Analysts query this table to compare model predictions against actual campaign results. A common query pattern involves joining to the model definition table to retrieve descriptive context. For example, to assess a specific model's performance, one might use:

  • SELECT p.model_id, p.predicted_value, p.actual_value, m.model_name FROM ams_dm_performance p, ams_dm_models_all_b m WHERE p.model_id = m.model_id AND p.model_id = :model_id;

Reporting use cases include calculating aggregate accuracy statistics, identifying segments where the model performed well or poorly, and providing data for visual performance dashboards to guide marketing strategy refinements.

Related Objects

The AMS_DM_PERFORMANCE table has a direct and documented foreign key relationship with the AMS_DM_MODELS_ALL_B table, which is the master table for data mining model definitions within the AMS schema. The relationship is defined as:

  • Foreign Key Reference: AMS_DM_PERFORMANCE.MODEL_ID → AMS_DM_MODELS_ALL_B (Table). This relationship ensures referential integrity, meaning every performance record is explicitly linked to a valid, existing model. Any query or report joining these tables on the MODEL_ID column will retrieve performance data alongside the corresponding model's metadata (e.g., model name, type, creation date).