Error 'The address cannot be validated because no geography usage exists for this country' When Running GNR program or Hz_location_v2pub.Update_location API (Doc ID 1385936.1)

Last updated on JULY 12, 2017

Applies to:

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

Symptoms

In R12.1.3, trying to update an address using the hz_location_v2pub.update_location and the following error is received:

"The address cannot be validated because no geography usage exists for this country. Please contact your system administrator."

The same error is also received when running the Geography Name Referencing (GNR) program for table HZ_LOCATIONS.

There is no issue when updating the address in Customers screen.

Geography Hierarchy has been setup for all states, counties, cities, postal codes of US country.
Geography Validation For Country is set to "No Validation".

Steps to reproduce:

1. Run the following TCA API script hz_location_v2pub.update_location:

 
2. The output shows:

x_return_status = S
x_msg_count = 1
Changed Address1 = 123 TEST
x_msg_data = The address cannot be validated because no geography usage exists for this country. Please contact your system administrator.



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