My Oracle Support Banner

Bank/Branch Import Fails With ORA-01000 Maximum Open Cursors Exceeded (Doc ID 2000186.1)

Last updated on APRIL 02, 2019

Applies to:

Oracle Fusion Cash Management Cloud Service - Version and later
Information in this document applies to any platform.


On : version, Set Up CTM-Define Banks, Branches, and Accounts

Attempting to import 17,000 US bank branches through the Rapid Implementation spreadsheet. Looking to create the Banks and the Bank Branches, no accounts. Import fails with the following error:

Bank branch import warning. Review the exception details. Bank branch import failed with errors. Error Details:
Client received SOAP Fault from server : JBO-27122: SQL error during statement preparation.
  . . . . .
ORA-01000: maximum open cursors exceeded

The issue can be reproduced at will with the following steps:
1. Populate the RapidImplementationForCashManagement.xlsm template
2. Load the data using the process 'Upload Banks, Branches, and Accounts'

The issue has the following business impact:
Due to this issue, users are unable to import banks and branches.


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.