My Oracle Support Banner

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

Last updated on JUNE 21, 2023

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.

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
 Still Have Questions?


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