Oracle has introduced a new utility to change the Oracle E-Business Suite passwords in R12.1.2, AFPASSWD is an enhanced version of FNDCPASS utility.

1) AFPASSWD only prompts for passwords required for the current operation. allowing separation of duties between applications administrators and database administrators.

2) AFPASSWD can be run from the database tier as well as the application tier. In contrast, FNDCPASS can only be run from the application tier.

3) This also improves interoperability with Oracle Database Vault. In contrast, the FNDCPASS utility currently requires specification of the APPS and the SYSTEM usernames and corresponding passwords, preventing separation of duties between applications administrators and database administrators.

3) When changing a password with AFPASSWD, the user is prompted to enter the new password twice to confirm.

SAMPLE OUTPUT: Changing SYSADMIN Password  

$AFPASSWD -f SYSADMIN  
Enter the ORACLE password of Application Object Library ‘APPSUSER’:  
Connected successfully to APPS.  Working…  
Enter new password for user [SYSADMIN]:  
Verify new password for user [SYSADMIN]:  
Password is changed successfully for user SYSADMIN.  
Password is changed successfully for user SYSADMIN.  
AFPASSWD completed successfully.
 

SAMPLE OUTPUT: Changing APPLSYS Password

$AFPASSWD -c apps@PROD -s APPLSYS  
Enter the ORACLE password of Application Object Library ‘APPSUSER’:  
Connected successfully to APPS.  
Enter the password for your ‘SYSTEM’ ORACLE schema:  
Connected successfully to SYSTEM.  Working…  
Enter new password for user:  
Verify new password for user:  
Working…  
AFPASSWD completed successfully.