Error messages and warnings

A warning or error message might be displayed in the user interface to provide information about the adapter or when an error occurs.

The table lists the error messages and warnings that might occur while performing the user account or group management tasks, where applicable.It also includes the corrective actions to resolve the errors.

Table 1. Adapter error messages, warnings, and recommended actions
Error message Recommended action
CTGIMT001E: The following error occurred. Error: Either the Oracle EBS service name is incorrect or the service is not up. Ensure that:
  • The value of the Oracle EBS Service Name attribute on the Oracle eBS service form is correctly specified.
  • The Oracle eBS service is running.
CTGIMT001E: The following error occurred. Error: Either the Oracle EBS host or port is incorrect. Ensure that values of the Oracle EBS Service Host and the Oracle EBS Service Port attributes on the Oracle eBS service form are correctly specified.
CTGIMT002E: The login credential is missing or incorrect. Ensure that the login credentials that are specified in the Oracle eBS service form are correct.
CTGIMT001E: The following error occurred. Error: No suitable JDBC driver found. Ensure that:
  • The appropriate version of the JDBC driver is copied to the workstation where the Oracle eBS Adapter is installed.
  • The path is included in the CLASSPATH environment variable.
CTGIMT600E: An error occurred while establishing communication with the IBM Security Directory Integrator server. IBM® Security Identity Manager could not establish a connection with Security Directory Integrator. To fix this error, ensure that:
  • Security Directory Integrator is running.
  • The URL specified for the Security Directory Integrator location attribute on the Oracle eBS service form is correct.
CTGIMT007E: A system error occurred while adding an account. The account is not added. ERROR: java.sql.SQLException: ORA-20001: APP-FND-02600: Unable to create user username due to the following reason(s):No password provided for user user name when calling FND_WEB_SEC.VALIDATE_PASSWORD to create a new user. Ensure that a password is provided when creating a user account.
CTGIMT007E: A system error occurred while adding an account. The account is not added. ERROR: java.sql.SQLException: ORA-20001: APP-FND-02600: Unable to create user username due to the following reason(s): This user name is already in use. Please enter a unique user name. A user account with the specified user ID exists on the Oracle eBS. Create a user account with another user ID.
CTGIMT007E: A system error occurred while adding an account. The account is not added. ERROR: java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small. This error occurs either when you specify a non-permissible data type value for an attribute or the value of the attribute exceeds the permissible character limit.

For example, this error occurs if you specify an alphanumeric value for the Password Lifespan (in days) attribute or if you specify a value for the Description attribute that exceeds 240 characters.

To fix this error, ensure that:
  • You specify a valid data type value for an attribute.
  • The value of the attribute does not exceed the permissible character limit.
CTGIMT007E: A system error occurred while adding an account. The account is not added. ERROR: java.sql.SQLException: ORA-20001: The following invalid characters are not allowed inside username: Invalid characters are: " ( ) * + , ; < > \ ~ / Specify a value for the User ID attribute that excludes the non-permissible characters that are listed in the error message.
CTGIMT007E: A system error occurred while adding an account. The account is not added.ERROR: java.sql.SQLException: ORA-20001: APP-FND-02600: Unable to create user username due to the following reason(s): Passwords must be at least 5 characters long. Ensure that your password adheres to the password policy that is described on the Oracle eBS.
CTGIMT008W: The account was added, but some attributes failed.Attributes: erOraEBSDescription

The log file describes this error message as: java.sql.SQLException: ORA-20001: APP-FND-02601: User user name is not a valid user.

Ensure that the value of the Description attribute does not exceed the permissible character limit. For example, in the Oracle eBS 11i, the Description attribute value has a limit of 240 characters.
CTGIMT008W: The account was added, but some attributes failed.Attributes: erOraEBSUserFax

The log file describes the error message as:java.sql.SQLException: ORA-20001: APP-FND-02601: User user name is not a valid user.

Ensure that the value of the Fax attribute does not exceed the permissible character limit. For example, in the Oracle eBS 11i, the Fax attribute value has a limit of 80 characters.
CTGIMT008W: The account was added, but some attributes failed.Attributes: erOraEBSCust

The log file describes the error message as follows:java.sql.SQLException: ORA-20001: APP-FND-02913: User user name: The Customer is linked to Customer customer name (Customer ID). The Person is linked to Employee employee name (Employee ID). Customer and Employee must be linked to the same person.

This error occurs when you specify different values for the Person and the Customer attributes. Ensure that values of both the attributes are same.
CTGIMT008W The account was added, but some attributes failed.

ERROR: java.sql.SQLException: ORA-01861: literal does not match format string

Ensure that a value specified to this attribute matches the data format of the securing attribute.
CTGIMT008W The account was added, but some attributes failed.

ERROR: java.sql.SQLException: ORA-01843: not a valid month

Ensure that a value specified to this attribute matches the data format of the securing attribute.
CTGIMT008W The account was added, but some attributes failed.

ERROR: java.sql.SQLException: ORA-06550: PLS-00103: Encountered the symbol "x" when expecting one of the following: ) , * & | = - + < / > at in is mod not rem => .. <an exponent (**)> <> or != or ~= >= <= <> and or like between || The symbol "," was substituted for "x" to continue.

Ensure that a value specified to this attribute matches the data format of the securing attribute.
CTGIMT008W The account was added, but some attributes failed.

ERROR: java.sql.SQLException: ORA-01858: a non-numeric character was found where a numeric was expected

Ensure that a value specified to this attribute matches the data format of the securing attribute.
CTGIMT013E: The account was added, but some attributes failed.
Attributes:
  • erOraEBSLeftPwdAccess
  • erOraEBSPwdAccesses
  • erOraEBSSessionNumber
  • Available password
This error occurs when you specify a non-permissible data type value for an attribute.

When you add or modify a user account, ensure that you specify numeric values for the attributes that are listed in the error message.

CTGIMT013E: A system error occurred while modifying the account. The account is not modified. Error: None of the attribute were set, See Adapter log. Ensure that the user account exists on the Oracle eBS.
CTGIMT013E: A system error occurred while modifying the account. The account is not modified. Error: None of the attribute were set, See Adapter log.

The log file describes this error message as:Error in updating attribute erOraEBSUserStartDate : Can not clear start Date.

Ensure that a value is specified for the User Start Date attribute. The value of this attribute cannot be empty.
CTGIMT013E A system error occurred while modifying the account. Ensure that the user name is not in use and that it does not exceed the limit for the number of characters.
CTGIMT014W: The account was modified, but some attributes failed. erUid Error: See Adapter log for detailed error. Ensure that the user name is not in use and that it does not exceed the limit for the number of characters.
CTGIMT024E: The account was not suspended: ERROR: java.sql.SQLException: ORA-20001: APP-FND-02601: User user name is not a valid user. Ensure that the user account exists on the Oracle eBS.
CTGIMT026E: The account was not restored: ERROR: java.sql.SQLException: ORA-20001: APP-FND-02601: User user name is not a valid user. Ensure that the user account exists on the Oracle eBS.
CTGIMT215E: The account was not deleted due to a system error: Delete Operations not supported. The Oracle eBS Adapter does not support the delete operation.