Set Up Geography Validation

You must set up geography validation for those geography elements that you plan to use in your business, for example your sales territories. Setting up validation also helps users fill in missing address information, and validate addresses during entry.

For example, you can have users select states or other address elements from lists to ensure accuracy during entry, and you can have the application fill in missing values. For example, when the user enters a Postal Code, the application can retrieve the city and state.

For each country, you must map the geography types to the address attributes. When you define geography validation, you need to verify the default mapping and update it if required.

Our example organization, Vision Corp. wants its salespeople to use a list of values to enter the states in their addresses and it plans to set up territories at the state level. So, validation must be set up at the state level.

Define Geography Validation

Perform the following steps to define geography validation:

1. Open the Manage Geographies task from the implementation project or from the Setup and Maintenance work area from Setup and Maintenance work area using the following:

   • Offering: Customer Data Management

   • Functional Area: Enterprise Profile

   • Task: Manage Geographies

2. Search for a country you imported using either its name or its two letter ISO code. For example, you can search by entering either the country name United States or the two-letter ISO code US.

3. Select the country from the Search Results area.

4. Click the Go to Task button in the Validation Defined column. Here's an image of the Manage Geographies page highlighting the Go to Task icon in the Validation Defined column.

   

5. On the Manage Geography Validation page, in the Address Style region, ensure that the No Styles Format address style is selected. You define validation for the No Styles Format address style so that the validations are performed for all addresses in the country.

   Note: The setup of address styles for your application is done elsewhere, using the Manage Address Formats task.

6. Select Enable List of Values in the Geography Mapping and Validation region to display the geography type as list of values during address entry in the classic and simplified UIs. For example, to have users select states from a list, select Enable List of Values for State.

   The example organization in our case study, Vision Corp., enables the list of values for State because it uses states for its sales territories and wants to assure that they are always entered correctly.

7. Select Geography Validation for all the geography types that you plan to use in territories.

   Our example organization, Vision Corp., plans to use set up geographies by state, so it selects Geography Validation for State. Here's an image of the Manage Geography Validation page highlighting the location of the Enable List of Values and Geography Validation options for the US State geography type.

   

   Note: If you don't select the validation for an address element, the application still suggests values to the user during address entry in the classic and simplified UIs, but it doesn't validate the address element.

8. Ensure that the mapping between Geography Type and Map to Attribute is valid in the Geography Mapping and Validation region and modify it if required. Oracle recommends that you use the following valid mapping for the countries that Loqate supports:

   Country Name	Country Code	Geography Type	Map to Attribute
   Andorra	AD	Country Parroqia Settlement Postal Code	Country State City Postal code
   Angola	AO	Country Provincia Municipio Comuna Localidad	Country Province County City Additional address attribute 2
   Argentina	AR	Country Province Department Municipality Postal Code	Country Province County City Postal code
   Australia	AU	Country State City Postal Code	Country State City Postal code
   Austria	AT	Country Bundensland Bezirk Gemeinde Postal Code	Country State County City Postal code
   Belgium	BE	Country Gewest Provincie Gemeente Postal Code	Country Additional address attribute 1 Province City Postal code
   Bolivia	BO	Country Departmento Provincia Canton	Country Additional address attribute 1 Province City
   Bosnia and Herzegovina	BA	Country District Kanton Opcine Nasalje Postal Code	Country Additional address attribute 1 Province County City Postal code
   Brazil	BR	Country State City Postal Code	Country State City Postal code
   Bulgaria	BG	Country Oblast Obshhina Settlement Postal Code	Country Additional address attribute 1 Province City Postal code
   Canada	CA	Country Province City Postal Code	Country Province City Postal code
   Cayman Islands	KY	Country Island District Postal Code	Country State City Postal code
   Chile	CL	Country Region Provincia Kommune Postal Code	Country State County City Postal code
   China Note: China geography structure is supported but geocoding isn't supported.	CN	Country Province City Postal Code	Country Province City Postal code
   Croatia	HR	Country Zupanije Grad Postal Code	Country Province City Postal code
   Cuba	CU	Country Provincia Municipio City Postal Code	Country Province County City Postal code
   Cyprus	CY	Country Periochi Dimos Postal Code	Country Province City Postal code
   Czech Republic	CZ	Country Kraj Okres Obec Postal Code	Country State County City Postal code
   Denmark	DK	Country Amt Settlement Postal Code	Country Province City Postal code
   Dominican Republic	DO	Country Provincia Municipio Town Postal Code	Country Province County City Postal code
   Ecuador	EC	Country Province Canton City Postal Code	Country Province County City Postal code
   Estonia	EE	Country Maakond Vald Postal Code	Country State City Postal code
   Finland	FI	Country Laani Kunta Postal Code	Country State City Postal code
   France	FR	Country Region Department Commune Postal Code	Country Additional address attribute 1 State City Postal code
   Germany	DE	Country Bundesland Gemeinde Postal Code	Country State City Postal code
   Great Britain	GB	Country County Township Postal Code	Country State City Postal code
   Greece	GR	Country Periferia Nomi Dimotika Postal Code	Country State County City Postal code
   Guadalupe	GP	Country Commune Postal Code	Country City Postal code
   Guam	GU	Country State County Municipality Village Postal Code	Country State County City Additional address attribute 2 Postal code
   Guernsey	GG	Country City Parishes Villages Postal Code	Country City Additional address attribute 2 Additional address attribute 3 Postal Code
   Hungary	HU	Country Megye Jaras Telepules Settlement Postal Code	Country Additional address attribute 1 Province County City Postal code
   Iceland	IS	Country Jaras Telepules Settlement Postal Code	Country Province County City Postal code
   India	IN	Country State City Postal Code	Country State City Postal code
   Indonesia	ID	Country Province Regency City Postal Code	Country Province County City Postal code
   Ireland	IE	Country Province Post County Post Code	Country State City Postal Code
   Isles of Man	IM	Country Locality Settlement Postal Code	Country City Additional address attribute 2 Postal code
   Israel	IL	Country District Subdistrict City Postal Code	Country State County City Postal code
   Italy	IT	Country Regione Provincia Comune Postal code	Country Additional address attribute 1 Province City Postal code
   Jamaica	JM	Country Parish Settlement	Country State City
   Japan	JP	Country Prefecture City Postal Code	Country State City Postal code
   Jordan	JO	Country Muhafazat Liwa Tajma Postal Code	Country State County City Postal code
   Kenya	KE	Country County Division Settlement	Country State City Additional address attribute 2
   Latvia	LV	Country Rajons Pilseta Postal Code	Country State City Postal code
   Liechtenstein	LI	Country Wahlkreis Gemeinde District Postal Code	Country Additional address attribute 1 State City Postal code
   Lithuania	LT	Country County Municipality Ward Postal Code	Country State County City Postal code
   Luxembourg	LU	Country Canton Commune Settlement Postal Code	Country State County City Postal code
   Malaysia	MY	Country State District Subdistrict Postal Code	Country State County City Postal code
   Malta	MT	Country Region Local Council Postal Code	Country State City Postal code
   Martinique	MQ	Country Departmen Arrondisement Commune Postal Code	Country State County City Postal code
   Mexico	MX	Country State Municipality Locality Postal Code	Country State County Additional address attribute 2 Postal code
   Netherlands	NL	Country Province Muncipality Town Postal Code	Country Province County City Postal code
   New Zealand	NZ	Country Region Town Postal Code	Country State City Postal code
   Norway	NO	Country Fylke Kommune Postal Code	Country Province City Postal code
   Oman	OM	Country Muhafazah District City	Country State County City
   Peru	PE	Country Region Provincia Distrito Postal Code	Country Province County City Postal code
   Poland	PL	Country Wojewodztwo Powiat Gmina Postal Code	Country Province County City Postal code
   Portugal	PT	Country Distrito Concelho Settlement Postal Code	Country Province County City Postal code
   Puerto Rico	PR	Country Commonwealth Municipio Barrio Postal Code	Country State County City Postal code
   Qatar	QA	Country Municipality Zone	Country State City
   Reunion Island	RE	Country Region Department Commune Postal Code	Country State County City Postal code
   Romania	RO	Country Regiune Judet Settlement Comuna Postal Code	Country Additional address attribute 1 Province County City Postal code
   Russia	RU	Country Federal_District Federal_Subject Oblast Postal Code	Country Additional address attribute 1 State City Postal code
   San Marino	SM	Country Comune Postal Code	Country State Postal code
   Singapore	SG	Country Region District Postal Code	Country State City Postal code
   Slovakia	SK	Country Kraj Okres Obec Postal Code	Country Province County City Postal code
   Slovenia	SI	Country Regija Upravna Enota Obcina Settlement Postal Code	Country Additional address attribute 1 Province County City Postal code
   South Africa	ZA	Country Province District Municipality Local Municipality Postal Code	Country Province County City Postal code
   South Korea	KR	Country Jibang Siti Postal Code	Country State City Postal code
   Spain	ES	Country Autonomous Community Province City Postal Code	Country Additional address attribute 1 Province City Postal code
   Sri Lanka	LK	Country Province District Divisional Secretariat Postal Code	Country Province County City Postal code
   Swaziland Note: This country maybe labeled Eswatini in Manage Territories.	SZ	Country District Inkhundla Town Postal Code	Country Province County City Postal code
   Sweden	SE	Country Lan Settlement Postal Code	Country Province City Postal code
   Switzerland	CH	Country Kanton Bezirk Gemeinde Postal Code	Country State County City Postal code
   Taiwan	TW	Country County Town Postal Code	Country State City Postal code
   Thailand	TH	Country Region Changwat Amphoe Postal Code	Country Additional address attribute 1 State City Postal code
   Tunisia	TN	Country Governorate Delegation Postal Code	Country State City Postal Code
   Turkey	TR	Country Sehir Ilce Kasaba Postal Code	Country Province County City Postal code
   United Arab Emirates	AE	Country Emirate City Area	Country State City Additional address attribute 2
   United States	US	Country State County City Postal Code	Country State County City Postal code
   Uruguay	UY	Country Departamento City Postal Code	Country State City Postal code
   Vatican City	VA	Country Municipal Settlement Postal Code	Country Province City Postal code
   Vietnam	VN	Country Region Tihn Quan Thank Pho Postal Code	Country Additional address attribute 1 Province County City Postal code

9. Select the values from the Geography Validation Level for Country drop-down list to specify whether you want to permit the application to save addresses that aren't considered valid. The following are the available values in the Geography Validation Level for Country drop-down list:

   • No validation: The default value. Select to save incomplete or incorrect addresses. In case you have the license for Oracle Address, Email, and Phone Verification, you can select this option to verify the address data using this service.

   • Error: Select to verify address data against the master geography reference data. This value permits only valid addresses to be saved.

   Our example organization wants to save all addresses including incomplete and invalid addresses, so it keeps the No validation which is the default value.

   The following figure shows the Manage Geography Validation page when the task is completed.

   

10. Click Save and Close.