R12 E-Business Suite Error 'Java.sql.SQLException: ORA-01000: Maximum Open Cursors Exceeded' and 'ORA-06512: at "APPS.FND_AOLJ_UTIL"' For Register Notification Link
(Doc ID 2180450.1)
Last updated on SEPTEMBER 01, 2024
Applies to:
Oracle Workflow - Version 12.1.3 and laterOracle E-Business Suite Technology Stack - Version 12.1.3 and later
Information in this document applies to any platform.
Goal
E-Business Suite R12 Workflow, Workflow Administration issues
Provide steps to resolve the following Workflow related error:
java.sql.SQLException: ORA-01000: maximum open cursors exceeded
For example, when a Supplier is invited for registration and the supplier clicks on registration link the following error is received:
java.sql.SQLException: ORA-01000: maximum open cursors exceeded
ORA-06512: at "APPS.FND_AOLJ_UTIL", line 201
ORA-06512: at line 1
Workflow Type : POSSPM1
Activity : Invite Supplier To Register Notification
SQL> show parameter open_cursor
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
open_cursors integer 4000
This issue started after we applied Consolidated Rollup <Patch 21198991>:R12.PO.B last week.
Oracle iProcurement Recommended Patch Collection (Nov. 2015)
Solution
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
Goal |
Solution |
References |