Inventory Balances Integration with External Systems

Using Oracle Fusion Cloud Inventory Management's inventory balances integration capabilities, you can outsource warehousing and manufacturing processes to efficiently lower costs, service local markets, reduce cycle times, and so on.

A central integration framework across Oracle Purchasing, Oracle Fusion Cloud Order Management, and Oracle Inventory Management tracks interactions between the various external systems. You can receive inventory balance details from external systems, such as third-party logistics providers, warehouse management systems, or contract manufacturers and use this information to reconcile inventory balances. Inventory on-hand details can include subinventory, locator, lot, serial number, and external packing unit.

The inventory balances integration feature enables you to:

  • Use the Inventory Balance Transactions REST resource to post inventory balance messages from an external system

  • Import inventory balance messages in bulk using a SaaS spreadsheet

  • Enable users to resolve any processing exceptions

  • Purge inventory balance messages periodically

Note: This feature is automatically available and is included with the shipped job roles (warehouse manager and inventory manager).

Use the following processes and task to interface with external systems to improve tracking and visibility across your supply chain, including partners:

  • Manage Inventory Balances Processes

  • Manage Inventory Balance Messages in Spreadsheet (ADFdi)

  • Manage Inventory Transaction Process

  • Purge Inventory Balance Messages Process

Manage Inventory Balances Process

This scheduled process processes the imported inventory balance messages in the interface tables.

Manage Inventory Balance Messages in Spreadsheet (ADFdi)

Use this task, in the Inventory Management work area in the Manufacturing and Supply Chain Materials Management offering, to review and resolve any exceptions while processing the inventory balance messages.

Manage Inventory Transaction Process

This scheduled process processes the necessary adjustment transactions to reconcile the inventory balances.

Purge Inventory Balance Messages Process

Use this scheduled process to purge the historical balance inventory messages collected over time in the interface tables. Using the processing status parameter, you can purge error, successful, or all messages between a date range.