Skip Navigation
Masking error displayed within Data Import Wizard
Answer ID 12241   |   Last Review Date 05/18/2022

Why does the Data Import Wizard display an error stating a field value "does not conform to the mask for the field"?


Data Import Wizard, Custom Input Masking
Oracle B2C Service, All versions


I am completing a data import and one of the columns in my CSV file is a field which has an input mask defined.  Even though the data in the CSV matches the mask, the import states the data does not conform to the mask.   


If the input mask for the field contains Fixed, formatted characters the CSV data should not include those characters.  

For example, if the mask for a custom field is defined as F$M#M#F.M#M# in order to store dollar amounts in the format of $12.34, this error will occur if the CSV contains the data '$12.34'.  The error can be avoided by editing the CSV data to contain the value '1234'.