Month: May 2023
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:
- Cause: change password failed due to ORA-01403: no data found.
- Syntax error: unexpected end of file.
- Syntax error near unexpected token `newline’.
- APP-FND-02704: Unable to alter user APPS to change password.
- APP-FND-01564: ORACLE error 1017 in AFPCOA.
- FNDCPASS was unable to decrypt the password for user ‘APPS’ during applsys password change.
- Passwords must be at least 5 characters long. (This error may occur even when the password is longer than 5 characters.)
- It may not be possible to access the schema or change the password if the stored value is unknown.
- 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)