My Oracle Support Banner

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.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.