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

Manage User Access saved query issue

Hi ,

I am looking for restricting the user from performing the rerate and redrive action wherein user is having the Dispatcher qualifier as involved party .

I am using the below saved query but that does not fetch the user name in run time in the saved condition.

SELECT 1 FROM SHIPMENT_INVOLVED_PARTY SIP
, SHIPMENT S WHERE SIP.SHIPMENT_GID = S.SHIPMENT_GID
AND SIP.INVOLVED_PARTY_QUAL_GID = 'DSC.DISPATCHER'
AND SIP.INVOLVED_PARTY_CONTACT_GID = SYS_CONTEXT('GLOG_USER_CTX','LOG_IN_USER_GID') and S.SHIPMENT_GID = ?

also used the below

SELECT S.SHIPMENT_GID
FROM SHIPMENT S

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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