Manage Inventory Transactions
Use the Manage Inventory Transactions scheduled process to process inventory transactions from the open interface tables.
When to Use
Use the Manage Inventory Transactions process to process inventory transactions from the inventory open interface tables (INV_TRANSACTIONS_INTERFACE, INV_TRANSACTION_LOTS_INTERFACE, and INV_SERIAL_NUMBERS_INTERFACE). For example, you can load data to the interface tables using the Inventory Transaction Import file-based data import (FBDI). Once you have successfully imported your data, submit the Manage Inventory Transactions process to process inventory transactions from the open interface tables.
Privileges Required
- Submit Inventory Transaction Process (INV_SUBMIT_INVENTORY_TRANSACTION_PROCESS_PRIV)
Specifications
| Specification | Description |
|---|---|
| Job Type | Ad hoc job Scheduled |
| Frequency | As required, after the Load Interface File for Import
process, Staged Inventory Transactions REST Resource submission,
or UI background transaction processing. It's recommended to schedule the process to run every 30 minutes or every hour. This allows one process to complete before the next one starts. However, these are only recommendations, and the frequency depends on the number of transactions and type of transactions. For example, inventory transactions for items that are lot and serial controlled can take additional processing time. The frequency also depends on your distribution of transactions. For example, if you process transactions throughout the day, you may want to consider scheduling the process to run more frequently. |
| Time of Day | Any time. |
| Duration | Runtime of this process varies based on the number of inventory transactions and type of inventory transactions requiring processing. For example, inventory transactions for lot and serial controlled items can take additional processing time. |
| Compatibility | There should be only one instance of the Manage Inventory
Transactions process running at any one time. Consider other scheduled processes that are being submitted at the same time. For example, processes such as Transfer Transactions from Inventory to Costing can be submitted after the Manage Inventory Transactions process. |
Parameters
None.
Troubleshooting Information
- You can view the status of the process in the Scheduled Processes work area.
- Error and warning messages encountered while running the process display in the process log file.
- You can manage pending transactions by navigating to the Manage Pending Transactions page. For additional details, please see the Pending Transactions topic in the Oracle Fusion Cloud SCM: Using Inventory Management guide.
- Once a transaction is submitted from the Manage Pending Transactions page, the transaction will be processed when the Manage Inventory Transactions scheduled process runs the next time.
- When the process is submitted, you can Resubmit, Put on Hold, Cancel Process, and Release Process as provided by the Scheduled Processes work area.
- It's recommended to periodically purge inventory interface transactions in error to keep the number of interface transactions below 1000.
- Ensure logging isn’t enabled. For example, Application Framework logging shouldn’t be enabled.
- Batch processing refers to processing a group of inventory transactions in a single batch. You should use batch processing with caution since the number of transaction workers will be reduced, and parallel processing will decrease. Batch processing results in an increase in transaction processing time.
- It isn't recommended to exceed 100K inventory transactions in a single inventory transaction file-based data import.
- Configure the Inventory Transaction Manager Worker Size inventory profile option to specify the number of inventory transactions to place in a single child worker for background processing by the Inventory Transaction Manager.