A scan of the file with resident set to high or custom (all files) and scan archives set to thorough fails to detect the malware .On execution however it detects it.

That only proves that the file is packed with some unknown method. It’s self-extracting, though. Therefore, if you run it, it extracts its contents to some temp files – and that triggers the on-access scanner…

No magic here…