My Oracle Support Banner

Unable to Import Territories Due To Duplicate Member Key And Member Name Issue (Doc ID 2276236.1)

Last updated on DECEMBER 22, 2020

Applies to:

Oracle Fusion Sales Cloud Service - Version to [Release 1.0]
Information in this document applies to any platform.


User is trying to import Territories with Geography dimension as Country name.
Import is rejected with following issue:
"The value of the attribute Dimension Member Key is not valid.The value of the attribute Dimension Member Name is not valid.

User could find that there are duplicate values for geography dimension for different node level.(one Country name is also some child node under other country name)
Example: 'New Zealand' is a country which they are passing in Geography dimension and New Zealand is also available as a child node under country 'Canada'.

Territory best practices describes that full path of the dimension should be passed in import sheet if Dimension Member Key is not unique.
They can see the path is available under Edit Coverage for the child node(Canada>ONTARIO>HALTON>MILTON) but for Country node path is blank as it is parent node of geography dimension.

So how to import the data where duplicate dimension Member Key is present at top node of hierarchy and no path is available?


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

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