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
How to get user email
I’ve used this before - but was wondering if anyone had found a way to get this in an Apps 10 projection?
Not available as far as I can see?
+8
I hope you are doing well. Today, I tried uploading the user list using the “Insert or Update” procedure with the view name “FND_USER.” The users were uploaded successfully, but without the user email and language fields.
I’m not sure how to include these fields along with the other data. Could you please guide me on this? Your support would be greatly appreciated.
Many thanks!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.