Search Results ams_dm_models_all_b

Overview

The AMS_DM_MODELS_ALL_B table is a core data object within the Oracle E-Business Suite Marketing (AMS) module, specifically for releases 12.1.1 and 12.2.2. It functions as the primary container for the definition of data mining models within the model building process. This table stores the master, non-translatable attributes of a predictive or analytical model, which is a fundamental component of Oracle's Data Mining functionality for targeted marketing campaigns. Its role is to centrally define a model's parameters, ownership, status, and relationship to a specific marketing target, enabling subsequent scoring, performance analysis, and list generation activities.

Key Information Stored

The table's primary key is MODEL_ID, which uniquely identifies each model definition. Based on its documented foreign key relationships, other critical columns include USER_STATUS_ID, which links to the AMS_USER_STATUSES_B table to track the model's workflow status (e.g., Draft, Active, Inactive). The OWNER_USER_ID column references JTF_RS_RESOURCE_EXTNS, associating the model with a specific resource or user. The TARGET_ID column establishes a link to AMS_DM_TARGETS_B, defining the specific marketing objective or audience the model predicts. Finally, the CUSTOM_SETUP_ID column references AMS_CUSTOM_SETUPS_B, allowing for customized configuration of the model's parameters.

Common Use Cases and Queries

This table is central to administrative and operational reporting on data mining models. Common use cases include auditing all models owned by a specific user, identifying models associated with a particular marketing target, or generating a list of models in a specific status for review. A typical query might join to the translation table (AMS_DM_MODELS_ALL_TL) to retrieve the model name in a desired language. For performance analysis, this table would be joined to AMS_DM_PERFORMANCE or AMS_DM_LIFT. A sample query pattern to retrieve active models is:

• SELECT m.MODEL_ID, tl.MODEL_NAME, s.MEANING AS STATUS
• FROM AMS_DM_MODELS_ALL_B m,
• AMS_DM_MODELS_ALL_TL tl,
• AMS_USER_STATUSES_B s
• WHERE m.MODEL_ID = tl.MODEL_ID
• AND m.USER_STATUS_ID = s.USER_STATUS_ID
• AND s.SYSTEM_STATUS_CODE = 'ACTIVE';

Related Objects

The AMS_DM_MODELS_ALL_B table has extensive relationships within the AMS schema, as documented by its foreign keys. It is the parent table for several key transactional entities: AMS_DM_IMP_ATTRIBUTES (important attributes for the model), AMS_DM_LIFT (lift analysis results), AMS_DM_PERFORMANCE (performance metrics), and AMS_DM_SCORES_ALL_B (generated scores). The translation table, AMS_DM_MODELS_ALL_TL, provides multilingual names and descriptions via the MODEL_ID join. Furthermore, it is referenced by AMS_DM_SOURCE (as a source object) and AMS_LIST_SELECT_ACTIONS (as an action-used-by object), linking model definitions to data sources and campaign list selection rules, respectively.