HOW TO FIND SYSADMIN PASSWORD – R12

After following the below steps we are not able to find the sysadmin password from backend.

STEP 1:

$SQL> conn apps/welcome
Connected.

STEP 2:

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

Package created.

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;

Package body created.

STEP 3:

SELECT Usr.User_Name,
Usr.Description,