I need to retrieve a Person’s e-mail address. For this use case, the Person always has a full account. Problem is, there are multiple sources for an e-mail address here, so no single “source of truth”.
Person e-mail addresses can be retrieved from person_info_comm_method* views.
User (full account) e-mail addresses can be retrieved from fnd_user_property.
If you update one of the corresponding fields in the interface, the other does not update.
I’d love to be able to use a Person ID to retrieve an Identity/Username, then use that to get the e-mail address in the User record. But the debugger tool withholds information about the User-to-Person mapping.
I’ve checked quite a few views and tables. Does anyone have a good source or join to do this?
Thanks.