HOW TO FIND/VIEW SYSADMIN PASSWORD – R12

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

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


SELECT Usr.User_Name,
Usr.Description,
XXtest_GET_PWD.Decrypt (
(SELECT (SELECT XXtest_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 = 'SYSADMIN';

How To Change/Reset The Password For The SYSADMIN User

Through Backend

DECLARE
   l_flag   BOOLEAN;
 BEGIN
   l_flag := fnd_user_pkg.changepassword ('sysadmin', 'sysadmin');
  DBMS_OUTPUT.put_line (   'l_flag = '||CASE 
                               l_flag
                              WHEN TRUE
                                THEN 'true'
                              ELSE 'false'
                            END
                        );

 END;
 /

Through unixbox

Change the SYSADMIN password:


applmgr@[unixhost]-> FNDCPASS apps/PASS12011 0 Y system/PASS11445 USER SYSADMIN PASSs54lpRd