Recover apps password in R12.   2 comments

Hello all, Here i will provide the steps to recover apps password.

—–“Please check for the correct syntax in screenshots”—–

First create function as below:
SQL> create or replace 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’;
4
5 /

Function created.

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

ENCRYPTED_FOUNDATION_PASSWORD
——————————————————————————–
ZGF920B0BA36357844AE3D504ED5C476B34674F21ADCA6918A87A4643B9E0122788F597973E8AF10155555849E93834C1255
SQL> SELECT apps.decrypt_pin_func(‘GUEST/ORACLE’,’ZGF920B0BA36357844AE3D504ED5C476B34674F21ADCA6918A87A4643B9E0122788F597973E8AF10155555849E93834C1255′) from dual;

APPS.DECRYPT_PIN_FUNC(‘GUEST/ORACLE’,’ZG761B2FB6A2C49BC802F57E55AC26637388B4EA99
——————————————————————————–
APPS

Note the output here we got is in caps “APPS” but actual password is in lower case so here it is apps

pwd1 pwd2

Advertisements

Posted October 5, 2013 by balaoracledba.com in 11i/R12

2 responses to “Recover apps password in R12.

Subscribe to comments with RSS.

  1. from which user you create function

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: