Cities in France displayed in other countries when we use FDI Map

Question

Dear team,

We are facing an issue while trying to display our positions by city in the map. the data for some french cities are displayed in other countries.

please see the picture below

subject Area ; HCM Position using City and #Position Headcount

Example of City : Charlevilles Mezieres that is in France but displayed in Australia

Sumanth V -Oracle · Accepted Answer

@Ayoub AFRASS - A zip code level join is required when comparing data at the city level to resolve the issue. This is because if multiple cities share the same name across different states, incorrect behavior may occur without a zip code-level join.

To address this, a custom zip map layer needs to be created in the DV application.

For more details on creating zip code-level joins, please refer to the following note:

OAC Map Incorrect Visualization Data Due to Same City Names in Different USA States (Doc ID 3050094.1).

Hope this helps!