My Oracle Support Banner

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

Last updated on JUNE 22, 2022

Applies to:

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


On : 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.

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

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

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


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.