Integrate with Oracle Transportation Management

Integrating Oracle Transportation Management with Oracle IoT Fleet Monitoring Cloud Service makes it easier to access and share Oracle Transportation Management shipment data. The integration increases efficiency and provides a better customer experience because you always know the location of a shipment.

To integrate Oracle Transportation Management with Oracle IoT Fleet Monitoring Cloud Service your systems integrator completes these tasks in Oracle Transportation Management:

• Create an External System

  The endpoint URL for this external system is https://hostname/iotapps/serviceapi/v1/transportation?defaultNS=true where hostname is the name of the computer hosting your Oracle Internet of Things Cloud Service instance.

• Set up External Status Type

• Create Saved Queries and Conditions

• Create Custom Contacts for Agent Errors

• Create a Remark Qualifier

• Create Send, Update, Delete, Fleet Monitoring Tracking Agents

When the Oracle Transportation Management tasks are complete, the systems integrator completes these tasks in Oracle IoT Fleet Monitoring Cloud Service:

• Map Oracle Transportation Management Users

• Connect to an Oracle Transportation Management Cloud Service Instance

When your systems integrator completes the integration tasks, drivers select a shipment, vehicle, and a route in the Oracle IoT Fleet Monitoring Mobile Application. After the shipment is selected it can be monitored in the shipment map view. See Monitor Shipments and Facilities.

See Oracle Transportation and Global Trade Management Cloud Integrating with Oracle Internet of Things Fleet Monitoring Guide for details about the integration set up, sample work flows, and seeded data.

To request assistance configuring Oracle Transportation Management, contact Oracle Fusion Cloud IoT Intelligent Applications support. See How to Get Support.

Map Oracle Transportation Management Users

To map Oracle IoT Fleet Monitoring Cloud Service drivers to Oracle Transportation Management drivers, create and upload a comma-separated value (CSV) file that maps the Oracle Transportation Management driver identifier to the Oracle IoT Fleet Monitoring Cloud Service driver identifier.

Note:

User mapping is only necessary if you are operating in private fleet mode and the drivers are Oracle IoT Fleet Monitoring Cloud Service and Oracle Transportation Management (OTM) users.

Obtain a valid OTM user with a driver role from the OTM admin .

The Oracle IoT Fleet Monitoring Cloud Service user is a valid user with a driver role and has been added to the default organization’s users list.

Before you upload the mapping file, View Existing User Mapping Information.

1. Click the Menu () icon, and then click Design Center.
2. From the Design Center menu options, click Organization
3. Click Import Data
4. From the Import Data for drop down, select User Mapping, and then click Click here to download a sample CSV file for: User Mapping.
5. Click Save File .
6. Click OK and browse to a location to save the file.
7. Click Save.
8. Browse to the location where you saved the .csv file.
9. Open the .csv file and complete these fields:
   • #TM User Id: Enter the Oracle Transportation Management user identifier.
   • FM User Id: Enter the Oracle IoT Fleet Monitoring Cloud Service to which the Oracle Transportation Management user should be associated.
   • Actions: (Optional) Enter delete or DELETE to remove mapping for the specified user.
10. Save and close the .csv file.
11. From the Import Data for drop down, select User Mapping, and then click Select File
12. Browse to the location where you saved the csv file and select it. On the Import Data page, verify that your csv file is visible and then click Import
13. On the Upload User Mapping CSV Data page, after you receive a successful message, click Back.

View Existing User Mapping Information

After integrating Oracle Transportation Management (OTM) with Oracle IoT Fleet Monitoring Cloud Service, you need to map the registered drivers of Oracle IoT Fleet Monitoring Cloud Service with the OTM drivers.

You should have configured an integration between Oracle IoT Fleet Monitoring Cloud Service and OTM, and then uploaded a comma-separated value (CSV) file that maps their respective driver users. Complete these steps to view this user mapping information.

1. Click the Menu () icon, and then click Design Center.
2. From the Design Center menu options, click Organization.
3. On the Organization page's lower section, click Users Mapping .

A table is displayed with two columns where each row has an OTM user ID mapped to its corresponding Fleet Monitoring app's user ID.

Connect to an Oracle Transportation Management Cloud Service Instance

To share Oracle Transportation Management (OTM) shipment data in an organization, you specify the URL, domain name, and access credentials for the Oracle Transportation Management instance.

You can create the integration in Default Organization or switch to the appropriate organization before you configure the integration. See Change Your Current Organization. You should have the OTM instance URL, domain name, and the credentials to access it.

1. Click the Menu () icon, and then click Design Center.
2. From the Design Center sub-menu, click Organization
   The Default Organization page appears
3. Click the Integrations () icon.
4. Expand Oracle Transportation Management and then click OTM Configuration. On the OTM Configuration screen, to enable the integration, slide the Integration Status button.
   You need to perform this step only once for an organization.
5. (Optional) If attributes' data, such a sensor values or metrics of an entity that have been used in rule conditions, need to be sent with the event payload, then enable the Send Rule Attributes flag.
   OTM is configured with refnums/value pairs and mapped to relevant attributes and values for it to accurately interpret the attributes that it receives in event notifications.

   if this flag is enabled only then the refnum/value pair would be sent to OTM otherwise it would be excluded from the event notification.

6. If you want the arrival and departure date and time that a third-party carrier driver manually enters in the mobile app for Shipment stops to be propagated to OTM, then you must enable the Send Driver Manual Events flag. Optionally, you can enter the event codes that must be transmistted to OTM in the Driver Arrived Location and Driver Departed Location fields. The default values are DRIVER ARRIVE and DRIVER DEPART respectively. If the Send Driver Manual Events flag is disabled, then the arrival and departure values are captured and saved as driver-provided start and end times only in Fleet Monitoring.
7. To save the changes, click Save and then click Close .
8. In the Oracle Transportation Management System section, click Add Integration.
   The OTM Connection screen appears and the Integration Status appears enabled.
9. Enter the following values in these fields:
   • URL: Enter the URL for the Oracle Transportation Management Cloud Service instance. Replace myOTM.com in the example and do not modify the remaining URL components. The complete URL must include /GC3/glog.integration.servlet.WMServlet.
   • Domain: Enter the external ID of OTM whose shipment data is exported to this organization of Oracle IoT Fleet Monitoring Cloud Service.
   • Username: Enter the user name to access the Oracle Transportation Management Cloud Service instance in this field.
   • Password: Enter the password to access the Oracle Transportation Management Cloud Service instance in this field.
   • (Optional) Description: Enter a description for this integration.
   • (Optional) Verify Connectivity: Click to verify the connection to the Oracle Transportation Management Cloud Service instance. You'll receive a connection successful message.
10. Click Save.
    On the Integrations screen, beneath Oracle Transportation Management, the domain name and its description, if you've added, are displayed. OTM integration and mapping its domain with the organization is complete. To map another domain with this organization, repeat the previous three steps of this task.

Customize Oracle Transportation Management Cloud Service Transmission Codes

Transmission codes identify the data being sent to your Oracle Transportation Management Cloud Service instance. Edit these codes to meet your specific business requirements.

1. Click the Menu () icon, and then click Design Center.
2. From the Design Center menu options, click Organization
3. Click Integrations () icon.
4. In the Oracle Transportation Management section, click OTM Configuration.
   The transmission codes are displayed with their descriptions. There are 4 categories of codes such as Arrival Event Codes, Departure Event Codes, En-route Position Event Codes, and Shipment Link Event Codes.
5. Make sure that Integration Status is enabled.
6. (Optional) In the Arrival Events area, edit the values in the Status fields.
7. (Optional) In the Departure Events area, edit the values in the Status fields.
8. (Optional) In the En-route Position Events area, edit the values in the Status fields.
9. (Optional) In the Shipment Link Events area, edit the values in the Status fields..
10. Click Save.

Set the Oracle Transportation Management Security Settings

Oracle Transportation Management uses wildcard security certificates. To exchange data with Oracle IoT Fleet Monitoring Cloud Service you need to set the trusted CN to work with wildcard certificates.

1. Open a web browser and browse to the location of your Oracle Fusion Cloud IoT Intelligent Applications instance.
   Typically, the format of the URL for the Oracle Fusion Cloud IoT Intelligent Applications instance is https://hostname/ui where hostname is the host name of your Oracle Fusion Cloud IoT Intelligent Applications instance.
2. Enter your user name and password and then click Sign In .
3. Click Menu () and then click Settings. .
4. Scroll to the Security area and then complete these fields:
   • Allowed Hosts for Cross-Origin Resource Sharing: Enter *
   • Trusted CN: Enter *.<OTMdomain>.com