Every worksheet will be created with ‘Status’ columns. The ‘Status’ columns which appear on your worksheet are dependent on the template being used:
•Standard Purchase Order Status columns – Header, Line/Ship, Distribution, Header Attachment, Line Attachment.
•Blanket Purchase Agreement and Quotation status columns – Header, Line, Price Break, Header Attachment, Line Attachment.
•Change API status columns – Header, Line, Shipments.
Each Status may be:
Status
Status Explanation
Blank
Prior to running the validate/upload process.
Validated
The information for this transaction has successfully passed the spreadsheet validation (but has not been loaded into Oracle).
Pending
The information for this Purchase Order has been uploaded to the P.O. interface table ready for importing into Oracle Purchasing.
Accepted
The information for this Purchase Order has been successfully loaded into Oracle Purchasing.
Error
The information for this Purchase Order has not been successfully loaded into the interface table.
Rejected
The information for this Purchase Order has not been successfully loaded into Oracle Purchasing (Change API, PO Close and Cancel PO). Delete the record from the interface table, change the rejected data and reupload to the interface table.
Deleted
The information for this Purchase Order has been deleted from the interface table.
The ‘Error’ columns are used to record any warning or error messages resulting from the validate/upload process e.g. ‘Insufficient Ship Information’.
In the following example, one Purchase Order was rejected with the message ‘Unable to find a match for the value you entered’. All other Purchase Orders were successfully processed to the interface table.
