Finding Apps user Password in R12

Simple way to find out apps password in R12, Please review below for the same

1) Connect to SYSTEM or SYS USER

2) Create Function for to decrypt the encrypted password

3) Query for PASSWORD

4) Query for decrypt the password

5) Test the apps user connection

High Level steps :

******************

SQL> conn system/tester

Connected.

SQL> create FUNCTION apps.decrypt_get_pwd1(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';

/

Function created.

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

ENCRYPTED_FOUNDATION_PASSWORD

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

ZGFB2B0CE9D9FF4EE882234E6F8EC0F48163D3FFF3E57C62E0824592516E24630BB455B613D1A14F58F2F211932E25F00BE8

SQL> select apps.decrypt_get_pwd1('GUEST/ORACLE','ZGFB2B0CE9D9FF4EE882234E6F8EC0F48163D3FFF3E57C62E0824592516E24630BB455B613D1A14F58F2F211932E25F00BE8') from dual;

APPS.DECRYPT_GET_PWD1('GUEST/ORACLE','ZGFB2B0CE9D9FF4EE882234E6F8EC0F48163D3FFF3

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

T3STA4P