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 JULY 17, 2020

Applies to:

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

Symptoms

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.

Changes

 

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.