Account Reconciliation Management (ARM) Getting "ORA-01000: Maximum Open Cursors Exceeded" Error When Copying Profiles To Period (Doc ID 2239870.1)

Last updated on MARCH 02, 2017

Applies to:

Hyperion Financial Close Management - Version 11.1.2.4.103 and later
Information in this document applies to any platform.

Symptoms

 Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:943)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1283)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
at oracle.jbo.server.ViewUsageHelper.createViewAttributeDefImpls(ViewUsageHelper.java:231)
... 85 more
## Detail 0 ##
oracle.jbo.SQLStmtException: JBO-27120: SQL error during query execution. Statement: SELECT COUNT(1) AS PROFILE_COUNT FROM ARM_RECONCILIATIONS ProfileEO LEFT OUTER JOIN FCM_ORG_UNITS P_OrganizationUnitEO ON (ProfileEO.ORG_ID = P_OrganizationUnitEO.ORG_ID) WHERE
ProfileEO.PERIOD_ID IS NULL AND ((((ProfileEO.org_id IS NULL) OR
(ProfileEO.org_id IS NOT NULL AND
(P_OrganizationUnitEO.arm_calendar_id is null OR
P_OrganizationUnitEO.arm_calendar_id NOT IN (select Calendar_id from arm_period_calendars where period_id = 100000000404641))))
AND EXISTS
(SELECT 1 FROM arm_access ac1
WHERE ac1.frequency_id IN (SELECT frequency_id FROM arm_period_frequencies apf
WHERE apf.period_id= 100000000404641 and apf.calendar_id = 99)
AND ProfileEO.RECONCILIATION_ID = ac1.object_id
AND ac1.access_type = 'P')) OR
(ProfileEO.org_id IS NOT NULL
AND P_OrganizationUnitEO.arm_calendar_id is not null
AND EXISTS (select 1 from arm_access acl
where acl.frequency_id in (select frequency_id from fcm_org_units fou, arm_period_frequencies apf
where ProfileEO.Org_id = fou.org_id
and fou.arm_calendar_id is not null
and fou.arm_calendar_id = apf.calendar_id
and apf.period_id = 100000000404641)
AND ProfileEO.RECONCILIATION_ID = acl.object_id
AND acl.access_type = 'P')))

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