Restrict imported Loqate geographies to Primary value

Summary

How to restrict imported Loqate geography values to Primary value only for various addresses

Content

Hello All,

We have loaded geographies for UAE from Loqate in our development environment, it seems system has loaded multiple variation of the same geography names in English and in foreign languages. E.g. When we click on the Abu Dhabi Emirate/State, we see different variations for it like Aaboo Dhabee, A Bu Da Bi, Abú Zabí etc and we also see foreign language text in Russian, Chinese and few other languages.

We can see these alternate spellings in various address forms in Oracle, like Manage Bank Branches, Manage Locations, as well as in Supplier Address & Employee Address forms.