My Oracle Support Banner

Unknown Member error in Allocations (Doc ID 2756754.1)

Last updated on AUGUST 18, 2022

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

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

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