Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Tuesday, January 29, 2013

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.



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.

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.

No comments: