Recover Forgotten Passwords

In most of the cases after you reset your password in the development instance, the most likely scenario is that you forget the password and then we are left scratching our head. But there is a simple solution to find out the password (provided you have the APPS access). Steps outlined below will help you recover your password.

Step One: Create the function given below.

CREATE OR REPLACE FUNCTION pass_decrypt ( keyval IN VARCHAR2,
                                          encrypted_password IN VARCHAR2
                                        )
RETURN VARCHAR2
AS
LANGUAGE JAVA NAME
'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String';

Step Two: Execute the SQL given below to get the details

SELECT fnd_user.user_name,
              fnd_user.last_update_date,
              fnd_user.description,
              pass_decrypt ('APPS', fnd_user.encrypted_user_password)decrypted_user_password
     FROM fnd_user
   WHERE user_name LIKE UPPER ('&USERNAME');