My Oracle Support Banner

When Manipulating Or Opening Dashboard An ORA-00904: "R_ACCESSEO" Error Is Thrown (Doc ID 2236006.1)

Last updated on APRIL 13, 2018

Applies to:

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

Symptoms

When users launch ARM and switch between the dashboard and other tabs, the following error is produced:

From the AccountReconciliation.log

[2017-01-19T07:58:22.519-06:00] [FinancialClose1] [ERROR] [] [oracle.apps.epm.arm.model] [tid: 11] [userId: A550418] [ecid: 0004fl8ueuCAPPSLyEP5iW0007vH0003hG,0:1] [APP: ACCOUNTRECONCILIATION#11.1.2.0] [SRC_CLASS: oracle.apps.epm.fcm.common.model.common.ModelUtils] [SRC_METHOD: executeStatementQuery] ORA-00904: "R_ACCESSEO"."c": invalid identifier[[
java.sql.SQLSyntaxErrorException: ORA-00904: "R_ACCESSEO"."ACCESS_ORDER": invalid identifier

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)

 

 

Cause

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
Symptoms
Cause
Solution
References


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