1. Integration Playbooks for SCM
  2. Overview of the Architecture

Overview of the Architecture

You can use this suggested architecture that describes how to publish current inventory on-hand balance snapshots from Oracle Fusion Cloud Inventory Management to an external system, such as a warehouse management system (WMS) or third-party logistics provider (3PL), for reconciliation.

Maintaining synchronized inventory data across Oracle Inventory Management and external systems is essential for planning, fulfilment, and financial accuracy. Discrepancies can occur because of timing differences, transaction failures, or system misalignment. This integration provides a standardized file-based snapshot that can be consumed by the external system to compare balances and identify mismatches.

Use Cases

The reference architecture supports these flows:

  • Publish inventory on-hand balance snapshot data from Oracle Inventory Management organizations.
  • Publish balances for serial-controlled items, nonserial-controlled items, or both.
  • Generate a pipe-separated values snapshot file and compress it into a ZIP file.
  • Upload the generated ZIP file to Oracle WebCenter Content for external system consumption.
  • Allow the external system to import the snapshot and reconcile its balances with Oracle Inventory Management.

Required Applications

Ensure you have access to these applications:

  • Oracle Fusion Cloud SCM
  • Oracle Fusion Cloud Inventory Management
  • Oracle WebCenter Content
  • Oracle Integration Cloud
  • External system such as WMS or 3PL

Process Overview

This flow diagram shows the main steps involved when designing and implementing the use case to publish the current inventory on-hand balance snapshots from Oracle Inventory Management to an external system.

The flow diagram shows the main steps involved to publish the inventory on-hand balance to an external system.

Before You Begin

Before performing an integration, be aware of the following prerequisites and considerations:

  • Oracle Warehouse Management is provided as the default seeded external system. Based on your requirements, you can configure other external systems by using the lookup ORA_INV_BALANCES_INV_EXTERNAL.
  • Ensure that the user submitting the scheduled process has a configured job role that includes the following privileges:
    • Inventory Transaction Management (ORA_INV_INVENTORY_TRANSACTION_MANAGEMENT_DUTY)
    • Publish Inventory On-Hand Balances to External Systems (INV_PUBLISH_ONHAND_TO_EXT_SYSTEMS_PRIV)
  • Ensure that the external system or Oracle Integration Cloud process can retrieve the generated ZIP file from WebCenter Content.
  • Confirm the reconciliation scope, including organizations, item types, serial handling, and the expected publishing cadence.

Related Topics