Every worksheet will be created with an ‘Upload Result’, and ‘Line Message’, ‘Lot or Element Message’ and/or ‘Serial Number Message’ columns.
The ‘Upload Result’ is used to record the overall status for each transaction line. The ‘Upload Result’ may be:
Status
Status Explanation
Blank
Prior to running the validate/upload process.
Pending
If you are processing in the ‘background’ and choose to ‘refresh’ your transactions, and the transactions have not been processed by the Transaction Manager, then the transaction line will be updated to ‘Pending’.
Validated
All the information for this transaction is validated but not loaded into the Oracle interface table.
Accepted
All the information for this transaction has loaded successfully into Oracle Inventory. You will also notice that the transaction ID changes – this is because Oracle allocates a new transaction number to the transaction. The Wizard relies on the transaction ID in the transaction messages column as the key to deleting the transaction.
Error
All the information for this transaction has not been successfully loaded into Oracle Inventory. Your lines will receive an Error status if the line, lot or serial number fails. If there is no ID number in the message, then the data has not been inserted into the interface table and the error has been picked up by the Wizard.
Deleted
All the information for this transaction has been deleted from the interface table.
Warning
The information for this transaction was not processed.
The ‘Line Message’, ‘Lot or Element Message’ and ‘Serial Number Message’ is used to record any warning or error messages resulting from the validate/upload process e.g. ‘Subinventory Code is invalid, or item is not valid for this subinventory’.
In the following example, one transaction was rejected with the message in the ‘Header Message’ column of ‘[Inventory Org Code] This is a required field. A value must be entered’.
All other transactions were successfully processed.
