My Oracle Support Banner

Unable to Login to OFSAA After Upgrading AAI To / "ORA-01000: maximum open cursors exceeded" Error Upon Running (Doc ID 2432878.1)

Last updated on DECEMBER 02, 2020

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.5 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)


Unable to login OFSAA Application after upgrading OFSAA via Patch 27504805 - CONSOLIDATED FIXES OF ALL ISSUES IDENTIFIED IN AAI COMPONENTS POST 8051 ML

None of the users can log into the OFSAA application anymore. When users attempt to login, error message is being displayed on the screen.

Login was not allowed either while using decrypted credentials data from database.

When verifying installation logs, ORA-01000 error message was found while executing script. script seems to have been run successfully for only 1000 of the total users.


[11778] Please Contact Your System Administrator.

ORA-01000: maximum open cursors exceeded



The issue can be reproduced at will with the following steps:

  1. Apply Patch 27504805.
  2. Check whether there are any login issues in the environment.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.