Reporting on SmartOrg. email address
SummarySmartOrg. accounts have three email address fields and we would like to report on all of them.
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"