Integrate with Oracle Warehouse Management Cloud Service

The integration of Oracle Warehouse Management Cloud Service with Oracle IoT Fleet Monitoring Cloud Service enables efficient floor management of facilities, reduces wait time at locations, and results in faster turnaround.

What is Oracle Warehouse Management Cloud Service

Oracle Warehouse Management Cloud Service is a cloud application designed to support warehouse or distribution center management and staff. This application facilitates management of available resources to move and store materials into, within, and out of a warehouse, while supporting staff in material movement and storage.

Need for Integrating with Oracle IoT Fleet Monitoring Cloud Service

Solutions were needed to reduce the loading and unloading time at the warehouse facilities and eliminate the driver wait-time. If the dock personnel are notified of the real-time location of trucks and their arrival time, then the team can plan for the vehicles and stage cargo, which will considerably reduce loading and unloading time and also allow trucks to get back on the road faster.

About the Integration

Enterprise businesses can have various business benefits out of the integration between Oracle Warehouse Management Cloud Service and Oracle IoT Fleet Monitoring Cloud Service. Shipment planners, truck drivers, and dock operations team use this integration.

Benefits of the Integration

Enterprises that manage and maintain warehouse operations or businesses that own private fleet or manage third -party logistics/carriers experience these benefits from the integration:

• Increase in facility throughput due to improved efficiency in dock appointments and reduction in loading and unloading time
• Improved delivery times of all shipments
• Improved turnaround time for vehicles to get back on road
• Elimination of driver's idle time or wait time at the docks

End Users and Devices

These roles and devices are involved in the integration:

• Dock manager or warehouse manager - Uses Oracle Warehouse Management Cloud Service to determine freight weight on an incoming truck, track the truck location, and identify the dock door available for the truck on arrival.
• Truck Driver - Drives the truck carrying the shipment.
• Dock Workers - Performs loading and unloading of shipments.
• Truck - Equipped with GPS sensors that communicate real-time location through on-board gateway.
• Driver's mobile device - Information is used by fleet operator to learn about dock assignments.
• (optional) Dock worker's mobile device - Used by dock worker to learn about incoming truck, associated freight, and dock assignments.
• (optional) Dock doors - Equipped with sensors that notify drivers about doors that are available.

Connect to an Oracle Warehouse Management Cloud Service Instance

To import, configure, and monitor warehouse facilities from Oracle Warehouse Management Cloud Service, you provide its instance URL, credentials, and values for some configurable parameters including inbound and outbound dock type names, expected time of arrival (ETA) update tolerance value, and check-in geo-fence radius.

An administrator can create the integration in Default Organization or switch to the appropriate organization before creating the integration.

1. Click the Menu () icon, and then click Design Center.
2. From the Design Center menu options, click Organization
3. Click Integrations () icon.
4. On the Integrations page, click Warehouse Management Cloud.
5. Click Connect to WMS.
6. Enter the values for these fields:

   • URL: The URL of the Oracle Warehouse Management Cloud Service instance such as https://xxx.wms.ocs.oraclecloud.com/lgf_100_ora/wms

   • User Name: The user name to access the Oracle Warehouse Management Cloud Service instance

   • Password: The password to access the Oracle Warehouse Management Cloud Service instance

7. Click Verify Connectivity and ensure that you receive a connection successful message.
8. Click Save.
9. On the Integrations page, your integration is listed. Click Edit Connection Details ( ) to modify the connection details or click Delete () to remove the integration.
10. To configure the integration, click Configure WMS Integration.
11. On the WMS Configuration dialog box, enter values for these fields:

    • Inbound Dock Type Name: Enter IB as the Dock Type definition to map inbound shipping data

    • Onbound Dock Type Name: Enter OB as the Dock Type definition to map outbound shipping data

    • ETA Update Tolerance (seconds): Enter the time interval at which the appointment in Oracle Warehouse Management Cloud Service gets updated

    • Check-in Geo-fence Radius (miles): Enter the value for the radius of the default check-in geo-fence of the imported facilities, in miles

12. Click Save.
    After you've configured the integration, to import the IoT enabled facilities from Oracle Warehouse Management Cloud Service, see Import and Manage Facilities.

About IoT Enabled Warehouse and Transportation Management Solution

Integrating Oracle Transportation Management Cloud Service and Oracle Warehouse Management Cloud Service with Oracle IoT Fleet Monitoring Cloud Service improves global supply chain efficiency by increasing facility throughput, improving efficiency of dock appointments, and accelerating delivery times of subsequent shipments.

After you integrate Oracle Transportation Management Cloud Service and Oracle Warehouse Management Cloud Service with Oracle IoT Fleet Monitoring Cloud Service, you can track the location and activity of fleet vehicles and efficiently manage warehouse yard operations. Sensors connected to each vehicle use cellular, satellite, or bluetooth connections to transmit real-time vehicle location and performance data to your Oracle IoT Fleet Monitoring Cloud Service instance.

You can use real-time and historic vehicle location and performance data to determine where changes can be implemented to improve customer satisfaction, reduce operating costs, and increase driver safety. Moreover, by watching over your shipments, you can keep customers aware of any potential delays and you always know where their packages are and when they will be delivered.

Typical Workflow Between the Three Applications

The flow between the three service is illustrated in the image and explained after it.

1. Oracle Transportation Management Cloud Service plans shipments for outbound orders that are required to be shipped out from a warehouse facility.
2. The planned shipment information is sent to Oracle IoT Fleet Monitoring Cloud Service and Oracle Warehouse Management Cloud Service by Oracle Transportation Management Cloud Service.
3. Planned shipments and routes are synchronized with Oracle IoT Fleet Monitoring Cloud Service, so that it can perform accurate in-transit shipment monitoring and freight charge reconciliation.
4. An internal load is generated in Oracle Warehouse Management Cloud Service for the planned shipment and Oracle IoT Fleet Monitoring Cloud Service is notified of the warehouse load.
5. If an appointment does not exist in Oracle Warehouse Management Cloud Service for this load, Oracle IoT Fleet Monitoring Cloud Service creates an appointment in Oracle Warehouse Management Cloud Service based on the ETA of the planned shipment.
6. With the help of Oracle Transportation Management Cloud Service, a truck is sent out to load the shipment from the warehouse facility.
7. Oracle IoT Fleet Monitoring Cloud Service continues to monitor the truck, and any change to the ETA due to unexpected events, is updated on the appointment in Oracle Warehouse Management Cloud Service.
8. As the truck enters the geo-fence area, a device connected to the vehicle sends real time data to Oracle IoT Fleet Monitoring Cloud Service, which checks with Oracle Warehouse Management Cloud Service for dock door availability. If a dock door is available, the truck is checked-in at the dock door. If a dock door is not available, the truck is directed to the yard.

To learn how to integrate the three services, see Improve supply chain efficiency by integrating IoT with warehousing and transportation workflows.