Changing Apps Password

Using FNDCPASS or AFPASSWD utility:-

FNDCPASS was introduced from 11.5.10


how to create the same user like apps:

CREATE USER PWCAPPS
  IDENTIFIED BY pwcapps
  DEFAULT TABLESPACE APPS_TS_TX_DATA
  TEMPORARY TABLESPACE TEMP1
  PROFILE DEFAULT
  ACCOUNT UNLOCK;

  GRANT CONNECT TO PWCAPPS;

  grant dba to pwcapps

  ALTER USER PWCAPPS DEFAULT ROLE ALL;



How to grep apps password in R12?

Recover apps 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';
  2  /

Function created.

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

ENCRYPTED_FOUNDATION_PASSWORD
--------------------------------------------------------------------------------
ZG0B59AD0E92F5E3FD5D043F94071B63BDB5038F13C3CC924FC0FA754C06691EDE3D58EEE5A03B10
713E6637AEB89167F9A8


SQL> select apps.decrypt_pin_func('GUEST/ORACLE','ZG0B59AD0E92F5E3FD5D043F94071B63BDB5038F13C3CC924FC0FA754C06691EDE3D58EEE5A03B10713E6637AEB89167F9A8') from dual;

APPS.DECRYPT_PIN_FUNC('GUEST/ORACLE','ZG0B59AD0E92F5E3FD5D043F94071B63BDB5038F13
--------------------------------------------------------------------------------
APPDEV