Run Geography Name Referencing Program and all Locations have map_status = E (Doc ID 1401903.1)

Last updated on JUNE 21, 2023

Applies to:

Symptoms

In 12.0.6, run Geography Name Referencing program and it completes normal but the log file shows that all records (locations) got rejected:

+---------------------------------------------------------------------------+
Receivables: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
ARHGNRW module: Geography Name Referencing Worker
+---------------------------------------------------------------------------+
Current system time is 26-JAN-2012 04:52:48
+---------------------------------------------------------------------------+
**Starts**26-JAN-2012 04:52:48
**Ends**26-JAN-2012 04:55:06
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Starting Concurrent Program 'Geo Name Referencing Worker: 1'
Start Time 01-26-12 04:52:48

Processing for Table : HZ_LOCATIONS and Run Type : ALL
Parameters: Country Code :CA
Usage Code :ALL
From Location Id :NULL: To Location Id:NULL
Start Date :NULL: End Date:NULL
Number of workers:1

Total number of location records processed : 9884
Number of records succeeded : 0
Number of records rejected : 9884
Geo Name Referencing process completed successfully
+---------------------------------------------------------------------------+

Steps to reproduce:

-Responsibility: Trading Community Manager
-Navigation: Control > Request > Run
-Select Geography Name Referencing program
-Run it for parameters:
   Location Table Name: HZ_LOCATIONS
   Country Code: CA
-Submit the concurrent program.

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.