Recover apps password in R12

First create function as below:
SQL> create or replace 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.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String’;
4
5 /

Function created.

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

ENCRYPTED_FOUNDATION_PASSWORD
——————————————————————————–
ZGF920B0BA36357844AE3D504ED5C476B34674F21ADCA6918A87A4643B9E0122788F597973E8AF10155555849E93834C1255
SQL> SELECT apps.decrypt_pin_func(‘GUEST/ORACLE’,'ZGF920B0BA36357844AE3D504ED5C476B34674F21ADCA6918A87A4643B9E0122788F597973E8AF10155555849E93834C1255′) from dual;

APPS.DECRYPT_PIN_FUNC(‘GUEST/ORACLE’,'ZG761B2FB6A2C49BC802F57E55AC26637388B4EA99
——————————————————————————–
APPS

Note the output here we got is in caps “APPS” but actual password is in lower case so here it is apps

About these ads