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 AUGUST 16, 2016

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.

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