Postal Codes are Missing after Upgrade to R12 (Doc ID 2097150.1)

Last updated on AUGUST 02, 2016

Applies to:

Oracle E-Business Tax - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Geography Hierarchy

HZ_GEOGRAPHIES Table does not have all the data in R12, when compared with HZ_LOCATIONS in 11i.

There is huge count difference from 11i to R12.

Count :
select * from apps.hz_geographies where geography_type = 'POSTAL_CODE' -> 21575
select * from apps.hz_locations where postal_code IS NOT NULL -> 1845037

Extract query:
R12: select * from apps.hz_geographies where geography_type = 'POSTAL_CODE' and country_code = 'US'
11i : select distinct country, state, county, postal_code from apps.hz_locations where postal_code is not null and country = 'US'

You also created new Operating Unit for Puerto Rico, with same structure, which caused this issue.

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