Search Results ams_imp_source_lines




Overview
Explore in AI Chat

Overview

The AMS_IMP_SOURCE_LINES table is a core data object within the Oracle E-Business Suite Marketing (AMS) module, specifically for releases 12.1.1 and 12.2.2. It functions as the primary staging table for prospect data imported from external sources. Its role is to temporarily hold detailed records for persons or organizations during the list import process before they are validated and processed into the Trading Community Architecture (TCA) registry. This table is critical for data migration, campaign management, and lead generation workflows, serving as the intermediary between raw external data and the standardized party model in Oracle EBS.

Key Information Stored

The table stores a comprehensive set of attributes for each imported prospect record. As indicated by the metadata, its primary key is IMPORT_SOURCE_LINE_ID, which uniquely identifies each imported line. Key foreign key columns establish critical relationships: IMPORT_LIST_HEADER_ID links to the parent import job in AMS_IMP_LIST_HEADERS_ALL; PARTY_ID, ORGANIZATION_ID, CONTACT_POINT_ID, and LOCATION_ID link to successfully created entities in the TCA registry (HZ_PARTIES, HZ_CONTACT_POINTS, HZ_LOCATIONS). Other columns typically store source system identifiers, prospect names, addresses, contact details, and import status flags, forming a complete snapshot of the raw imported data.

Common Use Cases and Queries

Primary use cases involve troubleshooting failed imports, auditing import history, and analyzing source data quality. A common query pattern is to join this table with error tables to identify records that failed validation. For example, to find lines from a specific import that failed, one might use:

  • SELECT ils.* FROM ams_imp_source_lines ils, ams_list_import_errors lie WHERE ils.import_source_line_id = lie.import_source_line_id AND ils.import_list_header_id = <HEADER_ID>;

Another frequent scenario is verifying which imported source lines successfully created party records by querying where PARTY_ID is not null. Reporting use cases include tracking import volumes by source and analyzing the conversion rate from imported lines to created prospects.

Related Objects

AMS_IMP_SOURCE_LINES has integral relationships with several key objects. It is a child of AMS_IMP_LIST_HEADERS_ALL, which defines the import job. It references TCA foundation tables (HZ_PARTIES, HZ_LOCATIONS, HZ_CONTACT_POINTS) for successfully processed data. Crucially, it is referenced by AMS_LIST_IMPORT_ERRORS, which logs validation failures, and by AMS_PARTY_SOURCES, which maintains the lineage between a created party and its original import source. This network of relationships underscores its central role in the import data flow.