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 laterInformation 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? |