Import Geography Reference Data Licensed by Oracle

You can use this procedure to import geography reference data licensed by Oracle. If the data you want to import is unavailable in Loqate or is already imported, then the Import Geography Data action is disabled.

Note: The geography data is provided by Loqate and is third-party content. As per Oracle policy, this software and documentation may provide access to or information about content and services from third parties. Oracle and its affiliates aren't responsible for and disclaim all warranties of any kind with respect to the 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.

To import geography data:

1. Sign is as a setup user having the role Master Data Management Applications Administrator.

2. Open the Manage Geographies task from the implementation project. Alternatively, in the Setup and Maintenance work area, go to the following:

   • Offering: Customer Data Management

   • Functional Area: Enterprise Profile

   • Task: Manage Geographies

3. 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).

4. Click Search.

   The Search Results display the country.

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

6. Select Import Geography Data from the Actions menu.

   Note: The Import Geography Data action is disabled if the country isn't available from Oracle Address, Email, and Phone Verification Loqate or if the country data is already imported.

7. Click OK to close the warning message.

8. 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 is complete, you can search for the country again in the Manage Geographies page. Check marks now appear in the Structure Defined and Hierarchy Defined columns indicating that the import completed successfully.

Here's a figure that shows the Manage Geographies page with check marks on the Structure Defined and Hierarchy Defined columns indicating that the import has completed successfully.

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 topic: Enable Address Mapping.

• Address cleansing makes it possible to validate addresses down to the street level. Address cleansing requires you to obtain a separate license for Oracle Address, Email, and Phone Verification.

Note: 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. If you decide to use geography data from another data provider, then Oracle Support can delete the data and you can then load your data using Import Management.