Steps for finding password of a User in Oracle Apps R12/11i

There is a simply way to by which you can get the application login password without chasing the DBA.

Here I am sharing the script to get the oracle application password.

select user_name, get_pwd.decrypt (
(SELECT (SELECT get_pwd.decrypt(FND_WEB_SEC.GET_GUEST_USERNAME_PWD,
usertable.encrypted_foundation_password)FROM DUAL) AS apps_password
FROM fnd_user usertable
WHERE usertable.user_name = (SELECT substr(FND_WEB_SEC.GET_GUEST_USERNAME_PWD,
1,instr(FND_WEB_SEC.GET_GUEST_USERNAME_PWD,'/')-1) from dual)), usr.ENCRYPTED_USER_PASSWORD) password
from fnd_user usr where usr.user_name LIKE upper('you application user name')

Here i am giving user name as "operations" :