Process REST-Based Inventory Transactions Efficiently for High-Volume Requests

When you’re operating in high-volume environments, REST APIs are one of the most effective ways to create a large number of transactions. One key to making sure your REST transactions process efficiently is setting the correct processing mode. Specifically, when using the Inventory Staged Transactions REST API, set the processing mode using the Transaction Mode parameter. This parameter accepts a value of Online, Concurrent, or Background. 

  • Online - data is inserted into the interface tables and processed synchronously.
  • Concurrent - data is inserted into the interface tables and immediately processed using the Create Inventory Transaction process.
  • Background - data is inserted into the interface tables, but not processed until the Manage Inventory Transaction process is run manually or during its next scheduled time.

When submitting transactions using the Online mode, numerous factors can lead to reduced performance and result in a 504 gateway timeout error, which can sometimes result in lost transaction data. To prevent this from happening, now when you use the Online transaction mode, if the process runs for too long and is at risk of a 504 gateway timeout error, the application stops processing the data, retains the data in the interface table, and returns a 408 request timeout error. Because the data is retained in the interface table, you simply need to run the Manage Inventory Transaction process to continue processing your transactions. 

This feature prevents issues or errors in your integrations and ensures that transactions are completed as efficiently as possible.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

Unprocessed transactions remain in the interface tables ready to be processed in the background the next time the Inventory Transaction Manager is run. With this change, you should consider setting the transaction processing mode to Concurrent or Background for the Inventory Staged Transactions REST API.

Key Resources

  • Oracle Fusion Cloud SCM: Using Inventory Management, available on the Oracle Help Center.
  • Oracle Fusion Cloud SCM: Implementing Manufacturing and Supply Chain Management, available on the Oracle Help Center.

Access Requirements

Users who are assigned a configured job role that contain this privilege can access this feature.

  • Manage Staged Inventory Transaction Web Service (INV_MANAGE_STAGED_INVENTORY_TRANSACTION_WEB_SERVICE_PRIV)

This privilege was available prior to this update.