Not necessarily. He might forget the experience until he is once again dead and in heaven, except for some vaguely happy memories perhaps.

It's what I would rule if I were the DM anyhow, unless there were some critical plot points (like the scene Roy just witnessed possibly).