What to Do If You Forgot Your APPS password in R12

We can find the apps password 3 methods

OS Level:-

1.  history|grep FNDCPASS

2.  vi .bash_history or .sh_history

DB Level:-

Step to Find APPS PASSWORD:

SQL> show user

USER is "SYS"

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';

/

Function created.

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

ENCRYPTED_FOUNDATION_PASSWORD

--------------------------------------------------------------------------------

PGA48F6CA123195C053FA4A247AE658615ECC4920653CBF5590CA458321526D79FD37F5AF6A5A9B5EEFE49F20547F673AB16

SQL> SELECT apps.decrypt_pin_func('GUEST/ORACLE','PGA48F6CA123195C053FA4A247AE658615ECC4920653CBF5590CA458321526D79FD37F5AF6A5A9B5EEFE49F20547F673AB16') from dual;

APPS.DECRYPT_PIN_FUNC('GUEST/ORACLE','PGA48F6CA123195C053FA4A247AE658615ECC49206

--------------------------------------------------------------------------------
apps

SQL>conn apps/apps;

connected