ORA-28112: failed to execute policy function

On some client side, today a developer got the errorORA-28112: failed to execute policy function, while running the few Oracle forms.

 

Reason:

ORA-28112: failed to execute policy function occurs when the policy function encounters some run time errors, typically unhanded exceptions. Fortunately, the error will produce a trace file in the user_dump_dest directory that can be examined and the error can be corrected.You need to see the trace file for additional details on the ORA-2812 error.

On Oracle 11gR2, you will find the trace file in the folder like below.
D:\app\inam\diag\rdbms\homedb\homedb\trace
Find the trace file  and review for details (I found homedb_ora_6364.trc)

Policy function execution error:
Logon user     : HOME_SHAWISH
Table/View     : HOME.FIN_REQ_DTL
Policy name    : CMP_REQ_DTL
Policy function: HOME.CMP_POLICY_FNC
ORA-01000: maximum open cursors exceeded

The reason for this particular incident was due to the open_cursors value which was increased to resolve.