How to Decrypt APPS Password in 11i/R12

STEP 1 : Login instance with sqlplus:

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';

 Function created.

SQL>  SELECT ENCRYPTED_FOUNDATION_PASSWORD from APPS.fnd_user where  USER_NAME='GUEST';

 ENCRYPTED_FOUNDATION_PASSWORD

 -----------------------------------------

ZHBBD9066F53BC9E88B94FA8CB63E4B78E084C83D24F3A312 ->place it in below query

STEP 2 : To Get the Apps Password 

SQL>  SELECT APPS.decrypt_pin_func ('GUEST/ORACLE','ZHBBD9066F53BC9E88B94FA8CB63E4B78E084C83D24F3A312') from  dual;

 APPS.DECRYPT_PIN_FUNC ('GUEST/ORACLE','ZHBBD9066F53BC9E88B94FA8CB63E4B78E084C83D24F3A312'

 --------------------------------------------------------

 APPSPASS  (this is your apps user password)