We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

How to user SQL predicate in a security rule condition

Received Response
edited Oct 9, 2019 6:14AM in General Ledger & Intercompany 1 comment


How to user SQL predicate in a security rule condition


We have a requirement to enable security segment at cost center level. 
One security rule for restricted OU (List of restricted OU are child value kept under a parent OU)- we have used tree structure for that - parent value P50000000 
one rule for non restricted OU - we need to write rule as if values are not in restricted OU parent - IF child values are not in under parent P50000000 
And one rule is for ALL OU 

We need help on what SQL predicate needs to be used for non restricted OU rule condition 

Howdy, Stranger!

Log In

To view full details, sign in.


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