Shipments Are Not Visible On Mobile Driver Flow
(Doc ID 2538284.1)
Last updated on DECEMBER 08, 2021
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.
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 = 'DOMAIN.USER') and start_time >= SYSDATE - 14order by s.SHIPMENT_GID
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