Status and Message Columns
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.
Refer to section: