Idea Summary
Add a "Forgot my password" link on the login page and provide a public app template to submit the request
Use Case
The "Forgot my password" is being more and more considered as a standard in Web applications, and to implement it into Oracle APEX in the current releases requires specific developments that could be standardized if it was a native feature.
Preferred Solution (Optional)
The idea would be first to have a field defined as "Forgot password" which will be positioned below the Password field in the login page and provide the link (that might be parametrized in a "get_url" format) to a specific application that would be necessary to confirm the email attached to the end-user. It would also be nice if we could provide a 'Forgot password' template application (that needs to be a public one and includes a modal dialog page) where the user should confirm his email. Of course the logic then will differ and, except maybe the presence of an "email" field (to check that the email format is respected), it will be the developers' tasks.