Extend OTM VPD for Users

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s