SYSADMIN Password Retrival in R12

How verify the sysadmin password from command line?
*********************************************************************************


Ans:
This utility can be used to verify the GUEST/ORACLE password
SQL>select fnd_web_sec.validate_login('SYSADMIN','')from dual;
If it returns Y then sysadmin password is correct
If it returns N then sysadmin password that we are using
Eg:
SQL> select fnd_web_sec.validate_login('SYSADMIN','SYSADMIN123') from dual;
FND_WEB_SEC.VALIDATE_LOGIN('SYSADMIN','SYSADMIN123')
--------------------------------------------------------------------------------
N
SQL> select fnd_web_sec.validate_login('SYSADMIN','SYSADMIN') from dual;
FND_WEB_SEC.VALIDATE_LOGIN('SYSADMIN','SYSADMIN')
--------------------------------------------------------------------------------
Y


CREATE OR REPLACE PACKAGE xxx_GET_PWD AS
FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)
RETURN VARCHAR2;
END XXX_GET_PWD;
/

CREATE OR REPLACE PACKAGE BODY xxx_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 XXX_GET_PWD;
/

SELECT Usr.User_Name,
 Usr.Description,
 XXX_GET_PWD.Decrypt (
 (SELECT (SELECT XXX_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';

USER_NAME
--------------------------------------------------------------------------------
DESCRIPTION
--------------------------------------------------------------------------------
PASSWORD
--------------------------------------------------------------------------------
SYSADMIN
System Administrator
xxxxxx