How to Retrieve Forgotten Apps Password in Oracle EBS R12

 Steps:

 1: log in to the database server with sys user

 sqlplus / as sysdba

 2: Create Function to decrypt the encrypted password


 SQL> create FUNCTION apps.decrypt_pin_func(in_chr_key IN VARCHAR2,in_chr_encrypted_pin IN VARCHAR2)
 RETURN VARCHAR2
 AS
 LANGUAGE JAVA NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String';
 /

 3 : Query for Encrypted password


SQL> select ENCRYPTED_FOUNDATION_PASSWORD from apps.fnd_user where USER_NAME='GUEST';


 Output

 ENCRYPTED_FOUNDATION_PASSWORD
 --------------------------------------------------------------------------------
 ZG37E123746712BDB2D99E048FE44AE662F2713E2EDB443391BABA0414CADDB7A2E6DD45BBAFA7270A663E5EEBA837F5548A

 4: Past the Encrypted password from the above query output into the below query and execute

 SELECT apps.decrypt_pin_func('GUEST/ORACLE','ZG37E123746712BDB2D99E048FE44AE662F2713E2EDB443391BABA0414CADDB7A2E6DD45BBAFA7270A663E5EEBA837F5548A') from dual;


 Output

 APPS.DECRYPT_PIN_FUNC('GUEST/ORACLE','ZG37E123746712BDB2D99E048FE44AE662F2713E2EDB443391BABA0414CADDB7A2E6DD45BBAFA7270A663E5EEBA837F5548A')
 --------------------------------------------------------------------------------
 India123

 5: Test apps password is working or not

Conn apps

Enter password