Search Results ams_imp_documents




Overview
Explore in AI Chat

Overview

The AMS_IMP_DOCUMENTS table is a core data object within the Oracle E-Business Suite (EBS) Marketing (AMS) module, specifically for versions 12.1.1 and 12.2.2. It functions as the primary repository for metadata and control information pertaining to documents imported into the marketing system. This table is integral to the data import and list management processes, enabling the bulk loading of marketing-related documents, which may include customer lists, campaign collateral, or other reference materials. Its existence is critical for tracking the source, status, and context of imported data, ensuring data lineage and supporting the operational workflows of marketing campaigns and analytics.

Key Information Stored

While the provided ETRM metadata does not list specific columns beyond the foreign key, the table's description and relationships indicate it stores attributes essential for managing imported documents. The central column is IMPORT_LIST_HEADER_ID, which links each document record to its parent import batch or list header in the AMS_IMP_LIST_HEADERS_ALL table. Based on standard import framework patterns in Oracle EBS, other likely columns include a unique document identifier (DOCUMENT_ID), the original file name, import date and status, the document type or category, and possibly the physical storage location or pointer to the document content. These fields collectively allow the system to manage the lifecycle of imported documents from upload through processing.

Common Use Cases and Queries

The primary use case for this table is auditing and troubleshooting the document import process within Marketing. Administrators or functional users may query it to identify documents associated with a specific list import job or to verify successful uploads. A common reporting need is to join with the header table to get a comprehensive view of an import batch.

Sample SQL to list imported documents for a specific list header:

  • SELECT doc.* FROM ams.ams_imp_documents doc, ams.ams_imp_list_headers_all hdr WHERE doc.import_list_header_id = hdr.import_list_header_id AND hdr.name = '<List_Name>';

Another typical query involves checking the status of all recent document imports for monitoring purposes, potentially joining with user tables (FND_USER) to see who initiated the import.

Related Objects

The table maintains a direct and documented foreign key relationship, which is fundamental to its integration within the AMS data model.

  • AMS_IMP_LIST_HEADERS_ALL: This is the primary parent table. The column AMS_IMP_DOCUMENTS.IMPORT_LIST_HEADER_ID references the IMPORT_LIST_HEADER_ID in AMS_IMP_LIST_HEADERS_ALL. This relationship ensures every imported document is logically grouped under a specific import list header, which manages the overall batch control information for the import process.

While not specified in the provided metadata, it is plausible that this table is referenced by other transactional or interface tables within the AMS module that consume or process the imported document data, forming a hierarchy from the list header down to individual document records.

  • Table: AMS_IMP_DOCUMENTS 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_IMP_DOCUMENTS,  object_name:AMS_IMP_DOCUMENTS,  status:VALID,  product: AMS - Marketing ,  description: This table stores the information of imported document. ,  implementation_dba_data: AMS.AMS_IMP_DOCUMENTS , 

  • Table: AMS_IMP_DOCUMENTS 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_IMP_DOCUMENTS,  object_name:AMS_IMP_DOCUMENTS,  status:VALID,  product: AMS - Marketing ,  description: This table stores the information of imported document. ,  implementation_dba_data: AMS.AMS_IMP_DOCUMENTS , 

  • Table: AMS_IMP_LIST_HEADERS_ALL 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_IMP_LIST_HEADERS_ALL,  object_name:AMS_IMP_LIST_HEADERS_ALL,  status:VALID,  product: AMS - Marketing ,  description: This table stores the user entered name and other details about lists imported into Oracle Marketing from external sources. ,  implementation_dba_data: AMS.AMS_IMP_LIST_HEADERS_ALL , 

  • Table: AMS_IMP_LIST_HEADERS_ALL 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_IMP_LIST_HEADERS_ALL,  object_name:AMS_IMP_LIST_HEADERS_ALL,  status:VALID,  product: AMS - Marketing ,  description: This table stores the user entered name and other details about lists imported into Oracle Marketing from external sources. ,  implementation_dba_data: AMS.AMS_IMP_LIST_HEADERS_ALL ,