My Oracle Support Banner

Shipments Are Not Visible On Mobile Driver Flow (Doc ID 2538284.1)

Last updated on MAY 03, 2019

Applies to:

Oracle Transportation Management Cloud Service - Version 19 and later
Oracle Transportation Management - Version 6.4.3 and later
Information in this document applies to any platform.

Symptoms

Mobile Driver Flow not pulling the Driver's Shipments.

You have created the OTM User and assigned the DRIVER Role, and associated the OTM User with this Driver via User Association.
The Driver is assigned to Shipments, but the Mobile is not pulling these shipments.

This query is not returning any shipments.

select distinct s.SHIPMENT_GID , s.SERVPROV_GID from SHIPMENT s where s.DRIVER_GID in (select USER_ASSOCIATION_VALUE from USER_ASSOCIATION where USER_ASSOCIATION_QUAL = 'DRIVER' and GL_USER_GID = 'DEMO.ECARRANZA') and start_time >= SYSDATE - 14order by s.SHIPMENT_GID

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.