How to get your apps password if you forgot

drop FUNCTION apps.decryptappspwd;


create FUNCTION apps.decryptappspwd(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
--------------------------------------------------------------------------------
ZH15F2D57A9D301A223EF2B428DE8224FE9A3D9165345E7A2A645159435CEC0336E04DF7BCE76CDA
3110B72BE0743CD4576B

SQL> SELECT apps.decryptapps pwd('GUEST/ORACLE','ZH15F2D57A9D301A223EF2B428DE8224FE9A3D9165345E7A2A645159435CEC0336E04DF7BCE76CDA3110B72BE0743CD4576B') from dual;

APPS.DECRYPTAPPSPWD('GUEST/ORACLE','ZH15F2D57A9D301A223EF2B428DE8224FE9A3D91653
--------------------------------------------------------------------------------
APPS