Interface Table and Error table Detail

Interface Table and Error table Detail

Invoice Inbound Interface

Interface Tables:

• AP_INVOICES_INTERFACE
• AP_INVOICE_LINES_INTERFACE
• AP_INTERFACE_REJECTIONS (Error Table)

Base Tables:

• AP_INVOICES_ALL
• AP_INVOICE_LINES_ALL (in R12)
• AP_INVOICE_DISTRIBUTIONS_ALL

Concurrent Program:

• Payables Open Interface Import

Supplier Inbound Interface

Interface tables:

• AP_SUPPLIERS_INT
• AP_SUPPLIER_SITES_INT
• AP_SUP_SITE_CONTACT_INT
• AP_SUPPLIER_INT_REJECTIONS (Error table for Supplier, Site and Contact inbound based on parent_table column)

Base Tables:

• PO_VENDORS
• PO_VENDOR_SITES_ALL
• PO_VENDOR_CONTACTS

Concurrent programs:

• Supplier Open Interface Import
• Supplier Sites Open Interface Import
• Supplier Site Contacts Open Interface Import

Request Set:

• Supplier Open Interface Request Set (Contain all 3 above mentioned concurrent programs)

Item Inbound Interface

Interface Tables:

• MTL_SYSTEM_ITEMS_INTERFACE
• MTL_ITEM_REVISIONS_INTERFACE
• MTL_ITEM_CATEGORIES_INTERFACE
• MTL_INTERFACE_ERRORS (Error Table)

Base Tables:

• MTL_SYSTEM_ITEMS_B
• MTL_ITEM_REVISIONS_B
• MTL_CATEGORIES_B
• MTL_CATEGORY_SETS_B

Concurrent program:

• Import Items

Receipt Inbound Interface

Interface Tables:

• RCV_TRANSACTIONS_INTERFACE
• RCV_HEADERS_INTERFACE
• PO_INTERFACE_ERRORS (Error Table)

Base Tables:

• RCV_SHIPMENT_HEADERS
• RCV_SHIPMENT_LINES
• RCV_TRANSACTIONS

Concurrent Program:

• Receiving Transaction Processor

Purchase Order Inbound Interface

Interface Tables:

• PO_HEADERS_INTERFACE
• PO_LINES_INTERFACE
• PO_DISTRIBUTIONS_INTERFACE
• PO_INTERFACE_ERRORS where interface_type = ‘PO_DOCS_OPEN_INTERFACE’ (Error Table)

Base Tables:

• PO_HEADERS_ALL
• PO_LINES_ALL
• PO_DISTRIBUTIONS_ALL
• PO_LINE_LOCATIONS_ALL

Concurrent Program:

• Import Standard Purchase Orders (To import Standard Purchase Orders)
• Import Price Catalogs(To import Catalog Quotations, Standard Quotations, and Blanket Purchase Agreements)

Requisition Inbound Interface

Interface Tables:

• PO_REQUISITIONS_INTERFACE_ALL
• PO_REQ_DIST_INTERFACE_ALL
• PO_INTERFACE_ERRORS where interface_type =’REQIMPORT’ (Error Table)

Base Tables:

• PO_REQUISITIONS_HEADERS_ALL
• PO_REQUISITION_LINES_ALL
• PO_REQ_DISTRIBUTIONS_ALL

Concurrent Program:

• Requisition Import