Advantage of AFPASSWD utility in Oracle EBS R 12.1.2

Advantage of AFPASSWD utility in Oracle EBS R 12.1.2

   I was just experimenting with some test cases and got chance to work with AFPASSWD,which is advantageous  in comparison with FNDCPASS.

Below are the advantages:

1)We can run this utility from DB tier and Apps tier.

2)We can make sure the password is hidden(invisible to users),while changing,which is very good security option.

Below are some of the syntax to use it:

AFPASSWD [-c APPSUSER[@TWO_TASK]] [-f FNDUSER]
AFPASSWD [-c APPSUSER[@TWO_TASK]] [-o DBUSER]
AFPASSWD [-c APPSUSER[@TWO_TASK]] [-a]
AFPASSWD [-c APPSUSER[@TWO_TASK]] [-l ORACLEUSER [TRUE] |
[FALSE]]
AFPASSWD [-c APPSUSER[@TWO_TASK]] [-L [TRUE] | [FALSE]]
AFPASSWD [-c APPSUSER[@TWO_TASK]] [-s] APPLSYS

Eg:When you login with 'applmgr' and after setting environment,we can run this utility as below:

AFPASSWD -c apps@TWO_TASK -s APPLSYS

Enjoy apps DBA tasks....


Thanks,

Rafi.