R8: Nokia Geographies Missing Postal Codes For US (Doc ID 1932692.1)

Last updated on JUNE 22, 2017

Applies to:

Oracle Fusion Trading Community Model Cloud Service - Version 11.1.8.0.0 to 11.1.8.0.0 [Release 1.0]
Oracle Fusion Trading Community Model - Version 11.1.8.0.0 to 11.1.8.0.0 [Release 1.0]
Information in this document applies to any platform.

Goal

On : 11.1.8.0.0 version, File Import/Export

R8: Nokia Geographies missing postal codes for US

Using the the Nokia master geography in order to do territory based sales account assignment.

Figured out that the nokia data is missing a huge amount of postal codes (that have NOT been deprecated nor decommissoned by USPS).
Examples:
70511, 79698, 29804, 91804, 64420, 99520, 09028, ...

Some of them are unique, P.O. box or military postal codes some of them are simply missing for unknown reasons?

Why are they not included in the nokia data (using the nokia data it was promised to have full coverage for all US, no exceptions were mentioned).

So far it seems that thousands (!) of such postal codes are missing in the nokia geography data.

Each code can be checked through USPS: https://tools.usps.com/go/ZipLookupAction!input.action

What the coverage of the nokia data is and provide us with an explanation and a solution.


Could you also please advise about what alternative third-party vendors for US geo data have been used by other customers in order to setup territory geographies down to a zip code level that would include all US zip codes (and not just a subset of offered by the nokia data)?
 

Solution

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