Skip to main content
Question

Person ID to Identity/Username mapping

  • February 24, 2025
  • 1 reply
  • 35 views

Forum|alt.badge.img+2

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.

Forum|alt.badge.img+2
  • Do Gooder (Customer)
  • March 4, 2025

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings