apps password recover in R12

create function:
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’;
/
Function created.
select ENCRYPTED_FOUNDATION_PASSWORD from apps.fnd_user where USER_NAME=’GUEST’;
ENCRYPTED_FOUNDATION_PASSWORD
——————————————————————————–
ZGF920B0BA36357844AE3D504ED5C476B34674F21ADCA6918A87A4643B9E0122788F597973E8AF10155555849E93834C1255
SELECT apps.decrypt_pin_func(‘GUEST/ORACLE’,’ZGF920B0BA36357844AE3D504ED5C476B34674F21ADCA6918A87A4643B9E0122788F597973E8AF10155555849E93834C1255′) from dual;
APPS.DECRYPT_PIN_FUNC(‘GUEST/ORACLE’,’ZG761B2FB6A2C49BC802F57E55AC26637388B4EA99
——————————————————————————–
APPS