Import Geography Reference Data

Here's how to import geography reference data licensed by Oracle.

  1. In Setup and Maintenance, go to the Manage Geographies task:

    • Offering: Sales

    • Functional Area: Sales Foundation

    • Task: Manage Geographies

  2. In the Manage Geographies page, enter either the country name in the Country Name field or the two-letter ISO code of the country in the Country Code field.

    Examples of ISO country codes include US (United States) and AT (Austria).

  3. Click Search.

  4. Select the country in the search results. Don't click the link.

  5. Select Import Geography Data from the Actions menu.

    Note: The Import Geography Data action is disabled if the country isn't available from DaaS Loqate or if the country data is already imported.
  6. Click OK to close the warning message.

  7. Click OK to close the confirmation message.

The import of larger countries may require several hours to complete. You can track the progress of the import process by selecting Scheduled Processes from the Navigator menu.

After the import completes successfully, the Completed icon (check mark) replaces Go to Task icon in the Structure Defined and Hierarchy Defined columns on the Manage Geographies page.

Here's a screenshot of the Manage Geographies page with the Completed icons (check marks) highlighted.
Screen capture of the Manage Geographies page after import completes for the United States. The Structure Defined and Hierarchy Defined fields display check marks.

The Geocoding Defined and Address Cleansing Defined columns are used for additional features that you set up separately:

  • Geocoding enables mapping features in your application, such as the display of customer locations on a map in the UI. For details, see the Enable Address Mapping topic.

  • Address cleansing makes it possible to validate addresses down to the street level. Address cleansing requires you to obtain a separate license for the Address Verification Cloud Service.

Note: The geography data is provided by Loqate is third-party content. As per Oracle policy, this software and documentation may provide access to or information on content and services from third parties. Oracle and its affiliates aren't responsible for and expressly disclaim all warranties of any kind with respect to third-party content and services. Oracle and its affiliates aren't responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.Report any issues with Loqate data to Oracle Support who will contact the appropriate team for correction. Alternatively, you can make manual changes to the geography data by using the Manage Geographies task in the Setup and Maintenance work area.