Process Inventory, Order, and Shipping Info Between Oracle ERP/SCM Cloud and Oracle WMS Cloud

Use this recipe to process information related to inventory, purchase orders, receiving, and shipping. It demonstrates a sample integration between Oracle Enterprise Resource Planning (ERP)/Supply Chain & Manufacturing (SCM) Cloud and Oracle Warehouse Management (WMS) Cloud.

Note:

This recipe is available as Oracle ERP/SCM Cloud — Oracle WMS Cloud | Process Inventory, Order, and Shipping Info in the Integration Store. Oracle provides this recipe as a sample only. The recipe is meant only for guidance, and is not warranted to be error-free. No support is provided for this recipe.

Overview

This recipe syncs inventory, and maps receipts to purchase orders, receipts to receiving, and shipments to orders.

It includes the following individual integrations in one package:

  • OCWMS_INVENTORY_ADJUSTMENT: Makes inventory adjustments from Oracle WMS Cloud to Fusion inventory.
  • OCWMS_RECEIPT_ADVICE: Takes purchase order receipts in Oracle Inventory Management Cloud and maps them to purchase orders in Oracle WMS Cloud.
  • OCWMS_RECEIPT_CONFIRMATION: Maps receipt confirmation from Oracle WMS Cloud to Fusion receiving.
  • OCWMS_SHIPMENT_REQUEST: Maps shipment requests from Fusion shipping to orders in Oracle WMS Cloud.
  • OCWMS_SHIPMENT_CONFIRMATION: Maps shipments from Oracle WMS Cloud to the confirmation in Fusion shipping.
  • OCWMS_ECHO_LGFDATA: Used for internal XML transformation. No user configuration is necessary.

The integration uses the standard REST Adapter available in Oracle Integration to create a connection to a specific instance of Oracle WMS Cloud. The connection is then used to create an integration, which calls Oracle WMS Cloud web services, as well as exposes web services that Oracle WMS Cloud can call to push out data. The sample flow uses the Oracle ERP Cloud Adapter to connect to ERP Cloud instances (Fusion/Cloud Inventory).

System and Access Requirements

  • Oracle WMS Cloud, Version 9.0.0 or later
  • Oracle Inventory Management Cloud, Version 18A or later
  • Oracle Integration

Install, Configure, and Run the Recipe

For more information and steps to install, configure, and run recipes, see Get Started with Integration Accelerators and Recipes.