· Spreadsheet Validation - The Data Entry Form validates the data on the selected row using the lists of values, date formats, field lengths and 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.
Note: If the error ‘'API Error: Row <number> has been rejected by Oracle. Due to Oracle limitations, the specified row cannot be identified and no error message has been provided by Oracle.” is encountered. This infers that there is a data error that is not handled by Oracle’s validation. Please review your sheet data. For example, in this case the percent amount for the Header Freight distribution was not entered.
