Oracle Apps Adapter 6.0 | webMethods Oracle Applications Adapter Documentation | webMethods Oracle Applications Adapter Sample Transaction Definitions User’s Guide Documentation | Transaction Definition (IS-to-Oracle Applications 11.5) | PORequisitions
 
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
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.
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.