Decrypt FND_USER password in 11i/R12

For Apps DBA sometimes it is necessary to decrypt the EBS Application user’s password. Below package can be used to decrypt the FND_USER password. You will need password of “apps” database userid to be able to decrypt the application user’s password.

Step 1: Create Package Specfication

SQL>  create or replace 
PACKAGE test_package12
AS
   FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)
      RETURN VARCHAR2;
END test_package12;
/

SQL> create or replace 
PACKAGE BODY test_package12
AS
   FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)
      RETURN VARCHAR2
   AS
      LANGUAGE JAVA
      NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String';
END test_package12;
/

SQL> SELECT USERTABLE.USER_NAME
,(SELECT test_package12.decrypt (UPPER ('&apps_password') 
,usertable.encrypted_user_password)
FROM DUAL) AS encrypted_user_password
FROM FND_USER USERTABLE
WHERE usertable.user_name LIKE UPPER ('&USER_NAME_TO_DECRYPT');

SQL> drop package test_package12;

• Author
• Recent Posts

Brijesh Gogia

I’m an experienced Cloud/Oracle Applications/DBA Architect with more than 15 years of full-time DBA/Architect experience. I have gained wide knowledge on Oracle and Non-Oracle software stack running on-prem and on Cloud and have worked on several big projects for multi-national companies. I enjoy working with leading-edge technology and have a passion for Cloud architecture, automation, database performance, and stability. Thankfully my work allows me time for researching new technologies (and to write about them).

Latest posts by Brijesh Gogia (see all)

• Oracle Multitenant DB 4 : Parameters/SGA/PGA management in CDB-PDB - July 18, 2020
• Details of running concurrent requests in Oracle EBS - May 26, 2020
• Oracle Multitenant DB 3 : Data Dictionary Architecture in CDB-PDB - March 20, 2020