Ora-01000: Maximum Open Cursors Exceeded When Calling Fun_rule_pub.apply_rule_bulk cursor

(Doc ID 1293584.1)

Last updated on JUNE 08, 2016

Applies to:

Oracle Receivables - Version: 12.1.1 and later   [Release: 12.0 and later ]
Information in this document applies to any platform.

Symptoms



On : 12.1.1 version

When attempting to load approx 60,000 orders into OM using the API OE_ORDER_PUB.PROCESS_ORDER,
the following error occurs.

Customer was able to locate the cursor that was being opened and not closed.
The following is the cursor text:
select * from AR_RDR_PARAMETERS_GT where 1=1 AND ROWNUM = 1

This SQL is being generated in one of two spots:
Package AR_DEFERRAL_REASONS_GRP or Package AR_REVENUE_MANAGEMENT_PVT.
They both have a call to a procure fun_rule_pub.apply_rule_bulk which is building this SQL using Dynamic SQL.
This procedure opens the cursor l_theCursor := dbms_sql.open_cursor but it never closes it.

ERROR
-----------------------
ORA-01000 error. (Our Max Cursor limit is set to 1200.)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Attempting to load approx 60,000 orders into OM using the API OE_ORDER_PUB.PROCESS_ORDER


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot load all Orders for their conversion.

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