Skip to main content

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.

Well, this was pretty straightforward and I should have seen it on my own.  Here’s a first draft:

   CURSOR c_get_email_address IS
      SELECT NVL(fnd_user_api.get_property(user_id, 'SMTP_MAIL_ADDRESS'), 'No e-mail found') email
        FROM person_info_tab
       WHERE person_id = UPPER(person_id_)
         AND user_id IS NOT NULL;

Reply


Terms & ConditionsCookie settings