After Upgrade Unable To Update Province For Canada Geography - Based on this country structure, these geographies cannot be parent and child. Country: CA Parent geography: PROVINCE Child geography: PROVINCE

(Doc ID 1492643.1)

Last updated on OCTOBER 12, 2017

Applies to:

Oracle Trading Community - Version 12.1.3 and later
Information in this document applies to any platform.
zxhzhiernodesdf.sql

Symptoms

Attempting to update primary or alternate names for Canada in Geography Hierarchy after an upgrade to 12.1.3 and receive the following error:

The error "Based on this country structure, these geographies cannot be parent and child. Country: CA Parent geography: PROVINCE Child geography: PROVINCE"

Responsibility:  Trading Community Manager
Navigation:  Trading Community > Administration > Geography Hierarchy > Query Country
Change Country Code: AB to Country Code: ABCD and Save

After upgrade from 11.5.10.2 the Trading Community hierarchy needs to be changed to remove unwanted names and codes and update the Primary and Alternate Names and Codes for thr provinces. Deleting rows is not a problem,  but any changes to existing setup results in the error

Changes

 Upgrade to 12.1.3

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