Every worksheet will be created with an ‘Upload Result’ and ‘Item Cost Message’ column.
The ‘Upload Result’ is used to record the overall status for each record to be uploaded. The ‘Upload Result’ may be:
Status
Status Explanation
Blank
Prior to running the validate/upload process.
Validated
All the information for this item cost has passed validation but not loaded into the interface table.
Pending
All the information for this item cost is loaded to the interface table ready for importing into Oracle Inventory.
Warning
All the information has been uploaded into Oracle Inventory and produced a warning message in the ‘Item Cost Message’ column for the user’s information.
Unknown
The Wizard has checked the interface and cannot find a matching record. It also has attempted to match the cost details to the cost details within Oracle and still cannot find a match for the data. If you get this status, then reload the data from the Wizard again.
Accepted
All the information for this item cost has been successfully loaded into Oracle Inventory.
Error
All the information for this invoice has not been successfully loaded. Please note that if any of the sub elements fail validation the whole row will error and not be loaded.
Deleted
All the information for this record has been deleted from the interface table. Note – if you wish to update a transaction in the interface table first delete it then reload it.
The ‘Item Cost Message’ is used to record any warning or error messages resulting from the validate/upload process e.g. ‘The item you have selected is already costed for this cost type’.
In the following example, one item cost was rejected with the message Invalid Value. All other item costs were successfully processed.
