My Oracle Support Banner

Geography Name Referencing (GNR) Error: GNR fails when running for HR_LOCATIONS_ALL with error 'No Mapping Exists For The Country' (Doc ID 1392944.1)

Last updated on JANUARY 16, 2020

Applies to:

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


In R12.1.3, run Geography Naming Reference Program (GNR) and the output is showing:

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

Current Location ID: 40305

Total number of Processed Locations:1
Number of Successfully Processed Locations:0
Number of Locations in Error:1

40305- No mapping exists for the country. Raise error and exit

Steps to reproduce:

Responsibility: Trading Community Manager

Navigation: Control > Request : Run

  1. Choose the concurrent program "Geography Naming Reference" from the list of values
  2. Select the following parameters:
    Processing for Table : HR_LOCATIONS_ALL
    Run Type : ALL
    Country Code :NULL
  3. Submit the concurrent program.





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

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