My Oracle Support Banner

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

Last updated on NOVEMBER 22, 2019

Applies to:

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

Symptoms

On : 11.13.18.05.0 version, Accounts, Contacts, Households

ACTUAL BEHAVIOR
---------------
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.

EXPECTED BEHAVIOR
-----------------------
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
https://docs.oracle.com/en/cloud/saas/sales/18b/oacdm/define-geographies.html

STEPS
-----------------------
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)

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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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