Search Results ams_dm_targets_b




Overview
Explore in AI Chat

Overview

The AMS_DM_TARGETS_B table is a core data dictionary object within the Oracle E-Business Suite Marketing (AMS) module. It serves as the master definition table for target columns used in data mining models. In the context of Oracle EBS 12.1.1 and 12.2.2, data mining enables predictive analytics for marketing campaigns, such as customer segmentation and propensity modeling. This table stores the technical metadata that defines what is being predicted (the target variable), linking the abstract data mining model to specific source fields within the application's operational data. Its role is foundational to the configuration and execution of the AMS data mining engine.

Key Information Stored

The table's structure is designed to define and relate target variables. The primary identifier is the TARGET_ID, a unique system-generated key referenced throughout the data mining schema. Other critical columns include MODEL_TYPE and SOURCE_FIELD_ID, which together form a unique key (AMS_DM_TARGETS_B_UK1) to prevent duplicate target definitions for a given model and source field. The DATA_SOURCE_ID and TARGET_SOURCE_ID columns link to source type definitions (AMS_LIST_SRC_TYPES), specifying the origin of the data. The table essentially acts as a mapping layer between a logical target in a model and the physical source field containing the data to be analyzed or predicted.

Common Use Cases and Queries

Primary use cases involve the setup, administration, and reporting of marketing data mining models. Common queries retrieve target definitions for a specific model, validate configurations, or support data lineage analysis. A typical pattern is joining to descriptive tables (like AMS_DM_TARGETS_TL for translated names) and source field tables.

  • Fetching all targets for a given model type:

    SELECT t.target_id, tl.name, t.source_field_id FROM ams_dm_targets_b t, ams_dm_targets_tl tl WHERE t.target_id = tl.target_id AND t.model_type = 'CLASIFICATION';

  • Identifying the source of a target variable for data governance:

    SELECT t.target_id, s.source_field_name FROM ams_dm_targets_b t, ams_list_src_fields s WHERE t.source_field_id = s.source_field_id;

Related Objects

AMS_DM_TARGETS_B is a central hub with numerous foreign key relationships, highlighting its importance in the data mining schema. Key related objects include:

  • AMS_DM_MODELS_ALL_B: The main model definition table references TARGET_ID.
  • AMS_DM_TARGETS_TL: Provides translated names and descriptions for the targets.
  • AMS_DM_TARGET_VALUES_B: Stores the distinct permissible values for categorical targets.
  • AMS_DM_TARGET_SOURCES: Further defines target source information.
  • AMS_LIST_SRC_FIELDS / AMS_LIST_SRC_TYPES: Reference tables defining the available source data fields and types from which targets are derived.