Galactic vs. extragalactic origin of the peculiar transient SCP 06F6