Not Able To Create/Import Territories With City And Postal Code Range As Dimensions. (Doc ID 2256773.1)

Last updated on MAY 10, 2017

Applies to:

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

Symptoms

On : 11.12.1.0.0 version, Territory Management, Quotas

Not able to create/Import Territories with city and Postal code range as dimensions.

We have requirement of creating territory for range of Postal codes. Some of the postal codes are duplicate so we are trying to add City dimension along with Postal code. We added city and Postal code in Territory Geography under Country.
We added range as "AMENIA~58004-BLANCHARD~58009" in "DimensionMemberName" but Import is failed with error.

Please suggest how to add range for two dimensions( City and Postal code) for territory creation.

ERROR
-----------------------
When selecting multiple dimension members using ranges, the members used to specify the range must belong to a single parent. (MOT-480043)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to Oracle Sales Cloud
2. Navigate to Setup and Maintenance > Task: Manage Territory Geographies > Click Go to Task
3. Add zone
4. Add geography, and include children: City, and Postal Code

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create territory geographies using only City and Postal code .

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