"ORA-01000: Maximum Open Cursors Exceeded" Errors Are Occurring During Integration (Doc ID 866873.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version 5.5.04 to 6.1.0 [Release 5.5 to 6.1]
Information in this document applies to any platform.
***Checked for relevance on 14-Mar-2013***


Symptoms

-- Problem Statement:

When attempting to send numerous Orders via Integration the following error occurs:

ERROR
ORA-01000: Maximum Open Cursors Exceeded Errors

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Make changes in the Legacy System
2. Order Release is updated in OTM
3. New information / updates are sent out via Integration
4. Receive the error: ORA-01000 Maximum Open Cursors Exceeded

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