Search Results ams_dmsource_pvt




Overview
Explore in AI Chat

Overview

AMS_DMSOURCE_PVT is a private PL/SQL package body in the APPS schema that supports Oracle Marketing's data mining and scoring infrastructure. It is the internal implementation layer for managing the definition and lifecycle of data mining "sources"—the configured data extracts that feed predictive models in Oracle Data Mining (ODM) and the Advanced Marketing scoring engine. In Oracle EBS 12.1.1 and 12.2.2, this package bridges the marketing application tables (the AMS_DM_* and AMS_LIST_SRC_* families) with the underlying ODM engine, validating source records, generating the input views ODM consumes, invoking scoring, and cleaning up transient database objects. Because it is classified as a PVT package (not part of the public API surface), it is intended to be called by sibling private packages and the public AMS_DMSOURCE API rather than directly by customer code.

Key Procedures and Functions

  • CHECK_SOURCE_ITEMS — Verifies that the source definition's constituent items and field mappings are consistent and complete before the source is persisted or used.
  • LOCK_SOURCE — Acquires a lock on the source record to serialize concurrent modifications during create, update, or delete operations.
  • CREATE_SOURCE — Inserts a new data mining source definition and its associated metadata rows.
  • UPDATE_SOURCE — Modifies an existing source definition, revalidating affected attributes.
  • DELETE_SOURCE — Removes a source definition and its dependent configuration records.
  • VALIDATE_SOURCE_REC — Performs row-level validation of a single source record against business and consistency rules.
  • VALIDATE_SOURCE — Orchestrates full validation of a source, aggregating the row-level checks and returning errors through FND_MSG_PUB.
  • BIN_PROBABILITY — Computes probability bin assignments, used to bucket scored results into discrete probability bands.
  • PROCESS_SCORES — Drives the scoring workflow, reading model outputs and writing results to the AMS_DM_SCORES_ALL_B table.
  • GENERATE_ODM_INPUT_VIEWS — Constructs the database views that expose source data in the shape Oracle Data Mining requires for model build and scoring.
  • CLEANUP_ODM_INPUT_VIEWS — Drops or otherwise removes the transient input views created by GENERATE_ODM_INPUT_VIEWS after the ODM operation completes.

Tables Accessed

The package reads and writes the core data mining configuration tables. AMS_DM_SOURCE and its translation and sequence companions (AMS_DM_SOURCE_S) hold the source header definitions manipulated by CREATE_SOURCE, UPDATE_SOURCE, and DELETE_SOURCE. AMS_DM_TARGETS_B and AMS_DM_TARGET_SOURCES define the target and source-to-target associations used during validation. AMS_LIST_SRC_FIELDS, AMS_LIST_SRC_TYPES, and AMS_LIST_SRC_TYPE_ASSOCS describe the selectable source field types and their associations, which CHECK_SOURCE_ITEMS and VALIDATE_SOURCE consult. AMS_DM_MODELS_ALL_B, AMS_DM_MODELS_V, and AMS_DM_MODELS_VL are referenced to resolve model definitions during scoring, while AMS_DM_SCORES_ALL_B and AMS_DM_APPLY_STG_GT receive scored output and staging data. DBMS_RANDOM and DUAL support internal utility logic, and V$DATABASE is queried to detect the database environment. It also calls AMS_DM_SOURCE_PKG, AMS_DMSELECTION_PVT, and AMS_UTILITY_PVT.

Usage Notes

AMS_DMSOURCE_PVT is a private package and is not referenced by any other database object; it is invoked internally by the public marketing APIs and by concurrent programs that build and apply data mining models. Typical invocation occurs when a marketing administrator defines or edits a data mining source in the Oracle Marketing setup forms, when a model build or scoring concurrent request executes (triggering GENERATE_ODM_INPUT_VIEWS, PROCESS_SCORES, and the subsequent CLEANUP_ODM_INPUT_VIEWS), and during validation flows that surface errors through FND_MSG_PUB. Customizations should call the public AMS_DMSOURCE API rather than this package, since the private interface is subject to change across EBS patch levels.