You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

VPD Profile not working as expected

I have written below predicate so that orders meant for specific Divsion are visible to certian people. (Order Release)

(exists (select 'x' from user_association where user_association.gl_user_gid = SYS_CONTEXT('gl_user_ctx','gl_user_gid')
and user_association.user_association_qual = 'DIVISION' and user_association.user_association_value = order_release.attribute1)
and exists (select 'x' from user_association where user_association.gl_user_gid = SYS_CONTEXT('gl_user_ctx','gl_user_gid')
and user_association.user_association_qual = 'DIVISION' and user_association.user_association_value = order_release.attribute1))

I have also done user association with DIVISION qual and value as 'ABC' .

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!