During an upload, messages are displayed in a Processing form. The data is still validated and errors are handled as per the form validation. Any invalid rows will not be uploaded.
All worksheets will be created with a ‘Status’ and ‘Message’ column for each section.
Status
There is a ‘Status’ column for each section and this is used to record the progress of the record in each section. These are found at the beginning of the worksheet to enable the user to determine if any issues have been found. If an issue is found, double-click on the status to go to the appropriate section in the workbook.
The Status may be:
Status
Status Explanation
Blank
Prior to running the validate/upload process where the status columns have been cleared or the record has been entered manually through the forms.
Pending
All the information for this line is uploaded to the AW interface table ready for importing into Oracle.
Accepted
All the information for this transaction has been successfully loaded into Oracle Assets.
Validated
All the information for this transaction has successfully passed the spreadsheet validation with no errors (but has not been loaded into Oracle).
Error
All the information for this transaction has not been successfully loaded into Oracle Assets.
Deleted
The information for this transaction has been deleted from the interface table.
Message
There is a ‘Message’ column for each section and this is used to record any issues with the record for each of the section(s). The ‘Messages’ column is held at the beginning of each section and will be ‘blank’ if no errors were found.
To navigate to the error message double-click on the associated status with the error. This will take you to the error message held at the beginning of the appropriate section.
Example - In the following example the Book Action is missing from the sheet.
If you have removed or renamed a compulsory column you will be informed.
