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 AUGUST 04, 2016

Applies to:

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

Symptoms

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.

 

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