In my situation below function was helfull:
SELECT fnd_user_property_API.get_value(p.IDENTITY,'SMTP_MAIL_ADDRESS') mail,p.* FROM fnd_user_property p
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.