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

Last updated on JULY 03, 2017

Applies to:

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

Symptoms

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?

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