1. Using Common Features for HCM
  2. Best Practices for Geography Validation

Best Practices for Geography Validation

After geography data setup, you must configure geography validations.

Here are some best practices to configure geography validation:
  • The configuration of geography validation rules depends upon your application needs. If you want to ensure that only valid addresses must are allowed:
    1. Navigate to Manage Geographies, search for a country, and click Validation Defined.
    2. Set Geography Validation based on the application requirements.
      Note: For either the tax or geography validation, don't skip more than one consecutive level unless you're certain that the selected geography types can uniquely identify geographies. For example, the United States country structure is: State, County, City, and Postal Code, and you want to select just State and Postal Code for geography or tax validation. However, for the combination of California and 94065, the city can be either Redwood Shores or Redwood City. In this case, you should also select at least the City geography type for geography or tax validation.
    3. Set the Geography Validation Level for Country in the Geography Validation Control section to Error.
  • If you require validated addresses for your downstream applications:
    1. Go to Manage Geographies, search for a country, and click Validation Defined.
    2. The best practice is Enable List of Values and setup validation for all geography levels and geography types.
    3. Run the Validate Geographies of Addresses Against Master Geographies scheduled process to review address validation results.
  • To ensure that the addresses are validated and there are no downstream impacts:
    1. Go to Manage Administrator Profile Values and set the Number of workers for a given Geography Name Referencing request (HZ_GNR_NUM_OF_WORKERS) profile option to 5.
    2. Run the Validate Geographies of Addresses Against Master Geographies scheduled process with Parameters: Location Table Name: HZ_LOCATIONS, Run Type: ALL, Country Code: [Country code for which Geography Name Referencing (GNR) needs to be generated].
    3. Run the Validate Geographies of Addresses Against Master Geographies scheduled process with Parameters: Location Table Name: PER_ADDRESSES_F, Run Type: ALL, Country Code: [Country code for which GNR needs to be generated].
    4. You can then use the report: to identify if the existing addresses are incorrect. Correct these addresses as a onetime activity.