Contact Center Error: APP-FND-01564 And ORA-0100:maximum open cursors exceeded
Last updated on MARCH 04, 2016
Applies to:Oracle Customer Care - Version 188.8.131.52 and later
Information in this document applies to any platform.
***Checked for relevance on 28-Jul-2014***
When attempting to create SR
the following error occurs.
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
The issue can be reproduced at will with the following steps:
1. Upgrade from 11.5.9 to 184.108.40.206
2. Open Contact Center Form
3. SR tab
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
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