PORequisitions

Use this transaction to import requisitions from other Oracle Applications or non‐Oracle systems. This transaction enables you to integrate your Oracle Applications quickly with new or existing applications such as material replenishment, planning, inventory management, and production control systems.

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

Oracle Applications Module

Purchasing

Open Interface

Requisitions

Open Interface Tables

The open interface tables exposed by this transaction are:

• PO_REQUISITIONS_INTERFACE_ALL
• PO_REQ_DIST_INTERFACE_ALL

Error SQL

Table 1. Inputs

Field	Description
WM_USER	Name of the user for the corresponding user ID in the CREATED_BY column of the MTL_CI_INTERFACE table. This parameter will accept wild cards. % returns all errors.

Table 2. Outputs

Field	Description
INTERFACE_TYPE	Interface type that generated the error.
INTERFACE_TRANSACTION_ID	Error transaction unique ID.
COLUMN_NAME	Error column name.
ERROR_MESSAGE	Error message text.
SOURCE_TYPE_CODE	The source for this requisition.
QUANTITY	Number of Items in the requisition.