Unknown Member error in Allocations
(Doc ID 2756754.1)
Last updated on AUGUST 18, 2022
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 allocations.
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 allocation.|
|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 rules would cause the issue due to difference in tree version ID in target and source environments.|
|Cause 5: Post developing an allocation rule, deleted the tree hierarchy which is used in the rule|
|B) Error executing query: Error: Internal Essbase JAPI error: [Cannot execute report. Essbase Error(1001005): Unknown Member [Ledger - xxx] ]|
|Cause 1: Selected Ledger Name in Rule is wrong/not available in Environment.|
|C) Error executing query: Error: Internal Essbase JAPI error: [Cannot execute report. Essbase Error(1001005): Unknown Member  error]|
|Cause 1: POV selected is incorrect OR No Value selected in POV dimensions|
|D) Errorwise Process Details|