Hierarchy Id's in Location table and Level tables out of Sync
We have in our location hierarchy two levels called country and country group (few more levels are there but just highlighting these two to explain the issue). For each level as we know we have corresponding level tables which holds members of level and along with that it holds id for its parent level.
Another table we have is locations which are having information of particular location and in this table we see all the id’s for each level of the location are denormalized and stored.
Issue we are seeing is the t_ep_country_id and t_ep_country_grp_id of the level members are not exactly reflecting in the locations table. The hierarchy of the country and country group changed recently and change is reflected correctly in level tables. Where in locations it is not, and we haven’t received any sales data yet for that location since the change.  For all locations with sales, after change in hierarchy are reflecting correct. we do Incremental load of sales history. Some locations may not have sales in particular months.