No, UDG should not act on an RNA substrate. UDG evolved to repair dU residues in DNA that can be created by deamination of dC (hence avoiding the mutation of a C:G base pair to T:A that would occur when the U-strand is replicated).