Unable to Import Territories Due To Duplicate Member Key And Member Name Issue
Last updated on JULY 03, 2017
Applies to:Oracle Fusion Sales Cloud Service - Version 184.108.40.206.0 to 220.127.116.11.0 [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?
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