•Spreadsheet Validation - Wizard data is validated against your Oracle instance list of values, date formats, field lengths and other necessary field level validation. Additional controls exist in the Wizard for data integrity purposes to help the user load valid data, with less chance of the Oracle Import rejecting it.
•Upload Validation - The upload process will perform the spreadsheet validation above as well as return any errors when inserting into the interface tables.
Data keyed directly into the worksheet (not via the Item forms) will be validated when it is uploaded. If you wish to check anything before it is uploaded, simply open the form. Alternatively you can run the upload process in ‘Validate only’ mode.
