"ORA-01000: maximum open cursors exceeded" Error During Data Import of ItemExport.xml into Oracle Retail Back Office

(Doc ID 2204913.1)

Last updated on JANUARY 12, 2018

Applies to:

Oracle Retail Back Office - Version 13.3 and later
Information in this document applies to any platform.


When attempting to import a large volume of items and promotions into Oracle Retail Back Office, the number of open cursors increases and the data connections are not closed.

Steps to Reproduce:

  1. Allow the ORBO domain to run for a long time.
  2. Import large volumes of data into BO, including item and pricing files.
  3. Check the backoffice.log for open connection errors.


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