For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting on SmartOrg. email address
Summary
SmartOrg. accounts have three email address fields and we would like to report on all of them.Content
When developing a report in OBI there is only one field in the Admin subject area for system users email address. But each users SmartOrg. account has three email address fields in the profiles personal information (Correspondence, Personal, & Work). We would like to be able to report on all three values not just one. I believe that we are defaulting to the Correspondence email address.
Administration --> System Users --> System User -Personal Information --> User Email Address
Oracle's response was "Currently, there are not fields in OBI to pull the other 2 email addresses. (Personal Email Address, Corporate Email Address) . The "System User - Personal Information"."User Email Address" will only return the "Email Address" section of the SmartOrg. user Personal Information. Open an enhancement request"