[cool_brat]

Hi,

I am trying to restrict the access to a user by removing rate contract / rate inquiry from assign function option. But its leading to having the problem at shipment viewing screen since shipment has a tab where rate records are reflected. How can I remove the access to the rates through VPD option in this case.


Note: I don't want to use domain grants here.

regards
Vipin

[Srivathsana]

Hi Vipin,

Please try the below predicate against the rate_geo and rate_offering tables in your VPD and let me know how it fits your requirement.

domain_name<>domain_name


This predicate will make the application throw an error of invalid rate record,rate offering when the user tries to view the rate inside the shipment screen but the user will be able to navigate though.
Hope you can use a custom menu to hide the RIQ for the user.

[cool_brat]

Hi Srivathsana,

Can you provide the predicate - that seems missing here!

regards
Vipin

[Srivathsana]

Hi Vipin,

The predicate is "domain_name<>domain_name" this needs to be mentioned against the rate_geo and rate_offering tables.
Please give a shot at it and provide me your feedback.