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

Last updated on JULY 12, 2017

Applies to:

Oracle Trading Community - Version 12.0.6 and later
Information in this document applies to any platform.

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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms