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
Open interface table(s) exposed by the transaction are as follows:
PO_REQUISITIONS_INTERFACE
Error SQL
Open interface table(s) queried by the error SQL are as follows:
PO_INTERFACE_ERRORS
PO_REQUISITIONS_INTERFACE
FND_USER_VIEW
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. |
Outputs
Field | Description |
INTERFACE_TYPE | Interface name; for example, Requisitions. |
INTERFACE_TRANSACTION_ID | Transaction ID. |
COLUMN_NAME | Column in which the error occurred. |
ERROR_MESSAGE | Detailed explanation of the error. |
SOURCE_TYPE_CODE | Source type code. |
QUANTITY | Number of Items in the requisition. |
Usage Comments
To import requisitions run the Requisition Import Request function, which is under the Oracle Purchasing module.