Monday 1 June 2015

How to get Oracle application User password from backend

You will get Oracle application password by passing user name in capital letter in below given query parameter.
-----------------------------------------
SELECT USR.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 =:P_USER_NAME
--------------------------------------
eg. P_USER_NAME =SMITH_D
Output for ablove query
-----------------------------------
USER_NAME   PASSWORD
----------------------------------
SMITH_D           Orafin@1234

No comments:

Post a Comment

How to resolve issue for BIP RTF template XML tags showing value as <?ref: 0000xx?>

 How to resolve issue for BIP RTF template XML tags showing value as <?ref: 0000xx?>  Sometime these xml data tags automatically chang...