My Oracle Support Banner

"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 AUGUST 14, 2020

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(ORBO), 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.




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.