Duplicate Postal Codes in Geography and Territory Hierarchy (Doc ID 1613154.1)

Last updated on DECEMBER 09, 2014

Applies to:

Oracle Fusion Trading Community Model - Version 11.1.7.0.0 and later
Oracle Fusion Territory Management - Version 11.1.7.0.0 and later
Oracle Fusion Territory Management Cloud Service - Version 11.1.7.0.0 and later
Oracle Fusion Trading Community Model Cloud Service - Version 11.1.7.0.0 and later
Information in this document applies to any platform.

Goal

During the application implementation, Geography structure and hierarchy for country US have been defined. Hierarchy has been defined using data import, and the requirement is to configure territories based on zip code.
While trying to configure the territory the zip codes are showing duplicates in the system.

EXPECTED BEHAVIOR
-----------------------
There should not be duplicate postal codes in Manage Geography Hierarchy or when configuring territories. 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to FSM task Manage Geographies
2. Search on code US
3. Click on United States to open Manage Geography Hierarchy
4. Search on various CA postal codes like 90001, 90004, 90005, etc.
5. Duplicate postal codes will appear
 

Solution

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