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
-----------------------------------------
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