CHECK RULE FAIL FOR SHARED ENTITIES with error Essbase Error(XXXXXXX): Cannot uniquely identify a member, the name [XXXX] is duplicated

(Doc ID 2320195.1)

Last updated on NOVEMBER 22, 2017

Applies to:

Oracle Financial Consolidation and Close Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

While executing a dataload using Data Management , the check report shows lookup error, after downloading the log there is a line saying
Cannot execute report. Essbase Error(XXXXX): Cannot uniquely identify a member, the name [XXXXX] is duplicated

++ In Data Management Process log having below entries

2017-10-11 16:27:55,645 INFO [AIF]: ***** Check Initialization - BEGIN *****
2017-10-11 16:27:55,645 INFO [AIF]: Connection established to FDMEE database.
2017-10-11 16:27:55,655 INFO [AIF]: Init Data Key - 1240001
2017-10-11 16:27:55,667 INFO [AIF]: Jython Operations Initialization Completed.
2017-10-11 16:27:55,667 INFO [AIF]: Check Report Precision Value - 2
2017-10-11 16:27:55,667 INFO [AIF]: ***** Check Initialization - END *****
2017-10-11 16:27:55,667 INFO [AIF]: ******** Check Execution - BEGIN ********
2017-10-11 16:27:55,699 INFO [AIF]: Connection established to Essbase.
2017-10-11 16:27:55,708 INFO [AIF]: ------------------- Execution for Entity : XXXXX - BEGIN -------------------
2017-10-11 16:27:55,708 INFO [AIF]: ------------------- Execution for Account : ACTIVO - BEGIN -------------------
2017-10-11 16:27:55,708 INFO [AIF]: ******************* Condition Logic - BEGIN *******************
2017-10-11 16:27:55,713 INFO [AIF]: Error occurred due to specified intersection.
2017-10-11 16:27:55,713 ERROR [AIF]: Cannot execute report. Essbase Error(XXXXX): Cannot uniquely identify a member, the name [XXXXX] is duplicated
2017-10-11 16:27:55,713 INFO [AIF]: Data from Target: LOOKUP_ERROR
2017-10-11 16:27:55,713 INFO [AIF]: ******************* Condition Logic - END *******************

2017-10-11 16:27:55,750 INFO [AIF]: Error occurred during Check Process.
2017-10-11 16:27:55,750 ERROR [AIF]:
2017-10-11 16:27:55,751 INFO [AIF]: Disconnected from FDMEE database.
2017-10-11 16:27:55,752 INFO [AIF]: Disconnected from Essbase.
2017-10-11 16:27:55,752 INFO [AIF]: ******** Check Execution - END ********
2017-10-11 16:27:55,761 INFO [AIF]: [checkData:124,Dec-16] END (false)
2017-10-11 16:27:55,774 FATAL [AIF]: Error in CommData.checkData
Traceback (most recent call last):
File "<string>", line 4407, in checkData
RuntimeError: false

 

++ In AIF_WEBAPP.log


[2017-10-12T15:04:15.315+00:00] [EPMServer0] [ERROR] [] [oracle.apps.erpi.model] [tid: [ACTIVE].ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: b7f24f191aac8151:1f117b45:15f0f66d2b9:-8000-0000000000000366,0:1:1:1:8] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.gl.common.validation.model.util.impl.CheckEssbase] [SRC_METHOD: getCellData] Cannot execute report. Essbase Error(1060200): Cannot uniquely identify a member, the name [URU060] is duplicated[[
com.essbase.api.base.EssException: Cannot execute report. Essbase Error(XXXXX): Cannot uniquely identify a member, the name [XXXX] is duplicated

[2017-10-12T15:04:15.318+00:00] [EPMServer0] [ERROR] [] [oracle.apps.erpi.model] [tid: [ACTIVE].ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: b7f24f191aac8151:1f117b45:15f0f66d2b9:-8000-0000000000000366,0:1:1:1:8] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.webservices.HPLService] [SRC_METHOD: checkData] [[
java.lang.NullPointerException

[2017-10-12T15:04:15.650+00:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: [ACTIVE].ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: a436305.bernardo.neira@exisconsulting.co] [ecid: b7f24f191aac8151:1f117b45:15f0f66d2b9:-8000-0000000000000366,0:1:1:1] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.gl.common.util.model.applicationModule.GLIntegrationBaseAMImpl] [SRC_METHOD: invoke_odi_process] pid:143, Extract id:24501, status:Session Failed :24501 : ODI-1217: Session COMM_LOAD_BALANCES (24501) fails with return code 7000.[[
ODI-1226: Step FAILED - Check Data fails after 1 attempt(s).
ODI-1232: Procedure COMM Finalize Process execution fails.
Caused By: org.apache.bsf.BSFException: exception from Jython:
Traceback (most recent call last):
File "<string>", line 10, in <module>
File "<string>", line 162, in finalizeProcess
RuntimeError: ODI-1226: Step COMM Check Data fails after 1 attempt(s).
ODI-1232: Procedure COMM Check Data execution fails.
Caused By: org.apache.bsf.BSFException: exception from Jython:
Traceback (most recent call last):
File "<string>", line 9, in <module>
File "<string>", line 4407, in checkData
RuntimeError: false



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms