Method 2: Query to get password for apps user

 Query to get password for apps user

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

Select ( Select XX_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));