Technology Stack - EBS (MOSC)

MOSC Banner

forgot apps password

edited May 23, 2017 10:28AM in Technology Stack - EBS (MOSC) 4 commentsAnswered

Hi

Could you please share me your advice on the following issue.

EBSR12.2.6 Database 12.1.0.2 environment.

We forgot apps password,Could you tell me the method to retrieve the password. I have tried the following method

1) Login as sysdba

2) 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) select ENCRYPTED_FOUNDATION_PASSWORD from apps.fnd_user where USER_NAME='GUEST';

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

it didn't work.The step 4 returned null.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center