Search Results ams_list_src_mapping




Overview
Explore in AI Chat

Overview

AMS_LIST_SRC_MAPPING is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM API taxonomy as OTHER. It belongs to the Oracle Marketing (AMS) module and supports the configuration of list source mappings used by the Marketing lists and list import infrastructure. In Oracle Marketing, a list source defines where customer, prospect, or contact records originate — for example an imported file, a query, or a seeded source type. The AMS_LIST_SRC_MAPPING package provides the programmatic interface for creating and maintaining the mapping between those source definitions and the columns or fields that populate marketing lists.

The package is documented as VALID, meaning it is compiled and available in the database. It is a low-level utility package rather than an end-user facing API; the seeded Oracle Marketing forms and concurrent programs call it internally, and it is also available for controlled extension by custom code that needs to create or refresh list source mappings.

Key Procedures and Functions

The documented interface exposes a single procedure:

  • CREATE_MAPPING — Creates a list source mapping record. This is the entry point used to associate a list source type or source header with the individual source fields and their corresponding import or list column mappings. It is the only procedure or function documented in the ETRM metadata for this package, and downstream Oracle Marketing setup flows rely on it when new list source definitions are introduced.

No public function signatures or parameter lists are enumerated in the documentation; the procedure should be treated as a packaged creation routine whose specific arguments are governed by the package specification shipped with the AMS schema.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

The package also depends on FND_API and the SYS STANDARD package, consistent with the Oracle Applications API coding standards of returning a success or failure status rather than raising unhandled exceptions.

Usage Notes

AMS_LIST_SRC_MAPPING is normally invoked indirectly. Oracle Marketing setup forms and seeded concurrent programs call CREATE_MAPPING during configuration of list sources, and the package is referenced by the AMS_LIST_SRC_MAPPING and AMS_LIST_SRC_MAPPING_W views, which are used by the supporting forms and validation logic. Only one other package references AMS_LIST_SRC_MAPPING, indicating a narrow, specialized role in the application architecture.

When extending Oracle Marketing, use of CREATE_MAPPING should be preceded by careful review of the AMS_LIST_SRC_FIELDS and AMS_LIST_SRC_TYPES seed data, because a mapping created against an inconsistent source type or missing field will produce invalid import column mappings and downstream list load failures. Because the package adheres to FND_API conventions, custom callers should inspect the returned status and message rather than relying on exceptions. As with all APPS-owned seeded code, the package specification should not be modified; customization should be confined to calling the documented routine from a proprietary wrapper. Testing any change in a cloned environment before applying it to production is essential, since incorrect list source mappings affect marketing list population and campaign execution across the instance.