Open Gl Period Error in Essbase dataload. Unpublished dimension member found: Currency-XXX (Doc ID 2907124.1)

Last updated on NOVEMBER 11, 2022

Applies to:

Symptoms

On : NA version, Setup, Rapid Impl and Security

When attempting to open GL accounting period
the following error occurs.

ERROR
-----------------------
ERROR:
Error in Essbase dataload. Unpublished dimension member found: Currency-XXX
If new account values were added or existing values were modified,
you need to run the Publish Account Hierarchies program for the impacted value set
and its hierarchy versions to update them in affected Essbase cubes.
Note: Publish Account Hierarchies program might not have added the missing member
since may be the value is defined as a parent


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open accounting period

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot open accounting period

Changes

Cause

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