Geography Hierarchy (Generic Datafix Provided): States, Counties, Cities in 11i Have Not Migrated into Release 12 Geography Hierarchy Table
Last updated on OCTOBER 09, 2017
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.
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