"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 NOVEMBER 28, 2016

Applies to:

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

Symptoms

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.

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