ORA-28112 results if SELECT or DML is performed on a table with an associated policy function and the policy function has policy-related errors.
Check your policty function , is it in "valid" status?
unfortunately this error from the support perspective is usually classified as a 'user error' :) but of course
we can help you find the cause, there are some troubleshooting references in MOS here:
How To Diagnose Error ORA-28112 (Doc ID 751850.1)
How To Resolve ORA-28110 or ORA-28112 On SELECT Or DML (Doc ID 69401.1)
Another simple test I recommend is to execute the policy predicate function independently
and see if the value it returns makes any sense, so any issues may become clear:
select HR.POLICY_FUNC('user','object') from dual;
Please note we are currently actively promoting the new support communities also, so if you want to get some
feedback from your peers as well as the attention of Oracle support engineers, please go to
This will put you in the Database Products Security community , but you can select others also from the left,
Harm ten Napel