Checked the cause of gap sales refresh not tally between JDA and sale_facts. Identified that the manual sales refresh was interrupted by the scheduled sales refresh. Triggered the sales refresh again while there are no scheduled refresh which solved the issue.