Customer Form Error: FRM-40735: ON_ERROR trigger raised unhandled exception ORA-01001, After Upgrading To RDBMS 11.2.0.3.0 (Doc ID 1451312.1)

Last updated on JULY 25, 2016

Applies to:

Oracle Receivables - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

After upgrading to RDBMS version 11.2.0.3.0, the Customer Form fails with the following:

FRM-40735: ON_ERROR trigger raised unhandled exception ORA-01001.
FND-01564: ORACLE error 1000 in audfrm
Cause: audfrm failed due to ORA-01000: maximum open cursors exceeded
 
The SQL statement being executed at the time of the error was: &SQLSTMT and was executed from the file &ERRFILE.
 
FRM-40735: ON_ERROR trigger raised unhandled exception ORA-01001
 
FRM-92100: Your connection to the Server was interrupted. This  may be the results of a network error, or a failure on the Server.  You will
need to reestablish your session

Click OK, get the same pop up error again
 
Click OK, get get
  APP-FND-01564: ORACLE error 1000 in audfrm
  Cause: audfrm failed due to ORA-01000: maximum open cursors exceeded

 
The SQL statement being executed at the time of the error was: &SQLSTMT and was executed from the file &ERRFILE.
 
click OK, and get:
  FRM-40735: ON_ERROR trigger raised unhandled exception
  ORA-01001 again

 
click OK, and get
  FRM-92100: Your connection to the Server was interrupted. This may be the results of a network error, or a failure on the Server. 
  You will need to reestablish your session.
 
click OK and the Navigator form disappears and you have to log back in.

Changes

Upgrade RDBMS to 11.2.0.3.0

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms