Geocode Record Counts are Different In DEV & TEST following application of 2014 EOY patch (Doc ID 2048523.1)

Last updated on SEPTEMBER 01, 2015

Applies to:

Oracle HRMS (US) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Geocode issues


HR Global and Vertex patches are applied in DEV and TEST instances. Upon validation, noticing differences of counts - L350(DEV) count 12,903 records and T200(TEST) count 14,824 records.

This is presenting issues such as entire cities, Montreal included, not functioning properly through address validation.



Steps to Reproduce:
The issue can be reproduced at will with the following steps:

1. Apply the HR Global and Vertex patches
2. Check
3. View the output from view PAY_CA_NEW_CITIES_V


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