There are some instances when you need to change region details and move the details between regions . If you do this thru UI , all the internal tables (Formulated Regions) gets adjusted automatically . How ever when you change or move the details via CSV uploads.. you have a bad region formulation.
You need to clean up HNAME_SET_MEMBER table for the regions impacted. (delete all the records from that table)
Update Region table and set LOADED Flag as N for the regions impacted
and choose Formulate Regions from the UI
