How to Decrypt Sysadmin Password in EBS R12

 Follow the below steps to Decrypt Sysadmin Password .

1. Connect Apps user and create below package specification and package Body .

Package Specification :

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

Package created.

Package Body :

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

Package body created


2. Once Package created successfully ,Please validate the and proceed with below script to get the password .


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


Enter the SYSADMIN user name in Capital Letters .

You can the password like below 

USER_NAME                  DESCRIPTION       PASSWORD
---------------- -------------------------- -----------   ------------------------------
SYSADMIN                 System Administrator      lkojhtfft@PROD



                                   Hope you found this helpful ,Thank you