Based on my assessment the reason why it did not get the correct information the ETL too huge to extract. So what we did was modify the etl and add step to update those items with wrong hierarchy(idept not in (811,812,813,950,900)) .