Warehouse Management Integration

In this part: This part includes the following topics:

  • Warehouse Management System Integration Overview: Provides an overview of the Warehouse Management Integration.

  • Generic Outbound Purchase Order API: Describes how to send purchase order information to an external system.

  • Purchase Order Receipt In API: Describes how to process PO receipts received through the generic API.

  • Generic Pick In API (Shipments, Voids, and Backorders): Describes how to confirm shipments or void pick slips through the generic API.

For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1).

Warehouse Management System Integration Overview

Warehouse management systems control inventory movement, such as receiving merchandise, inventory transactions, picking and packing, and shipping merchandise to a customer.

The Warehouse Management System integration allows Order Administration and a warehouse management system (WMS) to pass inventory information in order to keep inventory information in both systems accurate. The WMS is where the actual inventory is located, but Order Administration needs to keep track of the changes to inventory that occur in the WMS so that the data in Order Administration remains accurate. For example, if the WMS adjusts the inventory for an item and does not notify Order Administration, orders placed in Order Administration may reserve items that do not have enough inventory in the warehouse.

The warehouse management system integration creates a bridge between Order Administration and a WMS. This bridge allows Order Administration and a WMS to pass data between the two systems using XML messages transmitted via a queue or web service.

In this topic:

What Does Order Administration Send to the Warehouse Management System?

Order Administration controls item information, vendor information, purchase order information, pick slip information, and return information. Any time you create or modify information in these areas, Order Administration sends the information to the warehouse management system.


The figure shows the communication between Order Administration and the Warehouse Management System.

What Does the Warehouse Management System Send to Order Administration?

The warehouse management system controls changes to inventory, such as purchase order receipts, inventory transactions, and shipping merchandise to customers. Any time the warehouse management system adds or removes inventory in a warehouse, the WMS sends the information to Order Administration.


The figure shows the communication between Order Administration and the Warehouse Management System.

Warehouse Integration Summary

Function Performed By:

Items: Order Administration sends new or changed items to the warehouse management system (WMS)

Generic Item Download API

For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1).

Vendors: Order Administration sends new or changed vendors to the WMS

Generic Vendor Download API

For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1).

Purchase orders: Order Administration sends new or changed purchase orders to the WMS

Generic Outbound Purchase Order API

For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1).

Purchase order receipts: Order Administration receives information on purchase order receipts sent from the WMS

Purchase Order Receipt In API

For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1).

Inventory activity: Order Administration receives information on inventory activity, such as transfers or adjustments, from the WMS

Generic Inventory Transaction Upload

For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1).

Inventory overlay: Order Administration receives updated inventory information from the WMS

Generic Inventory Transaction Upload

For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1).

Pick slip generation: Order Administration sends information on generated pick slips to the WMS

Generic Pick Out API

For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1).

Pick slip void: Order Administration sends information on voided pick slips to the WMS

Generic Pick Out API

For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1).

Shipment confirmation: Order Administration receives information on full or partial shipments; information on carton contents can also be included

Generic Pick In API (Shipments, Voids, and Backorders)

For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1).

Unfulfillable pick slips: Order Administration receives information on pick slip voids from the WMS

Generic Pick In API (Shipments, Voids, and Backorders)

For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1).

Returns: Order Administration sends updates on customer returns to the WMS

NA