1. Improve supply chain efficiency by integrating IoT with warehousing and transportation workflows
  2. Configure Oracle Warehouse Management Cloud Service

Configure Oracle Warehouse Management Cloud Service

Connect Oracle IoT Fleet Monitoring Cloud Service and Oracle Transportation Management Cloud Service to align operations to real-time fluctuations and improve warehouse operations efficiencies by reducing unnecessary shipping costs, manual errors and quality issues.

Connect to an Oracle IoT Fleet Monitoring Cloud Service Instance

Configure Oracle Warehouse Management Cloud Service to send outbound messages to IoT Fleet Monitoring Cloud Service.

  1. Sign in to Oracle Warehouse Management Cloud Service and go to Scheduled Jobs.
  2. Create schedule jobs for Appointment Check Out and Planned Load Notification. You can either create one schedule job for both the activity codes or two separate jobs for each activity code. The alerts are automatically sent as and when they are created.
    • For the Appointment Check Out scheduled job, add the following information:
      • Include activity IDs list: 45
      • Username: <Oracle Warehouse Management Cloud Service user with administrative privileges>
      • Enabled: select the check box to make the schedule job active.
    • For the Planned Load Notification scheduled job, add the following information:
      • Include activity IDs list: 84
      • Username: <Oracle Warehouse Management Cloud Service user with administrative privileges>
      • Enabled: select the check box to make the schedule job active.
    Description of scheduled_jobs.png follows
    Description of the illustration scheduled_jobs.png
  3. Ensure that Auto Process Flag and Enable auto send flag are set to No in Inventory History Activity Parameters for activity codes 45 and 84. If the flags are not set to No, use Disable Auto Process or Disable Auto Send whichever relevant, to turn the flags to No. Note that while turning these flags on or off, Oracle Warehouse Management Cloud Service will prompt for an administrative password.
  4. The alerts are sent via the Output Interface setup. Go to the Output Interface Configuration for Inventory History Export, set the Interface Format field to XML.
  5. Click the Details icon to open the Output Interface Target page.
  6. Click + and create a target for Inventory History Export and set the following values:
    • URL: http://myIoT.com/fleetMonitoring/privateclientapi/v2/wms/ihtcallback Replace myIoT.com and do not modify the remaining URL components.
    • Interface Protocol = REST Web Service
    • Username = Enter the name that you used for your Oracle Internet of Things (IoT) Fleet Monitoring Cloud Service instance.
    • Password = Enter the password for your Oracle Internet of Things (IoT) Fleet Monitoring Cloud Service instance. If your account password expires or is changed, you have to change here as well.
  7. After creating a target, select the Details icon to open the output_interface_target_criteria view.
  8. Click + and create a Criteria for the Interface Target and set the following values:
    • Select Activity Code from the Column name drop-down menu
    • Select IN from the Sql operator drop-down menu
    • Column value = 45|84
You can check the status of outbound messages in the Output Interfaces page. Description of output_interfaces.png follows
Description of the illustration output_interfaces.png

If you see a Failed status, select the message and click Interface Logs to get detailed information about the transmission of that message and reason for failure.

Connect to an Oracle Transportation Management Cloud Service Instance

This section covers the configuration required in the three applications to open the communication channel between the systems. Any pre-requistes for data setup within Oracle Transportation Management Cloud Service and Oracle Warehouse Management Cloud Service or extending integrations within Oracle Integration is outside the scope.

Follow these steps to configure endpoints and set up integration package connections from your Oracle Integration account.
In the navigation pane on the left, go to Download and click My Oracle Support. You can use the sample WMS_OTM_Sample_Integration package for the integration. You need to have your sign in credentials for My Oracle Support to get the sample package. Once you sign in, download this WMS_OTM_Sample_Integration package to your local directory.
  1. Sign in to Oracle Integration.
  2. Click Packages on your home screen and click Import, and import the sample OCWMS_OTM package that you downloaded to your local directory.
  3. You can see the package in your Oracle Integration instance along with three integrations. These three integrations can also be viewed by clicking on Integrations on the left pane.
    After importing the package, the integration connections will be available in the Integration package site, but you will need to configure your URLs and connections for OCWMS REST.
  4. Click Connections on the left pane and search for OCWMS REST.
  5. Enter the following fields for your Connection Properties:
    • Connection Type – REST API Base URL
    • TLS Version - TLSv1.2
    • Connection URL: https://<instancenodename>.wms.ocs.oraclecloud.com/<customerid>/index/
    • Under Security, complete the Basic Authentication fields.
  6. From Connections, provide your Oracle Integration credentials so that you can configure your Echo connection. Click Connections, select OCWMS Echo LgfData Invoke.
    • Connection Type – REST API Base URL
    • Connection URL: https://<yourintegrationinstance>.integration.ocp.oraclecloud.com/ic/api/integration/v<version_nbr>/flows/rest/OCWMS_ECHO_LGFDATA/<version>/echo
    • Under Security, complete the Basic Authentication fields.
  7. Similarly, LOGISTICS_CONNECTION needs to be configured. Make sure that you point the WSDL URL to Oracle Transportation Management Cloud Service TransmissionService WSDL. The user configured here should have an INTEGRATION role in Oracle Transportation Management Cloud Service.
  8. Click Connections and search for LOGISTICS_CONNECTION. Enter the following in Connection Properties:
    • Connection URL: https://<yourOTMinstance>/GC3Services/TransmissionService/call?wsdl
    • Under Security, complete the Basic Authentication fields.
  9. Go to Integrations and activate the following three integrations:
    • OTM_OCWMS

      Initially your OCWMS integration will be inactive. You can click the Activate or Deactivate (toggle button) to update your integration under the Last Updated column.

    • OCWMS Actual Shipment
    • OCWMS Echo LgfData

      If the application does not allow you to activate OCWMS Echo LgfDatafor Oracle Transportation Management Cloud Service, go to Connections, search for OCWMS ICS REST and hit Test and ensure that it shows 100%. Hit test even if it was already at 100%, it'll succeed.

    Once the integration is active, provide the endpoint configuration in Oracle Warehouse Management Cloud Service and Oracle Transportation Management Cloud Service applications respectively.
  10. From your Oracle Integrations, select OTM_OCWMS and click How to Run to go to the endpoint. You need to use the WSDL URL to configure an end point in Oracle Transportation Management Cloud Service.
  11. Now go to the Oracle Transportation Management Cloud Service section and complete the integration.