POReceiving

Use this transaction to import receipt information from other Oracle Applications or non‐ Oracle systems. You use this interface to integrate your Oracle purchasing application with new or existing applications.

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

Oracle Applications Module

Purchasing

Open Interface

Receiving

Open Interface Tables

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

  • RCV_HEADERS_INTERFACE
  • RCV_TRANSACTIONS_INTERFACE

Error SQL

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

  • PO_INTERFACE_ERRORS
  • RCV_HEADERS_INTERFACE
  • RCV_TRANSACTIONS_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.
PO_LINE_ID Unique purchase order line ID.
VENDOR_NAME Vendor name.

Usage Comments

To import receipt information from open interface tables to internal tables, run the Receiving Transaction Processor function, which is under the Oracle Purchasing module.