Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

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

Summary

How to user SQL predicate in a security rule condition

Content

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.

Register

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