Cannot Execute Report; Essbase Error (1001005): Unknown Member While Opening FR Report
Last updated on OCTOBER 21, 2015
Applies to:Oracle Fusion General Ledger - Version 126.96.36.199.0 and later
Oracle Fusion General Ledger Cloud Service
Oracle Fusion Financials Common Module Cloud Service - Version 188.8.131.52.0 to 184.108.40.206.0 [Release 1.0]
Information in this document applies to any platform.
When attempting to open any Financial Reporting report for one specific user the following error appears.
The reports can be opened with other users.
All users have the same data roles assigned: Financial Analyst, Financial Analyst Primary Ledger and Financial Analyst Secondary Ledger.
Have tried rebuilding the Cost Center Hierarchy, but still same error occurs.
Error executing query: Error: Internal Essbase JAPI error:
[Cannot execute report. Essbase Error (1001005): Unknown Member [[Cost Center Regional Hierarchy-Cost Center Regional Hierarchy - Base].[CSAL].[GR07].] in Report]
The issue can be reproduced at will with the following steps:
1. Launch the Workspace for financial reports with the user in question
2. Try opening a Financial reports report and the error is observed.
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