1832186 - Error Message "Academic Title XYZ is not Available" While Uploading Contacts Using MS Excel

SAP Knowledge Base Article - Public

1832186 - Error Message "Academic Title XYZ is not Available" While Uploading Contacts Using MS Excel

Symptom

When you try upload Contacts using MS Excel, system throw below error message:

Academic Title XYZ is not Available

or

The 'AcademicTitleCode' element is invalid. The value XYZ is invalid according to its datatype. The actual length is greater than the MaxLength value

Reproducing the Issue

  1. Go to Account Management work center.
  2. Select Contacts view.
  3. Select New button and choose Contacts from Microsoft Excel®.
  4. Enter the details and upload using SAP Excel Add-in

Cause

The cause for the exception or above error messages while uploading the Contacts through MS Excel is that, for the Columns Title or Academic Title, the values are provided on your own instead of choosing it from the drop down.

Resolution

To resolve the issue, there are two possible options:

1. Select the values from the drop down for these two fields.

Example 1: When you select the drop down for Title, you can find 2 options 0002 - Mr. and 0001 - Ms.. These two are the valid options.
Example 2: When you select the drop down for Academic Title, you can field 6 options 0003 - Prof. Dr., 0006 - Ph.D., 0004 - B.A., 0002 - Prof., 0001 - Dr. and 0005 - MBA. These six are the valid options.

or

2. You can create new values for these fields in the system and then the values can be selected in the excel for the Contacts and the excel can be uploaded into your system.

The steps are,

a. Go to Business Configuration work center.
b. Go to Implementation Projects view or Overview view.
c. Search and Open the activity General Business Partners.
d. Select Maintain Academic Titles link, where you can add new Academic Titles.
e. Select Maintain Titles link, where you can add new Titles.
f. Now, export the excel for Contacts and maintain the data.
g. Upload the excel (Save Data To) into the system.

Keywords

KBA , AP-BP-BPT , Business Partner Template , How To

Product

SAP BUSINESS BYDESIGN 1611 ; SAP BUSINESS BYDESIGN 1705 ; SAP Business ByDesign 1308 ; SAP Business ByDesign 1311 ; SAP Business ByDesign 1402 ; SAP Business ByDesign 1405 ; SAP Business ByDesign 1408 ; SAP Business ByDesign 1411 ; SAP Business ByDesign 1502 ; SAP Business ByDesign 1505 ; SAP Business ByDesign 1508 ; SAP Business ByDesign 1511 ; SAP Business ByDesign 1602 ; SAP Business ByDesign 1605 ; SAP Business ByDesign 1608 ; SAP Business ByDesign 1702