Enable Dimensions And Metrics Ended In Warnings due to "Duplicate members with the same integration ID 3000000669XXXX were found in the dimension source" (Doc ID 2251354.1)

Last updated on APRIL 03, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.11.1.0 version, Territory Management, Quotas

Customer launched the Enable Dimensions and metrics process and it finished in Completed with warnings.

ERROR
-----------------------

[2017/03/10 14:21:54] [2017-03-10 14:20:51 UTC] The process to load members for the dimension Customer has started. (MOT-480428)
[2017-03-10 14:21:11 UTC] 755 records have been processed. (MOT-480448)
JBO-MOT:::MOT_SYNCH_FAILS_DUPS: MOT-480320Synchronization of the dimension with the code Acct failed. Duplicate members with the same integration ID 3000000669XXXX were found in the dimension source.
[2017-03-10 14:21:12 UTC] The process to load members for the dimension Customer ended with the status Completed Successfully. (MOT-480427)



STEPS
-----------------------
The issue can be reproduced at will with the following steps:

- Navigator > Territories > Enable Dimensions and Metrics > Load and Activate

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot territory setup.

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