ARCHIVE FOR THE ‘INBOUND INTERFACES’ CATEGORY

ARCHIVE FOR THE ‘INBOUND INTERFACES’ CATEGORY
Invoice Inbound Interface
Posted: July 5, 2013 in Inbound Interfaces

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
Posted: July 5, 2013 in Inbound Interfaces

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
Posted: July 5, 2013 in Inbound Interfaces

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
Posted: July 5, 2013 in Inbound Interfaces

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
Posted: July 5, 2013 in Inbound Interfaces

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
Posted: July 5, 2013 in Inbound Interfaces

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