Search Results ams_dmextract_pvt




Overview
Explore in AI Chat

Overview

AMS_DMEXTRACT_PVT is an Oracle E-Business Suite private PL/SQL package owned by the APPS schema, classified as a PVT (private) API within the Oracle Marketing (AMS) module. It supports the data mining and list extraction infrastructure that underpins Oracle Marketing's campaign execution, audience selection, and targeting capabilities. The package provides the internal processing engine that extracts customer and prospect records from staging and profile data into actionable marketing lists, which are subsequently consumed by campaign scheduling, offer assignment, and list management workflows.

Because it is classified as a private package, AMS_DMEXTRACT_PVT is not intended for direct invocation by external or customer-developed code. Instead, it is called by the public-facing packages within the AMS data mining layer, notably AMS_DMEXTRACT_PVT itself and other AMS packages such as AMS_DMSELECTION_PVT and AMS_WFMOD_PVT. The package is documented as VALID in ETRM and is present in both Oracle EBS 12.1.1 and 12.2.2 environments.

Key Procedures and Functions

  • EXTRACTMAIN — The principal extraction driver. This procedure orchestrates the movement of qualified records from the data mining staging and profile sources into the target marketing list structures. It serves as the main entry point for the extraction process, coordinating the various staging tables that hold segment members, scores, and party details before they are committed to the persistent list and campaign tables.
  • SCHEDULE_UPDATE_PARTIES — Manages the propagation of party (customer/prospect) information into campaign schedule records. This procedure ensures that the parties associated with an extraction are correctly reflected in the campaign schedule tables, maintaining consistency between the extracted audience and the scheduled campaign execution.

Tables Accessed

The package reads from and writes to a substantial set of AMS tables, including both persistent and global temporary staging structures:

Usage Notes

AMS_DMEXTRACT_PVT is an internal dependency rather than a directly callable API. It depends on FND_API for standard Oracle Application Object Library error handling and message conventions, and on SYS.STANDARD for base PL/SQL functionality. It is referenced by AMS_DMEXTRACT_PVT, AMS_DMSELECTION_PVT, and AMS_WFMOD_PVT, confirming its role as a supporting layer beneath the public AMS data mining interfaces.

In typical Oracle Marketing operations, extraction is invoked through concurrent programs and seeded workflows that execute audience selection and list building for campaigns. Administrators and implementers should not call AMS_DMEXTRACT_PVT directly; instead they should use the supported AMS public APIs and concurrent programs that internally invoke this package. For 12.1.1 and 12.2.2, the package remains classified as VALID, and any troubleshooting of list extraction or campaign schedule population issues should treat this package as a key internal subject, reviewing its execution in conjunction with the AMS staging tables and the FND_API error stack.