"Forgot Password Link" Is Not Generating Password And Throws Error 'ORA-20000' On Item Type 'UMXUPWD'

(Doc ID 739493.1)

Last updated on APRIL 27, 2016

Applies to:

Oracle User Management - Version 11.5.10.2 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Symptoms

On 11.5.10.2 RUP 6,
after providing the Username through "Forgot Password link", you will receive an email from the Mailer asking to approve Password Reset Request, but never receive the new system generated password.
The following error occurs for this item type (UMXUPWD):

ORA-20000: An unexpected error has occurred.

EXPECTED BEHAVIOR
Expect the Mailer to mail the new system generated password.

WHAT IS WORKING
The following continues to work:

+All other Application function normally.
+Change Profile option Sign-on Password length from value 10 to 5 characters

SPECIFIC DATA
- Forgot Password link

The issue can be reproduced at will with the following steps:
1. Click on Forgot Password link and provide User-name.
2. Receive email from Mailer asking to approve Password Reset Request.
3. See that you do not receive the new password.

The issue has the following business impact:
Due to this issue, users cannot log in using new password as its not generating.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms