Cannot Execute Report; Essbase Error (1001005): Unknown Member While Opening FR Report

(Doc ID 1561861.1)

Last updated on OCTOBER 21, 2015

Applies to:

Oracle Fusion General Ledger - Version 11.1.4.0.0 and later
Oracle Fusion General Ledger Cloud Service
Oracle Fusion Financials Common Module Cloud Service - Version 11.1.9.2.0 to 11.1.9.2.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

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
-----------------------
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].[0046]] in Report]

STEPS
-----------------------
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.

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