My Oracle Support Banner

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 11.13.17.10.0 and later
Information 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   

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