Do you ever realize you've confabulated? (made-up memories)

Has anyone ever realized they had completely fabricated a memory? Did it require external evidence? Did the realization leave any lasting emotional impact, or was it something you were able to move past?