How to add Action check on Secure resources — Cloud Customer Connect
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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

How to add Action check on Secure resources

in Transportation Management 12 comments

Summary:

How to add Action check on Secure resources so that prevent the action whilst the same driver is assigned to another enroute_enroute shipment

We have tried the following Action check with saved query as follow but still not working:

SELECT 'Y'

FROM DUAL

WHERE not EXISTS

(SELECT SHIPMENT_GID

FROM SHIPMENT_STATUS

WHERE STATUS_TYPE_GID = 'TM.ENROUTE'

AND STATUS_VALUE_GID = 'TM.ENROUTE_ENROUTE'

AND SHIPMENT_GID in (SELECT X.SHIPMENT_GID

FROM driver_assignment X

WHERE X.DRIVER_GID = ?))

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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