HOW TO RETRIEVE APPS PASSWORD in R12

HOW TO RETRIEVE APPS PASSWORD – R12

Steps to find apps password in R12:

1. 1)    Connect as SYSTEM or SYS USER
2. 2)    Create Function to decrypt the encrypt password
3. 3)    Query for the encrypted password
4. 4)    Query for decrypt the password
5. 5)    validate the apps password  

STEP 1:

[oracle@localhost]$sqlplus [system or sys]/<password>

STEP 2:

$SQL>create FUNCTION apps.decrypt_get_pwd(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’;

/

Function created.

STEP 3:

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

ENCRYPTED_FOUNDATION_PASSWORD

——————————————————————————–

FDSFJKSFSDIO43345NFDF983TRFI3R3OFVFDJVOERGF3REFNOEFEFEWFDSCSDCDSFDS

STEP 4:

$SQL>SELECT apps.decrypt_get_pwd(‘GUEST/ORACLE’,FDSFJKSFSDIO43345NFDF983TRFI3R3OFVFDJVOERGF3REFNOEFEFEWFDSCSDCDSFDS) from dual;

Output:

APPS.DECRYPT_PIN_FUNC('GUEST/ORACLE','FDSFJKSFSDIO43345NFDF983TRFI3R3OFVFDJVOERGF3REFNOEFEFEWFDSCSDCDSFDS')

..........................................................................................................

welcome

STEP 5:

$SQL> conn apps/welcome

Connected.