Contact Center Error: APP-FND-01564 And ORA-0100:maximum open cursors exceeded (Doc ID 1264909.1)

Last updated on MARCH 04, 2016

Applies to:

Oracle Customer Care - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 28-Jul-2014***

Symptoms

 

When attempting to create SR
the following error occurs.

ERROR
-----------------------
APP-FND-01564:ORACLE error 1000 in audfrm
Cause:audfrm failed due to ORA-0100:maximum open cursors exceeded

The SQL statement being executed at the time of the error was :&SQLSTMT and was executed from the file &ERRFILE


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade from 11.5.9 to 11.5.10.2
2. Open Contact Center Form
3. SR tab

Changes

The initialization parameter OPEN_CURSORS in INITSID.ORA/ SPFILE determines the maximum number of cursors per session.

Check the parameter specified by executing the following SQL:

select * from v$parameter
where name = 'open_cursors'
/
If you want more cursors to be opened at the same time, shut the database, change INITSID.ORA or SPFILE and restart the database, or just execute:

alter system set open_cursors=3000 scope=both
/

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