How to change passwords to include special characters using FNDCPASS

Note that the term ‘Special Characters’ is used in this article to refer to those characters who are shown in the table below.

Use of the FNDCPASS utility to change the passwords of database users such as APPS , APPLSYS, GL etc to include special characters is NOT supported .
If an attempt is made to use FNDCPASS to include a special character in the password for a database user one of the following errors will typically be encountered . 

1. Cause: changepassword failed due to ORA-01403: no data found.

2. syntax error: unexpected end of file

3. syntax error near unexpected token `newline’

4. APP-FND-02704: Unable to alter user APPS to change password.

5. APP-FND-01564: ORACLE error 1017 in AFPCOA

6. FNDCPASS was not able to decrypt password for user ‘APPS’ during applsys password change.

7. Passwords must be at least 5 characters long. ( This error can be encountered even when password is > 5 characters long) 

Which error is encountered depends on the factors such as which database user is having their password changed , which special character is being used and the position where the special character appears in the password ( eg first character of password or second character etc) 

It is possible to use FNDCPASS to change the password of an EBS user such as SYSADMIN and include one or more special characters of those listed below although there are some provisos for some characters which are described in table below. In certain cases it may be necessary to include the new password in quotation marks 

Example 1

FNDCPASS apps/apps 0 Y system/manager USER SYSADMIN !welcome1

In this example the password of EBS user SYSADMIN is changed to !welcome1 and no quotation marks are required . 

Example 2

FNDCPASS apps/apps 0 Y system/manager USER SYSADMIN $welcome1

This attempt to change the password will FAIL and the log file created will contain an error message.

Example 3
FNDCPASS apps/apps 0 Y system/manager USER SYSADMIN ‘$welcome1’

By modifying Example 2 by adding quotation marks this example will work and the password will be changed to $welcome1 .

  • June 12, 2016 | 20 views
  • Comments