My Oracle Support Banner

Run Maintain Geography Name Referencing task, reviewing and fixing errors (Doc ID 2486698.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Fusion Sales Cloud Service - Version and later
Information in this document applies to any platform.


On : version, Accounts, Contacts, Households

Addresses were imported without validation.
Geography Validation was enabled and this is causing errors to be reported on some addresses.
The "Run Maintain Geography Name Referencing" task was run and reported:
Total number of location records processed : 155404
Number of records succeeded : 155404
Number of records rejected : 0
No change was made to the addresses.

Expecting this process to change the addresses to match the master geographies if they can be reconciled or report the address as rejected.

As noted in the documentation:
You can set geography validation control to Error in the Manage Geography Validation page. This ensures that users can only use valid geography elements in addresses.
Note: If you have already created addresses before setting up geography validation for a country, you must enable geography validation and then execute the Run Maintain Geography Name Referencing task for that country. This validates all your geography elements.

Implementing Customer Data Management
Chapter 5, Define Geographies

The issue can be reproduced at will with the following steps:
1. Sign-on to Sales Cloud application
2. Navigate to Setup and Maintenance > Run Maintain Geography Name Referencing
3. Enter Options:
Location Table Name = HZ_LOCATIONS
Run Type = ALL
Usage Code = GEOGRAPHY
Country Code = US (for example)

The issue has the following business impact:
Due to this issue, addresses are not validated against the master geography data.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.