Correcting Errors and Reloading
Correcting Rejected Data
If you have an Error status in any of the status columns, you need to read the appropriate ‘Message’ column value and investigate and correct the data. The error messages relate to data on the same row in the relevant section.
To correct the information either key directly into the worksheet, or open the PO Receiving Form to select from existing lists of values.
Once the data has been corrected, remove any status columns data, and choose to either upload one row, selected range of rows or the entire worksheet.
Note - Transactions that already have an Upload Status of Accepted will not be processed again.
Error on Line when Concurrent Program Submitted
After the concurrent program is submitted, you may encounter a situation where the header is Accepted but one, or more lines are Error. To process lines which have an error complete the following steps:
1. Correct the data by referring to the upload message(s)
2. Remove the ‘Upload Status’ for the header transaction. If you do not do this then the Wizard will not process the transaction(s).
3. Upload the data. Refer to the Upload Transactions section of this document for detailed instructions. PO Receiving Wizard will ignore the lines with an upload status of Accepted.
After reloading the line(s) you will notice that the ‘Upload Status’ for the header will appear as Validated as this does not require reloading into Oracle.
Deleting Transactions in the Interface Table
If for any reason you want to update a transaction in the interface table, there is functionality provided to do so. An update facility is not available for the interface table, but a delete and insert facility is available.
You can delete a line or even an entire Process Set from the interface table. The data can then be changed and re-uploaded if required:
1. Place the cursor on any column (including the Upload Results columns) on the Line (or multiple lines) you wish to delete from the interface table.
2. Click on the ‘Delete from interface’ icon on the PO Receiving Wizard ribbon.
The transactions will now appear with a status of Deleted.
3. You can now change the data for that transaction and reload the data into the interface table. PO Receiving Wizard will ignore the lines with an Upload Status of Accepted.
Any transaction with an Upload Status of Accepted cannot be deleted.
