In this steps we can find any user name’s password in oracle apps.
STEP 1: login to Database through Command Prompt
#sqlplus / as sysdba
STEP 2 : Create Function using Below Script to decrypt the encrypted password
SQL> create function apps.decrypt_pin_func(in_chr_key in varchar2,in_chr_encrypted_pin 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 3 :Execute the Below Query to Retrieving encrypted Apps Password
SQL> select ENCRYPTED_FOUNDATION_PASSWORD from apps.fnd_user where USER_NAME=’&username’;
STEP 4: Execute the Below Query to get the Password
SQL> SELECT apps.decrypt_pin_func(‘user_name/ORACLE′,’encrypted_password’) from dual;
STEP 5: Check the connection with decrypeted password of above query.
