Correcting Errors and Reloading
Correcting Rejected Data
You cannot update interfaced records; however you can delete the records and then reload them.
If you have an Error status in the ‘Upload Results’ column, you need to read the message in the ‘Item Cost Message’ column and investigate 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 ‘Item Cost Header’ form or the ‘Item Cost Elements’ form.
Once the data has been corrected you can choose to either upload one row, selected rows or the entire worksheet.
Item costs that have an existing upload Status of Accepted will not be processed again.
Continuing the previous example after correcting the data and re-running the complete upload process will show all records will be successfully transferred into Oracle Inventory.
Deleting and Updating Item Costs in the Interface Table
You can delete an item cost or all item costs from the interface table. The items are deleted from the interface tables only. The data can then be changed and reloaded if required.
Deleting and Updating a Single Item Cost
Place the cursor on any column on the row that contains the item cost you wish to delete. Click the ‘Delete selected costs’ icon.
You can now change the data for that record and reload the item cost. Only your changed item costs will be uploaded, with a new ID.
Deleting and Updating a Range of Item Costs
You cannot update interfaced records however you can delete the records and then reload them.
Note - You cannot upload line items where the item already exists in the interface table, even if that line has an Error status. This is a constraint of Oracles interface functionality. We recommend you delete lines with errors from the interface table first before reloading the same item again.
Highlight the rows of records you wish to delete. Click the ‘Delete selected costs’ icon.
You can now change the data for that record and reload the item cost. Only your changed item costs will be uploaded, with a new ID.
Deleting all Item Costs from the Interface Table
Place the cursor on any row below row 9 and click on the ‘Delete all costs’ icon.
You will be prompted to confirm.
You can now change the data for these item costs, so long as you have not altered the ‘Group ID’ and ‘Item Cost Interface ID’ columns.
Item Cost Wizard will ignore any other lines already marked Accepted. Your changed item costs will be uploaded, with a new ID.
Refer to section:
