ORA-1000 Open_cursors Error Running Scheduler/SOT Program (Doc ID 352417.1)

Last updated on JULY 24, 2015

Applies to:

Oracle Payments - Version 11.5.9 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
Checked for relevance on 17-Feb-2015.


Symptoms

When attempting to run the 11i iPayment Scheduler (IBYSCHEDULER) or Submit Offline Transactions program in R12, the following error occurs for some of the transactions within the batch:

ERROR


oracle.apps.iby.exception.PSException: IBY_45000 (INTERNAL_ERROR=IBY_40000
(SQL_EXCEPTION=ORA-01000: maximum open cursors exceeded))

The concurrent request log shows error stack -
oracle.apps.iby.exception.PSException: IBY_45000 (INTERNAL_ERROR=IBY_40000
(SQL_EXCEPTION=ORA-01000: maximum open cursors exceeded))
at oracle.apps.iby.database.AccXfrPaymentDB.postScheduleUpdate(AccXfrPaymentDB.java:579)
at oracle.apps.iby.payment.OnlineAccXfr.schedPay(OnlineAccXfr.java:448)
at oracle.apps.iby.scheduler.SchedBankAccount.processRequests(SchedBankAccount.java:513)
at oracle.apps.iby.scheduler.SchedBankAccount.schedPmt(SchedBankAccount.java:291)
at oracle.apps.iby.scheduler.Scheduler.doProcess(Scheduler.java:260)
at oracle.apps.iby.scheduler.Scheduler.init(Scheduler.java:297)
at oracle.apps.iby.scheduler.SchedInitiator.runProgram(SchedInitiator.java:200)
at oracle.apps.fnd.cp.request.Run.main(Run.java:142)

 

or

 

iby.exception.Log.debug.generic : PayPal - pfpDAL.executeSelQry(): 
Query: SELECT CORE.REFERENCECODE,SUMM.TRXNTYPEID FROM apps.IBY_TRXN_SUMMARIES_ALL SUMM,apps.IBY_TRXN_CORE CORE WHERE CORE.TRXNMID=SUMM.TRXNMID AND SUMM.TRXNTYPEID IN (2,3,5,8,11)  AND SUMM.STATUS=0 AND SUMM.TANGIBLEID='xxxxxx' ORDER BY SUMM.TRXNMID DESC
iby.exception.Log.debug.generic : PayPal - pfpDAL.executeSelQry() In the catch of SQLException : 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