Oracle Error Message
ORA-28111: insufficient privilege to evaluate policy predicate
Reason for the Error
Predicate has a subquery which contains objects that the owner of policy function does not have privilege to access.
Solution
Grant appropriate privileges to the policy function owner.