PODocuments

Use this transaction to import price and sales catalog information and responses into requests for quotations from suppliers.

For more information about this transaction, see your Oracle Applications documentation.

Oracle Applications Module

Purchasing

Open Interface

Purchase Order Documents

Open Interface Tables

Open interface table(s) exposed by the transaction are as follows:

  • PO_HEADERS_INTERFACE
  • PO_LINES_INTERFACE

Error SQL

Open interface table(s) queried by the error SQL are as follows:

  • PO_INTERFACE_ERRORS
  • PO_HEADERS_INTERFACE
Table 1. Inputs
Field Description
WM_USER User ID of the person who initiated the transaction; that is, the user ID in the CREATED_BY field in the transaction.
Table 2. Outputs
Field Description
INTERFACE_TYPE Error message source.
INTERFACE_TRANSACTION_ID Error transaction unique ID.
COLUMN_NAME Error column name.
ERROR_MESSAGE Error message text.
PO_HEADER_ID Unique purchase order header ID.
VENDOR_NAME Vendor name.

Usage Comments

  • You can import blanket purchase agreements or catalog quotations; you cannot import standard purchase orders.
  • To import purchase order documents, run the Purchasing Documents Open Interface function, which is under the Oracle Purchasing module.