Geography Name Referencing (GNR) Error: 'No mapping exists for the country' for Some Locations In HR_LOCATIONS_ALL (Doc ID 1121835.1)

Last updated on JUNE 21, 2023

Applies to:

Symptoms

Run Geography Name Referencing (GNR) concurrent program for HR_LOCATIONS_ALL table and 27 of the locations are not validated.  The GNR log file is showing:

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

Current Location ID: 144
Current Location ID: 145
Current Location ID: 146
Current Location ID: 147
Current Location ID: 148
Current Location ID: 149 ...
Total number of Processed Locations:32
Number of Successfully Processed Locations:5
Number of Locations in Error:27

Steps to reproduce:
Responsibility: Trading Community Manager
Navigation: Control > Request > Run

1. Choose the concurrent 'Geography Name Referencing' from the list of values
2. Select the parameter: Processing for Table = HR_LOCATIONS_ALL 
3. Click on Submit.

FND debug log file for Geography Name Referencing (GNR) concurrent program is showing the following errors:


ar.hz.plsql.HZ:ARHGNRCB:HZ_GNR_PKG.ADDRESS_VALIDATION 144-Begin of validation procedure validateHrLoc
ar.hz.plsql.HZ:ARHGNRCB:HZ_GNR_PKG.ADDRESS_VALIDATION 144- Map Id for the country :
ar.hz.plsql.HZ:ARHGNRCB:HZ_GNR_PKG.ADDRESS_VALIDATION 144- No mapping exists for the country. Raise error and exit.
ar.hz.plsql.HZ:ARHGNRCB:HZ_GNR_PKG.ADDRESS_VALIDATION 145-Begin of validation procedure validateHrLoc
ar.hz.plsql.HZ:ARHGNRCB:HZ_GNR_PKG.ADDRESS_VALIDATION 145- Map Id for the country :
ar.hz.plsql.HZ:ARHGNRCB:HZ_GNR_PKG.ADDRESS_VALIDATION 145- No mapping exists for the country. Raise error and exit.
ar.hz.plsql.HZ:ARHGNRCB:HZ_GNR_PKG.ADDRESS_VALIDATION 146-Begin of validation procedure validateHrLoc
ar.hz.plsql.HZ:ARHGNRCB:HZ_GNR_PKG.ADDRESS_VALIDATION 146- Map Id for the country :
ar.hz.plsql.HZ:ARHGNRCB:HZ_GNR_PKG.ADDRESS_VALIDATION 146- No mapping exists for the country. Raise error and exit.
ar.hz.plsql.HZ:ARHGNRCB:HZ_GNR_PKG.ADDRESS_VALIDATION 147-Begin of validation procedure validateHrLoc
ar.hz.plsql.HZ:ARHGNRCB:HZ_GNR_PKG.ADDRESS_VALIDATION 147- Map Id for the country :
ar.hz.plsql.HZ:ARHGNRCB:HZ_GNR_PKG.ADDRESS_VALIDATION 147- No mapping exists for the country. Raise error and exit.
ar.hz.plsql.HZ:ARHGNRCB:HZ_GNR_PKG.ADDRESS_VALIDATION 148-Begin of validation procedure validateHrLoc
ar.hz.plsql.HZ:ARHGNRCB:HZ_GNR_PKG.ADDRESS_VALIDATION 148- Map Id for the country :
ar.hz.plsql.HZ:ARHGNRCB:HZ_GNR_PKG.ADDRESS_VALIDATION 148- No mapping exists for the country. Raise error and exit.
ar.hz.plsql.HZ:ARHGNRCB:HZ_GNR_PKG.ADDRESS_VALIDATION 149-Begin of validation procedure validateHrLoc
ar.hz.plsql.HZ:ARHGNRCB:HZ_GNR_PKG.ADDRESS_VALIDATION 149- Map Id for the country :
ar.hz.plsql.HZ:ARHGNRCB:HZ_GNR_PKG.ADDRESS_VALIDATION 149- No mapping exists for the country. Raise error and exit.
ar.hz.plsql.HZ:ARHGNRCB:HZ_GNR_PKG.ADDRESS_VALIDATION 2678-Begin of validation procedure validateHrLoc
ar.hz.plsql.HZ:ARHGNRCB:HZ_GNR_PKG.ADDRESS_VALIDATION 2678- Map Id for the country : 10001
ar.hz.plsql.HZ:ARHGNRCB:HZ_GNR_PKG.ADDRESS_VALIDATION 2678-Before calling HZ_GNR_MAP10001.validateHrLoc
ar.hz.plsql.HZ:ARHGNRGB:HZ_GNR_MAP10001.ADDRESS_VALIDATION 2678-Begin of validation for validateHrLoc.
ar.hz.plsql.HZ:ARHGNRGB:HZ_GNR_MAP10001.ADDRESS_VALIDATION 2678- The SQL query : SELECT g.GEOGRAPHY_ID,g.MULTIPLE_PARENT_FLAG,GEOGRAPHY_ELEMENT1_ID,GEOGRAPHY_ELEMENT2_ID FROM HZ_GEOGRAPHIES g WHERE g.GEOGRAPHY_USE = 'MASTER_REF' AND g.COUNTRY_CODE = :country_code AND g.GEOGRAPHY_ELEMENT1_ID+0 = :id1 AND SYSDATE BETWEEN g.START_DATE AND g.END_DATE AND EXISTS( SELECT NULL FROM HZ_GEOGRAPHY_IDENTIFIERS i2 WHERE i2.GEOGRAPHY_TYPE = :l_type2 AND i2.GEOGRAPHY_USE = 'MASTER_REF' AND g.GEOGRAPHY_ELEMENT2_ID = i2.GEOGRAPHY_ID AND upper(i2.IDENTIFIER_VALUE) = upper(:l_val2)) AND g.GEOGRAPHY_TYPE = :geography_type AND rownum < 3
ar.hz.plsql.HZ:ARHGNRGB:HZ_GNR_MAP10001.ADDRESS_VALIDATION 2678- Fetching once more to see where there are multiple records
ar.hz.plsql.HZ:ARHGNRGB:HZ_GNR_MAP10001.ADDRESS_VALIDATION 2678- A unique record or a record with multiple parent flag = Y is found
ar.hz.plsql.HZ:ARHGNRGB:HZ_GNR_MAP10001.ADDRESS_VALIDATION 2678- A unique record is found
ar.hz.plsql.HZ:ARHGNRGB:HZ_GNR_MAP10001.ADDRESS_VALIDATION 2678- Calling fix_child. This call will try to derive missing lower level compoents.
ar.hz.plsql.HZ:ARHGNRGB:HZ_GNR_MAP10001.ADDRESS_VALIDATION 2678- Return status after fix_child S
ar.hz.plsql.HZ:ARHGNRUB:HZ_GNR_UTIL_PKG.ADDRESS_VALIDATION Begin of fill_values procedure
ar.hz.plsql.HZ:ARHGNRUB:HZ_GNR_UTIL_PKG.ADDRESS_VALIDATION End of fill_values procedure
ar.hz.plsql.HZ:ARHGNRGB:HZ_GNR_MAP10001.ADDRESS_VALIDATION 2678- Calling create_gnr with map status S.
ar.hz.plsql.HZ:ARHGNRUB:HZ_GNR_UTIL_PKG.ADDRESS_VALIDATION 2678-Retain GNR Flag value l_retain_flag=N
--------------

Changes

Cause

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