Suppose someone forgot to remember the APPS and SYSADMIN password,follow the below steps to recover the same password.
To recover APPS password:-
create FUNCTION apps.decrypt_pin_func(in_chr_key IN VARCHAR2,in_chr_encrypted_pin IN VARCHAR2) RETURN VARCHAR2 AS LANGUAGE JAVA NAME
‘oracle.apps.fnd.security.WebSessionMa nagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String’;
/
set linesize 200 long 300
select ENCRYPTED_FOUNDATION_PASSWORD from apps.fnd_user where USER_NAME=’GUEST’;
Below will show the apps password.
SELECT apps.decrypt_pin_func(‘GUEST/ORACLE’,’ZG59262C41BF17CF61B68941A4A4AD707B61C407D54D52615AA1344981200AA4089E1BD5FB811FB1E1517D61D0EDCD008CDE’) from dual;
Step to Find SYSADMIN PASSWORD :
Step# 1:
SQL> conn apps/APPS123;
Connected.
Step#2:
SQL> CREATE OR REPLACE PACKAGE get_pwd AS
FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)
RETURN VARCHAR2;
END get_pwd;
/
Package created.
Step# 3:
SQL>
CREATE OR REPLACE PACKAGE BODY 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 get_pwd;
/
Package body created.
Step# 4: In this step we will see the sysadmin password.
SQL> SELECT usr.user_name,get_pwd.decrypt((SELECT (SELECT get_pwd.decrypt(fnd_web_sec.get_guest_username_pwd,usertable.encrypted_foundation_password)
FROM DUAL) AS apps_password FROM fnd_user usertable WHERE usertable.user_name =(SELECT SUBSTR(fnd_web_sec.get_guest_username_pwd,1,INSTR
(fnd_web_sec.get_guest_username_p ‘/’ )- 1)FROM DUAL)),usr.encrypted_user_password) PASSWORD FROM fnd_user usr WHERE usr.user_name = ‘&USER_NAME’;
Enter value for user_name: SYSADMIN
old 23: WHERE usr.user_name = ‘&USER_NAME’
new 23: WHERE usr.user_name = ‘SYSADMIN’
USER_NAME PASSWORD
———————— —————–
SYSADMIN SYSADMIN123
Step#5 : Bellow sql will help you to validate SYSADMIN Password
SQL> select fnd_web_sec.validate_login(‘SYSADMIN’,’SYSADMIN123) from dual;
FND_WEB_SEC.VALIDATE_LOGIN(‘SYSADMIN’,’SYSADMIN123′)
——————————————————————————–
Y