My Oracle Support Banner

Essbase Error(1060065): The generation or level name is the same as a member or alias (Doc ID 2570930.1)

Last updated on JULY 31, 2019

Applies to:

Oracle Fusion Financials Common Module Cloud Service - Version 11.13.19.01.0 and later
Oracle Fusion General Ledger Cloud Service - Version 11.13.19.01.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.19.01.0 version, Functional Setup Manager

When attempting to build cube,
the following error occurs.

ERROR
-----------------------
Building dimension AccountingPeriod...
buildAccountingPeriodDimension() : cube outline is opened :: otl
Error: Cannot set generation name. Essbase Error(1060065): The generation or level name is the same as a member or alias
buildAccountingPeriodDimension() : cube outline is closed :: otl
createStandardCube(): known otl save exception :: : Exception::Cannot verify cube outline. Essbase Error(1060001): NULL argument (%s) passed to ESSOTL function %s
2. Create Cubes program has failed. You must contact your administrator, and then manually run this program, otherwise posting will fail.Cannot set generation name. Essbase Error(1060065): The generation or level name is the same as a member or alias
Releasing Root AM...
>> gl_detect_essbase_conf_pkg.validate_dimmemberalias_naming 2019-06-04 15:34:44.566646000 +00:00
  
validate_dimmemberalias_naming --> Start Time 2019-06-04 15:34:44.583470
validate_dimmemberalias_naming --> Detecting conflicts for coaId: 81 and calendar:
IN Clause for Skipping values: 'EXP','ALL'
IN Clause for Skipping special values: 'EXP'
validate_dimmemberalias_naming --> COA Id: 81;COA Ins Id: 101;COA Str Id: 81;

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. run create cube process
2. see error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot build create cubes job successfully

Cause

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
Symptoms
Cause
Solution
References


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