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
Be the first to reply!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.