Spreadsheet Validation - The Data Entry Form validates the data on the selected row using the lists of values, date formats, field lengths and some other field level validation.
Upload Validation - The upload process will perform the spreadsheet validation above as well as the validation within the Oracle API.
Data keyed directly into the worksheet (not via the Data Entry Form) will be validated when it is uploaded. If you wish to check anything before it is uploaded, simply open the form or click on the Validation icon to validate the records. If you have removed or renamed a compulsory column, you will not be able to upload the data.
