How to troubleshoot Ebusiness Suite "Login Assistance" functionality in 12.1.3
This isn't a custom solution, it is more of a request on how to troubleshoot this functionality as a SYSADMIN and DBA user.
We are getting a number of users who are not getting their Login Assistance requests in email to change their password.
Is there some application troubleshooting or SQL commands I can run for FND_USER and find out what has happened to the email to that user that requested the password reset?
My understanding the emails are handled by the WF_NOTIFCATION AQ object.
Some outcomes to this analysis I would expect:
1) User didn't enter their login name or email address correctly in the form when they requested reset, but page accepted it anyways (possibly a different username by mistake)