Search Results process_standard

Overview

APPS.AMS_LISTGENERATION_PKG is the core list-generation engine for Oracle Marketing (Advanced Marketing / AMS) in Oracle E-Business Suite 12.1.1 and 12.2.2. Its stated purpose, per the package header comments, is to "perform the generation of all oracle marketing defined lists." A list in AMS is a resolved set of marketing targets — customers, prospects, contacts, or accounts — produced by applying selection criteria, source queries, deduplication rules, and control-group logic. The package orchestrates the full lifecycle of that resolution: interpreting the list header definition, evaluating its source rules, writing entries into the list, and updating the header with generation statistics. It is declared AUTHID CURRENT_USER, so it executes with the privileges of the calling session rather than as a definer-rights API, which is significant for any custom or scheduled invocation.

The user's search term process_sql identifies one of the package's internal source-processing routines. It is the procedure responsible for handling list sources whose selection method is a SQL query rather than a standard seeded source type, a manual entry, or an import.

Key Procedures and Functions

The package exposes 37 documented procedures and functions. The principal entry point is GENERATE_LIST, which drives the generation of a single list identified by its list header. It coordinates the work of the source-type-specific workers:

• PROCESS_SQL — processes list sources defined by a user- or system-supplied SQL statement, resolving the query into list entries.
• PROCESS_STANDARD — processes sources based on seeded standard selection types.
• PROCESS_MANUAL — handles manually entered list members.
• PROCESS_IMPH — processes import-type list headers and their associated source rows.
• PROCESS_LIST, PROCESS_DIWB, and PROCESS_CELL — process list-based sources, Discoverer workbook sources, and cell-based sources respectively.

Supporting routines handle list creation and maintenance: CREATE_LIST, CREATE_IMPORT_LIST, CREATE_LIST_FROM_QUERY, INSERT_LIST_MAPPING_USAGE, GET_LIST_ENTRY_DATA, and UPDATE_LIST_DETS. VALIDATE_SQL_STRING validates the syntax and acceptability of a user-entered SQL statement before it is stored or executed, a critical guard for PROCESS_SQL. Metadata helpers GET_MASTER_TYPES and GET_CHILD_TYPES resolve source type hierarchies, while GENERATE_TARGET_GROUP builds target group output. Distributed-marketing scenarios are served by EXECUTE_REMOTE_DEDUPE_LIST and MIGRATE_LISTS_FROM_REMOTE.

Tables Accessed

The package reads and writes the central AMS list tables. AMS_LIST_HEADERS_ALL holds the list definition and is both read (via the C_ListHeader_Dets cursor) and updated with generation results and row counts. AMS_LIST_ENTRIES stores the resolved members produced during generation. Source configuration is drawn from AMS_LIST_SRC_TYPES and AMS_LIST_SRC_TYPE_ASSOCS, with selection rules in AMS_LIST_SELECT_ACTIONS. AMS_DISCOVERER_SQL and AMS_CELLS_ALL_B support Discoverer and cell-based sources, and AMS_IMP_LIST_HEADERS_ALL supports import lists. Activity and audit trails reside in AMS_ACT_LISTS, AMS_ACT_LOGS (with its _S and _TRANSACTION_ID_S indexes), and AMS_ACT_DISCOVERER_ALL. Scheduling context comes from AMS_CAMPAIGN_SCHEDULES_B, and TCA entity column mappings from AMS_DS_TCA_ENTITY_COLS. All access is through APPS synonyms.

Usage Notes

The package is normally invoked from the Oracle Marketing list generation concurrent program, which passes the list header identifier and executes GENERATE_LIST in a background manager session. In 12.2.2 the same call path applies under the Online Patching editioning model; because the package is AUTHID CURRENT_USER, custom callers must be granted direct privileges on the underlying tables rather than relying on APPS definer rights. PROCESS_SQL and VALIDATE_SQL_STRING are relevant to administrators configuring query-based list sources, where the SQL must conform to the expected column contract. Direct invocation from custom code is uncommon and unsupported; the package is referenced by ten other AMS packages, indicating that its procedures are intended to be called through the packaged marketing flows rather than independently.