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 APRIL 17, 2024
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.
Symptoms
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:
2394289.1
2275051.1
STEPS TO REPRODUCE:
===============
Review user details:
select * from fnd_user where user_name like '<user name>';
Returns the following:
USER_ID,USER_NAME,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,ENCRYPTED_FOUNDATION_PASSWORD,ENCRYPTED_USER_PASSWORD,SESSION_NUMBER,START_DATE,END_DATE,DESCRIPTION,LAST_LOGON_DATE,PASSWORD_DATE,PASSWORD_ACCESSES_LEFT,PASSWORD_LIFESPAN_ACCESSES,PASSWORD_LIFESPAN_DAYS,EMPLOYEE_ID,EMAIL_ADDRESS,FAX,CUSTOMER_ID,SUPPLIER_ID,WEB_PASSWORD,USER_GUID,GCN_CODE_COMBINATION_ID,PERSON_PARTY_ID
<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,START_TIME,END_TIME,PID,SPID,TERMINAL_ID,LOGIN_NAME,SESSION_NUMBER,SUBMITTED_LOGIN_ID,SERIAL#,PROCESS_SPID,LOGIN_TYPE
<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
ERROR
=====
You have encountered an unexpected error. Please contact the System Administrator for assistance.
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |