My Oracle Support Banner

Shipping Inboound Transactions Are Consuming All The Cursors And Error With ORA-01000: Maximum Open Cursors Exceeded (Doc ID 2601315.1)

Last updated on OCTOBER 20, 2019

Applies to:

Oracle Shipping Execution - Version 12.2.5 and later
Oracle XML Gateway - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

Observe that the Shipping Inbound Transactions are consuming all the cursors.
It appears to be caused by the business event:  oracle.apps.wsh.line.gen.readytorelease.
This results in the following error:

ERROR
_______

msg=ORA-01000: maximum open cursors exceeded



Details:
Issue was logged with the Worklfow team where the Agent listener Service goes down and the error is showing Max Cursors Reached.
Patches in place for this, but the issue still happens quite frequently.

Workflow team requested an Event Trace for when ORA-01000 happens and identified the following: oracle.apps.wsh.line.gen.readytorelease

The trace file shows the following:
------------------
2019-04-04 09:56:17.553412*:82B26BF4:sql_mon_query:keswx.c@2840:keswxWriteEndInfoToStream(): done writing error info: code=1000 fac=ORA msg=ORA-01000: maximum open cursors exceeded
ORA-06512: at "APPS.WF_EVENT_OJMSTEXT_QH", line 1103
ORA-06512: at line 1
msglen=115
------------------

 



STEPS
The issue cannot be reproduced at will.

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.