Oracle VPD (Virtual Private Database) is a good feature for OTM (Oracle Transportation Management to control access. However, it is still technically challenging to maintain VPD directly for users. This is why we can configure VPD to parameterise for users. This way, users can maintain access control via the screen or masterdata setup. Contact group and attribute field VPD are the most common ways to extend OTM VPD for users.
Contact Group VPD
The most common configuration of VPD setup in order release or shipment is to set the involved party. Then, you will create the same name of involved party for your contact group. Users that required access to the data will be added to this contact group. This way, you can control access without amending the VPD.
Attribute Field VPD
Another common method is to VPD to the attribute fields. The field will be a variable control to determine what can be shown to the users. This attribute can be dynamic or a masterdata setup. The usage of attribute is to speed up the VPD as it reside on the data table itself. Another key reason is that you can allow super user to inline edit attribute field to allow access.
OTM VPD are useful for access control to data. However, updating VPD directly is highly technical and cannot be maintained by users. This is why you can configure contact group or use attribute fields to dynamic control your VPD. Users also have the options to amend this fields as well.