Purchase Order Interfaces

PO 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 Programs:

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

REQUISITIONS 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 Programs:

  • Requisition Import