Same query, Same linked server. Different result
Thank you for your response. Before post this question I already double checked the settings for both linked server and TNS name file. There is nothing different between them. 

Fortunately, I resolved it by just re-create the linked server at Server B. It might need to refresh some cache.

Thanks again and have a great one:)