Query To Get Password For Application User In EBS R12

Query to get password for application user

Below above query works only in 11i since Oracle removed ‘Guest User Password’ profile option from Release 12 so please use below query for R12

Select Usertable.User_Name , ( Select XX_Get_User_Pwd.Decrypt (Upper ( ( Select ( Select Get_User_Pwd.Decrypt (Upper ( ( Select Upper (Fnd_Profile.Value ('Guest_User_Pwd')) From Dual)), Usertable.Encrypted_Foundation_Password) From Dual) As Apps_Password From Fnd_User Usertable Where Usertable.User_Name Like Upper ( ( Select Substr (Fnd_Profile.Value ('Guest_User_Pwd') , 1 , Instr (Fnd_Profile.Value ('Guest_User_Pwd'), '/') - 1 ) From Dual)))) ,Usertable.Encrypted_User_Password) From Dual) As Encrypted_User_Password From Fnd_User Usertable Where Usertable.User_Name Like Upper ('&Username');

=========================================================================

QUERY TO GET THE PASSWORD FOR THE FRONTEND USER LOGIN

====================================================================

ALTER SESSION SET current_schema = apps;

Select Usr.User_Name , Usr.Description, XX_Get_User_Pwd.Decrypt( ( Select ( Select Get_User_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 = '&User_Name';