Search Results ams_imp_list_headers_all

Overview

The AMS_IMP_LIST_HEADERS_ALL table is a core data structure within the Oracle E-Business Suite Marketing (AMS) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master header table for managing lists of contacts or parties imported into Oracle Marketing from external systems. This table is central to the list import functionality, acting as the primary container for metadata that describes the imported list, its source, status, and ownership. Its role is to provide a controlled, auditable framework for bringing external marketing data into the Oracle EBS ecosystem, enabling subsequent campaign targeting, lead management, and marketing analytics.

Key Information Stored

The table stores administrative and descriptive attributes for each imported list. The primary identifier is the IMPORT_LIST_HEADER_ID. A unique key constraint ensures the combination of NAME, VERSION, and VIEW_APPLICATION_ID is unique, preventing duplicate list definitions. Critical descriptive columns include the user-defined NAME of the list and its VERSION number. Key relational columns define the list's context: LIST_SOURCE_TYPE_ID links to the source classification (AMS_LIST_SRC_TYPES), USER_STATUS_ID tracks the import process status (AMS_USER_STATUSES_B), and OWNER_USER_ID identifies the responsible resource (JTF_RS_RESOURCE_EXTNS). The VIEW_APPLICATION_ID (referencing FND_APPLICATION) controls multi-org access and data partitioning, as indicated by the "_ALL" suffix in the table name.

Common Use Cases and Queries

Primary use cases involve tracking the lifecycle of imported lists and troubleshooting import processes. Common operational queries include identifying lists by owner or status, auditing import history, and linking header information to detailed line-level data. For reporting, this table is joined to transactional tables to measure list utilization in campaigns. Sample SQL patterns include status checks and joins to related detail tables:

• Retrieving active lists for a specific owner: SELECT name, version, creation_date FROM ams_imp_list_headers_all WHERE owner_user_id = :user_id AND user_status_id = (SELECT user_status_id FROM ams_user_statuses_b WHERE system_status_code = 'ACTIVE');
• Joining to error tables for troubleshooting: SELECT h.name, e.error_message FROM ams_imp_list_headers_all h, ams_list_import_errors e WHERE h.import_list_header_id = e.import_list_header_id;

Related Objects

The table maintains extensive relationships within the Marketing schema, as documented by its foreign key constraints. It is a parent table to numerous detail and transactional tables. Key child tables storing data specific to an import header include AMS_IMP_SOURCE_LINES (individual list members), AMS_IMP_DOCUMENTS and AMS_IMP_DOC_CONTENT (source documents), and AMS_LIST_IMPORT_ERRORS. The translated name is stored in AMS_IMP_LIST_HEADERS_ALL_TL. Furthermore, the imported list header can be referenced as a "used by" object in activity logging (AMS_ACT_LOGS) and metrics (AMS_ACT_METRICS_ALL). It is also referenced by AMS_PARTY_SOURCES for party origin tracking and can be an inclusion object for list selection actions (AMS_LIST_SELECT_ACTIONS).