The following code
\documentclass{report}
\usepackage{manyfoot}
\DeclareNewFootnote{R}[alph]
\usepackage{hyperref}
\begin{document}
The default\footnote{Default} footnote works fine, but
manyfoot\footnoteR{Many foot} with pdflatex throws a warning. xelatex
run on the same code also does not throw a warning!
\end{document}
compiled using pdflatex throws the warning
pdfTeX warning (dest): name{Hfootnote.2} has been referenced but does not exist, replaced by a fixed one
A similar question is addressed here. However, the solution of loading hyperref as the last package still throws the error in the presence of manyfoot. A suggestion of including hyperfootnote=false, identifies the origin, but is not a solution when the hyperlinks are needed.
Strangely, if the code is run with xelatex, there is no warning and the PDF is generated with the links working fine.
How do we suppress the warning while keeping the hyperlinks active using pdflatex compiler?
Here are the output images for a quick reference:

