Unknown Member error in FRS report
(Doc ID 2581764.1)
Last updated on OCTOBER 06, 2020
Applies to:Oracle Fusion General Ledger Cloud Service - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
This article aims to help troubleshooting Unknown Member Error in Financial Reporting Studio Reports
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
|A) Error executing query:Error:Internal Essbase JAPI error:[Cannot perform cube view operation.Essbase Error(1260046):Unknown Member 3-XXXXXX,51362DE2312B57A7E05384C72E0AC338 used in query]|
|Cause 1: Member "XXXXXX" is expected in segment3 from respective tree version which is missing. Hence, "XXXXXX" is identified as unknown member in report.|
|Cause 2: Member "XXXXXX" available in respective tree version but tree is not published properly to ESSBASE|
|Cause 3: POV values selected from incorrect tree version|
|Cause 4: Migration of the report would cause the issue due to difference in tree version ID in target and source environments.|
|Cause 5: Post developing a FRS report, deleted the tree hierarchy which is used to develop report.|
|B) Error executing query: Error: Internal Essbase JAPI error: [Cannot execute report. Essbase Error(1001005): Unknown Member [Ledger - xxx] in Report ]|
|Cause 1: Selected Ledger Name in Report is wrong/not available in Environment.|
|C) Error executing query: Error: Internal Essbase JAPI error: [Cannot execute report. Essbase Error(1001005): Unknown Member  in Report]|
|Cause 1: POV selected is incorrect OR No Value selected in POV dimensions|
|D) Errorwise Process Details|