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

Oracle Fusion SQL Queries to get Sales Person/Sales Representative information for an Order

1) Get sales person details if the Sales Person ID is known SELECT  jrs.SALESREP_NUMBER  ,         jrs.status           ,         jrs.START_...