Postal Codes are Missing after Upgrade to R12
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.
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.
select * from apps.hz_geographies where geography_type = 'POSTAL_CODE' -> 21575
select * from apps.hz_locations where postal_code IS NOT NULL -> 1845037
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms