My Oracle Support Banner

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 JUNE 25, 2018

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

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
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.