Finding apps password in R12

• Finding apps password in R12
• Connect system or sys user
• Create Function for to decrypt the encrypted password
• Write the Query for PASSWORD
• Query for decrypt the password
• Test the apps user connection

1.[oradev@ltk1 ~]$ sqlplus '/ as sysdba';

SQL*Plus: Release 11.2.0.3.0 Production on Sat Aug 12 10:24:06 2017

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

1.SQL> create FUNCTION apps.decrypt_get_pwd(in_chr_key IN VARCHAR2,in_chr_encrypted_pin IN VARCHAR2)

RETURN VARCHAR2 AS LANGUAGE JAVA NAME'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String';

/  2    3

Function created.

2.SQL> select ENCRYPTED_FOUNDATION_PASSWORD from apps.fnd_user where USER_NAME='GUEST';

ENCRYPTED_FOUNDATION_PASSWORD

--------------------------------------------------------------------------------

ZHF38731B0EE013C065B69188C9C1FFAED237E4C746E191601BE80FE4861F77266E9ADC396911B3A

DC284FF5A26260D90636

SQL> SELECT apps.decrypt_get_pwd('GUEST/ORACLE','ZHF38731B0EE013C065B69188C9C1FFAED237E4C746E191601BE80FE4861F77266E9ADC396911B3ADC284FF5A26260D90636') from dual;

APPS.DECRYPT_GET_PWD('GUEST/ORACLE','ZHF38731B0EE013C065B69188C9C1FFAED237E4C746

--------------------------------------------------------------------------------

APPS

SQL>