My Oracle Support Banner

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 SEPTEMBER 15, 2020

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

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


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