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

Last updated on APRIL 16, 2015

Applies to:

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

Symptoms

On : 11.1.8.0.0 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:


ERROR
-----------------------
Bank branch import warning. Review the exception details. oracle.as.scheduler.ExecutionWarningException: 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



STEPS
-----------------------
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'


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

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