The Encrypted_foundation_password in FND_USER Becomes Invalidated and Generates You have encountered an unexpected error. Please contact the System Administrator for assistance Error
(Doc ID 2431712.1)
Last updated on OCTOBER 16, 2019
Applies to:Oracle E-Business Suite Technology Stack - Version 12.2.7 to 12.2.7 [Release 12.2]
Oracle Application Object Library - Version 12.2.7 to 12.2.7 [Release 12.2]
Information in this document applies to any platform.
On : 12.2.7 version, Basic SysAdmin functions, maintenance
Encrypted_foundation_password in FND_USER is becoming invalid.
Did an upgrade from 12.2.6 to 12.2.7 2 and multiple users are getting issues with their password.
Found that the password in FND_USER is being invalidated for unknown reason.
A user was working yesterday and using the same password the day after is not working.
The password is invalid in FND_USER.
Reviewed the following documents:
STEPS TO REPRODUCE:
Review user details:
select * from fnd_user where user_name like '<user name>';
Returns the following:
<userid>,<user id>,2018-05-19 04:08:24,-1,2016-03-21 15:52:38,,,INVALID,INVALID,,2016-03-21,,<user name>,2018-06-05 07:57:45,2018-05-19 04:08:24,,,,,<email address>,,,,,,,,
select * from fnd_logins where user_id = <user id from above> order by start_time desc
<login id>,<user id>,2018-06-05 07:57:45,2018-06-05 07:59:47,,,,,,,,,FORM
<login id>,<user id>,2018-06-01 16:28:06,2018-06-01 17:21:50,,,,,,,,,FORM
<login id>,<user id>,2018-06-01 12:13:15,,,,Concurrent,,,,,,
<login id>,<user id>,2018-06-01 12:12:37,,,,Concurrent,,,,,,
<login id>,<user id>,2018-06-01 12:10:32,2018-06-01 13:13:,,,,,,,,FORM
You have encountered an unexpected error. Please contact the System Administrator for assistance.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document