Line Drilldown from GL to Subledger Details Is Giving Error - ORA-01000: maximum open cursors exceeded

(Doc ID 2369307.1)

Last updated on MARCH 05, 2018

Applies to:

Oracle General Ledger - Version 12.0.0 to 12.2.7 [Release 12.0 to 12.2]
Information in this document applies to any platform.
Drilldown
ORA-01000
Maximum open cursors exceeded

Symptoms

On : 12.2.6 version, Standard Reports & Inquiries

ACTUAL BEHAVIOR
---------------
Line Drilldown from GL to Subledger Details Is Giving Error - ORA-01000: maximum open cursors exceeded


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.GL_Superuser -> Journals -> Enter
Provide Source – Receivables
Period – Jan-18
2. Click on Find
3. Look for Sales Invoice category and Click on Review Journal
4. Select bigger amount line and then click on Line Drilldown
Web-page opens up with error message "You have encountered an unexpected error. Please contact your system administrator for assistance"

Upgraded Transaction failing with Error ORA-01000: maximum open cursors exceeded
this is happening in both the cases like from GL responsibility
and from sub ledger product like AP/AR to SLA OAF page using view Accounting

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