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

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

VPD Restrict Data Access

Received Response
15
Views
3
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics 3 comments

Summary

VPD Restrict Data Access

Content

Hello,

I'm working on OTM  V 6.4.2 and I want to make it required that, when a service provider declines a tender, he needs to fill a reason code.

Thus i'm creating a VPD for service providers and it has to have this structure (can't change it):

"select * from tablename where ...."

but after the where I don't know what to put as I am a newbie in SQL. I want to say "if acceptance_code = 'D' then decline_reason_code can't be null "

Thanks

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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