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.
  • Table: AMS_DM_TARGETS_B 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_DM_TARGETS_B,  object_name:AMS_DM_TARGETS_B,  status:VALID,  product: AMS - Marketing ,  description: Target column definitions for data mining models. ,  implementation_dba_data: AMS.AMS_DM_TARGETS_B , 

  • Table: AMS_DM_TARGETS_B 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_DM_TARGETS_B,  object_name:AMS_DM_TARGETS_B,  status:VALID,  product: AMS - Marketing ,  description: Target column definitions for data mining models. ,  implementation_dba_data: AMS.AMS_DM_TARGETS_B , 

  • Table: AMS_LIST_SRC_TYPES 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_LIST_SRC_TYPES,  object_name:AMS_LIST_SRC_TYPES,  status:VALID,  product: AMS - Marketing ,  description: This table stores all different list source types that may be used for list generation. ,  implementation_dba_data: AMS.AMS_LIST_SRC_TYPES , 

  • Table: AMS_LIST_SRC_TYPES 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_LIST_SRC_TYPES,  object_name:AMS_LIST_SRC_TYPES,  status:VALID,  product: AMS - Marketing ,  description: This table stores all different list source types that may be used for list generation. ,  implementation_dba_data: AMS.AMS_LIST_SRC_TYPES , 

  • Table: AMS_DM_TARGET_VALUES_B 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_DM_TARGET_VALUES_B,  object_name:AMS_DM_TARGET_VALUES_B,  status:VALID,  product: AMS - Marketing ,  description: Target values represent positive values for a given target field. ,  implementation_dba_data: AMS.AMS_DM_TARGET_VALUES_B , 

  • Table: AMS_DM_TARGETS_TL 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_DM_TARGETS_TL,  object_name:AMS_DM_TARGETS_TL,  status:VALID,  product: AMS - Marketing ,  description: Multi-lingual support table for data mining targets. ,  implementation_dba_data: AMS.AMS_DM_TARGETS_TL , 

  • Table: AMS_DM_TARGETS_TL 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_DM_TARGETS_TL,  object_name:AMS_DM_TARGETS_TL,  status:VALID,  product: AMS - Marketing ,  description: Multi-lingual support table for data mining targets. ,  implementation_dba_data: AMS.AMS_DM_TARGETS_TL , 

  • Table: AMS_DM_TARGET_VALUES_B 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_DM_TARGET_VALUES_B,  object_name:AMS_DM_TARGET_VALUES_B,  status:VALID,  product: AMS - Marketing ,  description: Target values represent positive values for a given target field. ,  implementation_dba_data: AMS.AMS_DM_TARGET_VALUES_B , 

  • Table: AMS_DM_TARGET_SOURCES 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_DM_TARGET_SOURCES,  object_name:AMS_DM_TARGET_SOURCES,  status:VALID,  product: AMS - Marketing ,  description: Association of data sources with data mining targets ,  implementation_dba_data: AMS.AMS_DM_TARGET_SOURCES , 

  • Table: AMS_DM_TARGET_SOURCES 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_DM_TARGET_SOURCES,  object_name:AMS_DM_TARGET_SOURCES,  status:VALID,  product: AMS - Marketing ,  description: Association of data sources with data mining targets ,  implementation_dba_data: AMS.AMS_DM_TARGET_SOURCES , 

  • Table: AMS_LIST_SRC_FIELDS 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_LIST_SRC_FIELDS,  object_name:AMS_LIST_SRC_FIELDS,  status:VALID,  product: AMS - Marketing ,  description: This table stores all fields associated to a certain list source type. ,  implementation_dba_data: AMS.AMS_LIST_SRC_FIELDS , 

  • View: AMS_DM_TARGETS_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:AMS.AMS_DM_TARGETS_VL,  object_name:AMS_DM_TARGETS_VL,  status:VALID,  product: AMS - Marketing ,  description: Multi-lingual view for data mining alternative data source targets. ,  implementation_dba_data: APPS.AMS_DM_TARGETS_VL , 

  • View: AMS_DM_TARGETS_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:AMS.AMS_DM_TARGETS_VL,  object_name:AMS_DM_TARGETS_VL,  status:VALID,  product: AMS - Marketing ,  description: Multi-lingual view for data mining alternative data source targets. ,  implementation_dba_data: APPS.AMS_DM_TARGETS_VL , 

  • Table: AMS_LIST_SRC_FIELDS 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_LIST_SRC_FIELDS,  object_name:AMS_LIST_SRC_FIELDS,  status:VALID,  product: AMS - Marketing ,  description: This table stores all fields associated to a certain list source type. ,  implementation_dba_data: AMS.AMS_LIST_SRC_FIELDS , 

  • Table: AMS_DM_MODELS_ALL_B 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_DM_MODELS_ALL_B,  object_name:AMS_DM_MODELS_ALL_B,  status:VALID,  product: AMS - Marketing ,  description: Container for the model definition in the model building process. ,  implementation_dba_data: AMS.AMS_DM_MODELS_ALL_B , 

  • Table: AMS_DM_MODELS_ALL_B 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_DM_MODELS_ALL_B,  object_name:AMS_DM_MODELS_ALL_B,  status:VALID,  product: AMS - Marketing ,  description: Container for the model definition in the model building process. ,  implementation_dba_data: AMS.AMS_DM_MODELS_ALL_B , 

  • View: AMS_DM_MODELS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:AMS.AMS_DM_MODELS_V,  object_name:AMS_DM_MODELS_V,  status:VALID,  product: AMS - Marketing ,  description: View of data mining models with denormalized reference objects. ,  implementation_dba_data: APPS.AMS_DM_MODELS_V , 

  • View: AMS_DM_MODELS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:AMS.AMS_DM_MODELS_V,  object_name:AMS_DM_MODELS_V,  status:VALID,  product: AMS - Marketing ,  description: View of data mining models with denormalized reference objects. ,  implementation_dba_data: APPS.AMS_DM_MODELS_V , 

  • View: AMS_DM_SCORES_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:AMS.AMS_DM_SCORES_V,  object_name:AMS_DM_SCORES_V,  status:VALID,  product: AMS - Marketing ,  description: View of data mining scoring runs with denormalized reference objects. ,  implementation_dba_data: APPS.AMS_DM_SCORES_V , 

  • View: AMS_DM_SCORES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:AMS.AMS_DM_SCORES_V,  object_name:AMS_DM_SCORES_V,  status:VALID,  product: AMS - Marketing ,  description: View of data mining scoring runs with denormalized reference objects. ,  implementation_dba_data: APPS.AMS_DM_SCORES_V ,