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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms