Validate Geographies of Addresses Against Master Geographies (GNR) is running for a single country (GB) and has been running for 12 hours. (Doc ID 2566479.1)

Last updated on AUGUST 18, 2023

Applies to:

Symptoms

On : 11.13.19.01.0 version, Accounts, Contacts, Households

ACTUAL BEHAVIOR
---------------
Validate Geographies of Addresses Against Master Geographies (GNR) is running for a single country (GB) and has been running for 12 hours.

EXPECTED BEHAVIOR
-----------------------
Expecting the process to have completed already.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Navigator > Tools > Scheduled Processes
2. Click "Schedule New Process" button
3. Click the dropdown arrow and Search at the bottom of the dropdown list
4. Enter "Validate Geographies of Addresses Against Master Geographies" in the Name and search
5. Select the process from the list and click OK
6. Click OK again
7. Enter the Basic Options:
Location Table Name = HZ_LOCATIONS
Run Type = ALL
Usage Code = GEOGRAPHY
Country Code = GB (for example)
8. Click Submit

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the process is not completing.

Changes

Cause

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