Setting Geography Hierarchy for US address validations

Module: Trading Community Manager

Oracle Version: Oracle R12

Error Message:

Your geography for the USA has not been set up correctly for validation.

Cause of Issue:

Your geography for the USA has not been set up correctly for validation.


Ensure you have loaded all the geographies into Oracle using a file provided by eBiz Answers, Vertex, Taxware, TTR or CCH.

Step 1.
Navigate to the Trading Community Manager responsibility.
 TCA > Administration > Geography Hierarchy. Then, search for ‘United States‘ and then click on ‘Manage Validations’.

Step 2.
HZ Locations will already be available but won’t have been correctly assigned. Set the values as shown below. HZ_Locations are your suppliers and customers.

Step 3.
HR Locations will need to be added as it is not seeded. Set the values as shown below. HR_Locations are your own locations.

Step 4.
Save these additions and then run the ‘Geographies Name Referencing Program’.

Step 5.
Once complete, run the ‘HZ_LOCATIONS’.

 We have found that the default address types as shown above need to be setup first and then set up the following if these address styles are being used.

Step 6.
Once complete, re-run the ‘Geographies Name Referencing Program’.


Submit a Comment

Your email address will not be published. Required fields are marked *

Additional Support

When available, we provide additional resources to a particular support item, such as User Guides, blog posts, support videos and links to recommended Oracle solutions.


User Guide


News Article/Post

Video Support


Oracle Recommendations

GCC VAT Oracle Learning Series

Want to know how to set tax up for Oman, Kuwait, Bahrain, Qatar, United Arab Emirates and Saudi Arabia then sign up to our free webinar series.

Share This