My Oracle Support Banner

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

Last updated on SEPTEMBER 20, 2022

Applies to:

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


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

at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.processError(
at oracle.jdbc.driver.T4CTTIfun.receive(
at oracle.jdbc.driver.T4CTTIfun.doRPC(
at oracle.jdbc.driver.T4C8Oall.doOALL(
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(
at oracle.jbo.server.ViewUsageHelper.createViewAttributeDefImpls(
... 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))))
(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')))


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.