Unknown Member error in FRS report
(Doc ID 2581764.1)
Last updated on JUNE 27, 2024
Applies to:
Oracle Fusion General Ledger Cloud Service - Version 11.13.17.10.0 and laterInformation in this document applies to any platform.
Purpose
This article aims to help troubleshooting Unknown Member Error in Financial Reporting Studio Reports
Troubleshooting Steps
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
| Purpose |
| Troubleshooting Steps |
| 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 |