1. Getting Started with Oracle Integration Generation 2
  2. Recipes Reference
  3. Enterprise Resource Planning (ERP) Recipes
  4. Process Inventory, Order, and Shipping Info

Process Inventory, Order, and Shipping Info

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

Note:

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.

Description

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 Warehouse Management Cloud Service to Fusion inventory.
  • OCWMS_RECEIPT_ADVICE: Takes purchase order receipts in Oracle Inventory Management Cloud and maps them to purchase orders in Oracle Warehouse Management Cloud Service.
  • OCWMS_RECEIPT_CONFIRMATION: Maps receipt confirmation from Oracle Warehouse Management Cloud Service to Fusion receiving.
  • OCWMS_SHIPMENT_REQUEST: Maps shipment requests from Fusion shipping to orders in Oracle Warehouse Management Cloud Service.
  • OCWMS_SHIPMENT_CONFIRMATION: Maps shipments from Oracle Warehouse Management Cloud Service 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 Warehouse Management Cloud Service. The connection is then used to create an integration, which calls Oracle Warehouse Management Cloud Service web services, as well as exposes web services that Oracle Warehouse Management Cloud Service 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 Requirements

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

Related Documentation