Results for “ams_imp_list_headers_all”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AMS_IMP_LIST_HEADERS_ALL is the header (master) table in the Oracle Marketing (AMS) module that stores the user-entered name and descriptive details of lists imported into Oracle Marketing from external sources. In Oracle EBS 12.1.1 and 12.2.2, it serves as the controlling record for each list import operation originating from third-party vendors, external files, or other source systems. Every imported list header captures the identity of the list, the source and vendor from which it was obtained, ownership and security attributes, processing parameters, and status information that governs the downstream import of individual list members.

Because the table carries multiple descriptive attributes (status, dates, costs, descriptive text) alongside its role as a parent to many dependent child tables, its heuristic Data Vault classification is hub. Import list headers act as the central business entity to which documents, source lines, error records, party sources, and translations attach. Teams applying Data Vault modeling conventions should treat IMPORT_LIST_HEADER_ID as the hub business key, with the remaining descriptive attributes modelled as satellites.

Key Information Stored

The surrogate primary key is IMPORT_LIST_HEADER_ID, generated via AMS_IMP_LIST_HEADERS_ALL_PK. Two unique indexes define business-key candidates: U1 on IMPORT_LIST_HEADER_ID and U2 on the composite (NAME, VERSION, VIEW_APPLICATION_ID), meaning a list name is unique only within a given version and application context.

• NAME, VERSION, VIEW_APPLICATION_ID – the user-entered list name, its version, and the FND_APPLICATION context in which the list is visible.
• IMPORT_TYPE, LIST_SOURCE_TYPE_ID, SOURCE_SYSTEM, VENDOR_ID – how the list was imported, its category (FK to AMS_LIST_SRC_TYPES), the originating system, and the vendor.
• STATUS_CODE, STATUS_DATE, USER_STATUS_ID – processing status and the user-defined status (FK to AMS_USER_STATUSES_B).
• OWNER_USER_ID – the resource that owns the header (FK to JTF_RS_RESOURCE_EXTNS).
• SCHEDULED_TIME, LOADED_NO_OF_ROWS, LOADED_DATE, PROCESSED_ROWS, ROWS_TO_SKIP, NUMBER_OF_RECORDS – scheduling and load-volume telemetry used to monitor import progress.
• DATA_FILENAME / DATA_FILE_NAME, LOG_FILE_NAME, CHARSET – the external source file, log, and character set used during the import run.
• DESCRIPTION, KEYWORDS, EXPIRY_DATE, PURGE_DATE – descriptive and lifecycle attributes of the imported list.
• TRANSACTIONAL_COST, FUNCTIONAL_COST (with currency codes) and RENTED_LIST_FLAG, B2B_FLAG – commercial cost and list-type indicators.
• ORG_ID, SECURITY_GROUP_ID, CUSTOM_SETUP_ID – multi-org and security-group partitioning plus customization linkage (FK to AMS_CUSTOM_SETUPS_B).
• Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) and 15 ATTRIBUTE flex columns support auditing and extensibility.

Common Use Cases and Queries

Typical scenarios include reconciling imported list volumes, monitoring scheduled or cancelled imports, and reporting on list owner, vendor, or cost. A common query joins the header to its source type and status:

• Listing active imports for an operating unit: SELECT h.import_list_header_id, h.name, h.version, h.status_code FROM ams_imp_list_headers_all h WHERE h.org_id = :p_org_id AND h.status_code = 'ACTIVE';
• Volume reconciliation: compare LOADED_NO_OF_ROWS, PROCESSED_ROWS, NUMBER_OF_FAILED_RECORDS, and NUMBER_OF_DUPLICATE_RECORDS to validate a completed load.
• Cost and vendor analysis: aggregate TRANSACTIONAL_COST grouped by VENDOR_ID and LIST_SOURCE_TYPE_ID.
• Auditing imported lists against errors using AMS_LIST_IMPORT_ERRORS filtered by IMPORT_LIST_HEADER_ID.
• Purging candidates identified through EXPIRY_DATE or PURGE_DATE.

Related Objects

The table is a central parent referenced by many AMS objects, and it also references several lookups and setup tables.

• AMS_IMP_LIST_HEADERS_ALL_TL – translated name/description rows keyed by IMPORT_LIST_HEADER_ID.
• AMS_IMP_DOCUMENTS and AMS_IMP_DOC_CONTENT – document metadata and content for the import.
• AMS_IMP_SOURCE_LINES – individual source records belonging to the header.
• AMS_LIST_IMPORT_ERRORS – validation and load errors per IMPORT_LIST_HEADER_ID.
• AMS_PARTY_SOURCES – party-to-source mapping for imported members.
• AMS_LIST_SELECT_ACTIONS – selection actions using INCL_OBJECT_ID.
• AMS_ACT_LOGS and AMS_ACT_METRICS_ALL – activity logs and metrics referencing ACT_LOG_USED_BY_ID / ACT_METRIC_USED_BY_ID.
• Referenced parents: AMS_USER_STATUSES_B, JTF_RS_RESOURCE_EXTNS, FND_APPLICATION, AMS_LIST_SRC_TYPES, BEN_PIN, FND_SECURITY_GROUPS, and AMS_CUSTOM_SETUPS_B.