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
Summary
VPD Restrict Data AccessContent
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
0