You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need to make Action Check to prevent Assign Driver

edited Sep 17, 2026 7:52AM in Transportation Management 1 comment

Summary:

I managed to write the Condition in SQL and Tested it externally and works fine but in OTM When I choose the Audit Action "Assign Driver to Shipment" and Post Action Check, OTM fire error (Post action check is not supported on action ASSIGN DRIVER TO SHIPMENT)

i used this query

SELECT 1 AS RESULT FROM DRIVER D INNER JOIN ( SELECT DA.DRIVER_GID, DA.NEXT_AVAILABLE_LOC_GID, ROW_NUMBER() OVER ( PARTITION BY DA.DRIVER_GID ORDER BY DA.INSERT_DATE DESC ) AS RN FROM DRIVER_ASSIGNMENT DA ) DA ON DA.DRIVER_GID = D.DRIVER_GID AND DA.RN = 1 WHERE D.DRIVER_GID = (SELECT DRIVER_GID FROM SHIPMENT WHERE SHIPMENT_GID = ?) AND ( D.ATTRIBUTE8 IS NULL OR ( D.ATTRIBUTE8 IS NOT NULL AND ( NOT EXISTS ( SELECT 1 FROM LOCATION_ROLE_PROFILE LP WHERE LP.LOCATION_GID = D.DEF_HOME_LOC_GID AND LP.LOCATION_ROLE_GID = 'EQUIPMENT POOL' ) OR D.DEF_HOME_LOC_GID = D.ATTRIBUTE8 ) AND ( NOT EXISTS ( SELECT 1 FROM LOCATION_ROLE_PROFILE LP WHERE LP.LOCATION_GID = DA.NEXT_AVAILABLE_LOC_GID

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!