Duplicate Postal Codes in Geography and Territory Hierarchy
Last updated on DECEMBER 09, 2014
Applies to:Oracle Fusion Trading Community Model - Version 188.8.131.52.0 and later
Oracle Fusion Territory Management - Version 184.108.40.206.0 and later
Oracle Fusion Territory Management Cloud Service - Version 220.127.116.11.0 and later
Oracle Fusion Trading Community Model Cloud Service - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
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.
There should not be duplicate postal codes in Manage Geography Hierarchy or when configuring territories.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms