Skip to Main Content

Billing, Governance & Administration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Manual geocode is not resolving our issue

1717316Sep 15 2025

We are using Vertex for our geocodes. Retrieve geocode does not show the correct county for the zip code, so I input the correct geocode manually. However, the R070103 report still shows the address is blank. The only time the address shows is if I put the incorrect county into the employee's address. Necessary reports have been ran to update Vertex and the address has been confirmed in the government census geomap.

When I asked copilot this is the response it gave:

This document addresses issues related to employee geocode and county data, specifically noting that employee 10382 should be assigned to Sarpy County but requires Douglas County for report functionality. It highlights missing zip codes and FIPS codes for Sarpy, with manual input needed for certain zip codes (68136 and 68138) in JDEdwards. The report, which transfers updates from Vertex to JDEdwards, is recommended to be run annually, and official census codes such as P05005 and F060116 are referenced for geocode retrieval and employee master data. Adjusting the county to Sarpy results in blank address data in the report, indicating a data integration issue.

According to Oracle documentation, my manual input of the geocode should be the fix. I put the geocode in the National Fiscal Data section of the employee master in the tax area field, but the R070103 report still shows the address as blank when I use the correct county.

Comments
Post Details
Added on Sep 15 2025
0 comments
28 views