My Oracle Support Banner

Geography Hierarchy (Generic Datafix Provided): States, Counties, Cities in 11i Have Not Migrated into Release 12 Geography Hierarchy Table (Doc ID 1283524.1)

Last updated on MARCH 24, 2022

Applies to:

Oracle Trading Community - Version 12 to 12.2 [Release 12 to 12.2]
Information in this document applies to any platform.


After migrating from release 11i to R12, not all State, County, City values were migrated from the table AR_LOCATION_VALUES to the table HZ_GEOGRAPHIES. 
The values are not displaying on the Geography Hierarchy form.

This issue is happening when the 11i Location Flexfield Structure as COUNTRY.STATE.CITY.
The sales tax location flexfield was set to COUNTRY, STATE,CITY.




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.