Import Template File is Not Recognizing the Display Name Warning: "The following columns in your import file have not been mapped to the target attribute" Error: "The following table has validation errors. Review the data formats" (Doc ID 2902408.1)

Last updated on NOVEMBER 25, 2022

Applies to:

Symptoms

On : 11.13.22.04.0 version, Import

ISSUE
---------------
The Import template is not recognizing Display name on column headers.

User is getting a warning about unmapped columns when validating data during import.
The warning is on the column headers which have different values for the 'Display Name' Attribute name and Attribute Display name

ERROR
-----------------------

Data Format Errors

The following table has validation errors. Review the data formats

WARNING
----------------------
Unmapped Columns

The following columns in your import file have not been mapped to the target attribute



STEPS
-----------------------
The issue can be reproduced at will with the following steps:


1. Export open subscriptions from source Oracle instance using Export management functionality.

2. Use the CSV was generated with column headers as “Display Names” of the attributes.

3. Import this file using Import management functionality

4. Set up the mapping as Automatic Mapping in the import setting.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.