Search Results schedule_update_parties

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:

• Persistent extraction and list tables: AMS_ACT_LISTS (marketing lists), AMS_ACT_OFFERS (offer associations), AMS_DM_PARTY_DETAILS, AMS_DM_PARTY_DETAILS_TIME, AMS_DM_SOURCE, and AMS_DM_SCORES_ALL_B — these hold the qualified parties, their profile source definitions, and their computed scores.
• Campaign scheduling: AMS_CAMPAIGN_SCHEDULES and AMS_CAMPAIGN_SCHEDULES_B are updated to reflect extracted parties linked to scheduled campaigns.
• Global temporary staging tables: AMS_DM_AGG_STG_GT, AMS_DM_BIC_STG_GT, AMS_DM_DRV_STG_GT, AMS_DM_FINNUM_STG_GT, AMS_DM_GEN_STG_GT, AMS_DM_PERINT_STG_GT, and AMS_DM_PROFILE_STG_GT — these hold intermediate aggregation, scoring, and profile data during extraction, providing the working set from which final list members are selected.

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.