Search Results ams_wfmod_pvt




Overview
Explore in AI Chat

Overview

APPS.AMS_WFMOD_PVT is a private PL/SQL package within the Oracle E-Business Suite Advanced Marketing (AMS) module. It functions as a workflow orchestration and modeling engine that coordinates the execution of marketing data-mining and scoring workflows. The package detects, validates, and manages long-running data warehousing and analytical processes tied to the AMS Decision Management (DM) framework, including model building, source aggregation, transformation, and scoring. As a PVT-class object, it is not intended for direct customer invocation; rather it is consumed internally by public AMS packages that expose higher-level functionality to the application layer. The package is documented as VALID and owned by the APPS schema in both 12.1.1 and 12.2.2.

Key Procedures and Functions

The ETRM metadata lists sixteen documented procedures and functions. Their responsibilities cluster into process lifecycle management, data preparation, and validation.

  • STARTPROCESS — Initiates a modeling or scoring run and establishes the working context for downstream steps.
  • SELECTOR — Determines which records, models, or targets participate in the current operation.
  • VALIDATE_DATA — Performs data integrity and completeness checks before processing begins.
  • AGGREGATE_SOURCES — Consolidates source data required for building or scoring a model.
  • TRANSFORM — Applies transformations to prepared data.
  • COMMAND — Issues a control operation during workflow execution.
  • CHECK_RESPONSE — Interprets the outcome returned by an executed step.
  • COLLECT_RESULTS — Gathers and stores outputs generated by the run.
  • RESET_STATUS — Returns a process or object to a prior or default state.
  • UPDATE_OBJ_STATUS — Updates the status attribute of the associated model, score, or target record.
  • CANCEL_PROCESS — Terminates an in-progress operation.
  • CHANGE_SCHEDULE — Alters the scheduling of a recurring process.
  • VALIDATE_CONCURRENCY — Ensures concurrent executions do not conflict.
  • IS_PREVIEWING — Indicates whether the current run is a preview rather than a committed execution.
  • GET_ORIGINAL_STATUS — Retrieves the pre-change status for restoration or audit purposes.
  • OK_TO_PROCEED — Returns a decision flag authorizing the next workflow step.

Tables Accessed

Via APPS synonyms, the package references three principal tables, all "_B" base tables holding the master records for DM entities:

  • AMS_DM_MODELS_ALL_B — Stores model definitions; read to select the model under execution and updated to reflect status changes.
  • AMS_DM_SCORES_ALL_B — Stores scoring definitions; accessed to drive scoring runs and record outcomes.
  • AMS_DM_TARGETS_B — Stores target definitions used by SELECTOR and AGGREGATE_SOURCES to scope the population.

Usage Notes

AMS_WFMOD_PVT is referenced by three other packages — AMS_DMSELECTION_PVT, AMS_DM_MODEL_PVT, and AMS_DM_SCORE_PVT — which serve as the invoked entry points. It is therefore exercised indirectly when users run decision-management model builds, scoring jobs, or selection routines from the AMS application forms or concurrent programs. Because it is a private package, custom code should call the public AMS_DM_* packages rather than AMS_WFMOD_PVT directly; invoking it out of context risks inconsistent workflow state and status corruption.