INVOpenTransactions
Use this transaction to load transactions from external applications and feeder systems, which include sales, order shipment transactions from an order entry system other than Oracle Order Entry, simple material issues, receipts, or transfers.
For more information about this transaction, see your Oracle Applications documentation.
Oracle Applications Module
Inventory
Open Interface
Inventory Open Transaction
Open Interface Tables
Open interface table(s) exposed by the transaction are as follows:
MTL_TRANSACTIONS_INTERFACE
MTL_TRANSACTION_LOTS_INTERFACE
MTL_SERIAL_NUMBERS_INTERFACE
Error SQL
Open interface table(s) queried by the error SQL are as follows:
MTL_TRANSACTIONS_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 |
INVENTORY_ITEM_ID | Inventory item ID. |
TRANSACTION_QUANTITY | Number of Items in the transaction. |
ERROR_EXPLANATION | Detailed error explanation. |
TRANSACTION_SOURCE_NAME | Name of the source. |
Usage Comments
To import transactions, run the Import Open Transactions function, which is under the Inventory module.