Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Blog Post

Special Characters in APPS Password using FNDCPASS

May 5, 2023 APPS DBA
Special Characters in APPS Password using FNDCPASS

Special Characters in APPS Password using FNDCPASS

Today, we will discuss the use of special characters in Oracle E-Business Suite (EBS) APPS passwords and the implications of using the FNDCPASS utility for password changes.

Using special characters in passwords, particularly for database users like APPS, APPLSYS, and GL, is not supported when utilizing the FNDCPASS utility.

If you attempt to include a special character in a database user’s password using FNDCPASS, you are likely to encounter one of the following errors:

  1. Cause: change password 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 unable to decrypt the password for user ‘APPS’ during applsys password change.
  7. Passwords must be at least 5 characters long. (This error may occur even when the password is longer than 5 characters.)
  8. It may not be possible to access the schema or change the password if the stored value is unknown.
  9. The specific error encountered depends on factors such as the database user being modified, the special character being used, and the position of the special character in the password (e.g., first or second character).

However, it is possible to use FNDCPASS to change the password of certain EBS users, such as SYSADMIN, and include special characters from a provided list. It is important to note that there may be specific considerations or restrictions for certain characters, which can be found in a table given below. In some cases, enclosing the new password in quotation marks may be necessary.

In summary, while the use of special characters in EBS passwords with FNDCPASS is generally unsupported, there are exceptions for certain users. It is essential to follow Oracle’s guidelines and restrictions for password management in EBS.

 

CHARACTER DESCRIPTION NOTES
! Exclamation Mark  
 “ Quotation Mark Password must be enclosed by quotation marks.
# Hash/Number Password must be enclosed by quotation marks.
$ Dollar Password must be enclosed by quotation marks.
% Percent  
& Ampersand Password must be enclosed by quotation marks. May get problem recognising the character if fnd_user_pkg.validatelogin() is used.
Apostrophe Not possible to use with FNDCPASS.
( Open Parenthesis Password must be enclosed by quotation marks.
) Close Parenthesis Password must be enclosed by quotation marks.

* Asterisk  
, Comma  
Hyphen – Minus  
. Full Stop  
/ Slash  
: Colon  
; Semicolon  
< Less than sign Password must be enclosed by quotation marks.
= Equals sign  
> Greater than sign Password must be enclosed by quotation marks.
? Question mark  
@ At sign  
[ Open square bracket  
  Backslash Password must be enclosed by quotation marks.
] Close square bracket  
^ Caret  
_ Underscore Cannot be used for APPS password or start any transaction managers.
` Grave accent Password must be enclosed by quotation marks.
{ Left curly bracket  
| Vertical bar Password must be enclosed by quotation marks.
} Right square bracket  
~ Tilde  
  Blank Space Cannot be used for passwords.

Note:

Please take note of the following details:

  • An important deviation from the standardization of mixed case passwords is observed with the APPLSYSPUB account. Its password continues to remain in uppercase.
  • Currently, Oracle E-Business Suite does not support passwords containing special characters or multibyte characters.

 

Reference Document : R12: How to change passwords to include special characters using FNDCPASS? (Doc ID 1336479.1)

 

 

 

 

Related Posts
Write a comment