My Oracle Support Banner

Posting Error - Essbase Error(1003014) Unknown Member (Doc ID 2065339.1)

Last updated on SEPTEMBER 11, 2020

Applies to:

Oracle Fusion General Ledger Cloud Service - Version 11.1.8.0.0 and later
Oracle Fusion General Ledger - Version 11.1.8.0.0 and later
Information in this document applies to any platform.

Purpose

This note provides information on troubleshooting the GL Posting error: Unknown Member.

Whenever a new value is added to a segment of the chart of accounts it needs to be propagated to the GL Cube.
The program 'Update Balances Cubes Chart of Accounts Dimension Members and Hierarchies' is used to do this.
In case a journal entry is entered using the new segment value before the program is run and the journal is submitted for Posting, the posting program
will automatically submit the 'Update Balances Cubes Chart of Accounts Dimension Members and Hierarchies' program to have the value added before
continuing with the posting process.
There are some instances in which the posting program ends in error and the posting log file shows an error similar to:


The Unknown Member error displays the number of the segment for which there's a new value that was not found in the cube, followed by the value
that was not found or for which an error was found when trying to replicate it to the cube.
In the sample error above 'Unknown Member [5-_PLS_UPDATE]', the value set of segment 5 of the chart of accounts has a new value, '_PLS_UPDATE',
which is not found in the cube.

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
References

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