Thanks for reply Thomas.

I have already tried that with no luck.

I have recalled that, after the MV is created couple of master tables are moved from one TS to other TS. I am not sure if that creates any problem. So, planned to drop / recreate the MV tomorrow then try refresh again.

I will update the forum after testing.

Thanks,