Tuesday, March 18, 2014

Changing Apps password

Changing Apps password

In 11i there were a few steps in order to change the apps password.

1. Shutdown the environment.
2.Backup tables FND_USER and FND_ORACLE_USERID
3. execute FNDCPASS to change the apps password.
Ex. FNDCPASS apps/[oldpassword] 0 Y system/[system password] SYSTEM APPLSYS [new apps password]

0 & Y are flags for FND Executable like FNDCPASS & FNDLOAD where ,0 is request id (request ID 0 is assigned to request ID’s which are not submitted via Submit Concurrent Request Form.)
‘Y’ indicates the method of invocation. i.e. it is directly invoked from the command-line not from the Submit Request Form.

4. Manually modify files such as appsweb.cfg and wdbsvr.app
5. Startup the environment.

In R12

1. Shutdown the environment.
2. Backup tables FND_USER and FND_ORACLE_USERID
3. Execute FNDCPASS as above.

4. Startup the environment.

No comments:

Post a Comment