VPD to allow access for order release for servprov?

[tangfj]

Has anyone ever tried to give access to a servprov for order releases for only those order releases where they are the servprov assigned on the constraints tab?

I have tried modifying the VPD profile for servprov and added an external predicate for the table ORDER_RELEASE. The predicate I added was:

order_release.servprov_gid IN (SELECT user_association.user_association_value FROM user_association WHERE user_association.gl_user_gid = sys_context('gl_user_ctx', 'gl_user_gid'))


Then I modified the servprov menu and added a link for order releases. When I login as a servprov and search for order releases, though, I always end up with zero results. Anyone have any idea what's going on here? Is there additional security that OTM has that I need to get around so that I can give a servprov access to order releases?

[tangfj]

Re: VPD to allow access for order release for servprov?

Ok, so I figured out that if I turn off "Use Domain Rule" in the VPD profile for SERVPROV then it works and I can search for Order releases/etc... but does anyone know what impact turning off "Use Domain Rule" has in OTM? The help file is a little vague about this.

[leo.heckmann]

Re: VPD to allow access for order release for servprov?

Hi! I think the Domain rule simply adds a '& limit the search to the object the predicates are querying within the domain the VPD profile is written' clause to the predicates. As the predicate itself is always saved as DBA, I would think that turning off 'Use Domain Rule' means you will not filter by current domain. This is probably why you do see the orders once you turn it off because the orders are most likely not in SERVPROV domain, but I am assumning the VPD Profile is...

[cunninghamg]

Re: VPD to allow access for order release for servprov?

Hey Leo

Surely any Shipments that would normally visible to a servprov would also be in a different domain!

Gary