Announcement

Collapse
No announcement yet.

Creating VPD profile using User assocation

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Creating VPD profile using User assocation

    Hi,
    we have very basic requirement of "every supplier or source location's user should see their data (order release, shipment etc). In this regard, we have written VPD profile as below, but it does not seem to be working.

    Can someone throw a comment on this quickly ?

    EXISTS (SELECT 'X' FROM USER_ASSOCIATION UA,location L where order_release.SOURCE_location_gid =L.location_gid and UA.GL_USER_GID =SYS_CONTEXT ('GL_USER_CTX','GL_USER_GID') AND UA.USER_ASSOCIATION_VALUE = L.location_GID AND UA.USER_ASSOCIATION_QUAL = 'SUPPLIER_CORP')

    we have accordingly created user association as below :
    user id : domain.supplier1
    USER_ASSOCIATION_QUAL = 'SUPPLIER_CORP'
    USER_ASSOCIATION_VALUE = DOMAIN_NAME.GRE

    though we have a data in order releases, it is throwing 0 values, where are other simple VPD profile are working

    regards
    Ashok Revuri

Working...
X