"java.sql.SQLException: ORA-01000: maximum open cursors exceeded" Error When Loading TransOrder Elements via Integration (Doc ID 831986.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Transportation Management - Version 5.5.05 to 6.0.2 [Release 5.5 to 6]
Information in this document applies to any platform.
***Checked for relevance on 16-Dec-2013***


Symptoms

-- Problem Statement:

When many TransOrder elements are submitted via integration, eventually an error is received for maximum number of open cursors exceeded.

"java.sql.SQLException: ORA-01000: maximum open cursors exceeded"

-- Steps To Reproduce:

Load TransOrder elements via integration.

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