Method 1 : Query To Find Password Of A User In Oracle Apps(11i\R12)

 How to Find password of a User in Oracle Apps(11i\R12)?

Method 1: Create below package

CREATE OR REPLACE PACKAGE xx_get_user_pwd

AS

    FUNCTION decrypt ( KEY IN VARCHAR2 ,VALUE IN VARCHAR2 ) RETURN VARCHAR2;

END xx_get_user_pwd;
/

CREATE OR REPLACE PACKAGE BODY xx_get_user_pwd

AS

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

END xx_get_user_pwd;
/