Oracle R12 – US Tax Geography Validations
This post has been put together to demonstrate how you can correctly set-up your ‘Trading Community Architecture’ (TCA) for the United States in Oracle R12.
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
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_ALL
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’.
NOTE:
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’.