Every worksheet will be created with ‘Invoice Status’, ‘Validation Status’ and ‘Line Status’ columns.
The ‘Invoice Status’ is used to record the overall status for each invoice. The ‘Invoice Status’ may be:
Status
Status Explanation
Blank
Prior to running the validate/upload process.
Validated
All the information for this line has been successfully validated.
Pending
All the information for this invoice is uploaded to the AP interface table ready for importing into Oracle Payables.
Processed
All the information for this invoice has been successfully loaded into Oracle Payables.
Rejected
All the information for this invoice has not been successfully loaded into Oracle Payables.
Deleted
All the information for this invoice has been deleted from the interface table.
The ‘Validation Status’ column is used to record any warning or error messages resulting from the validate/upload process e.g. ‘Insufficient Receipt Information’.
Please note that when an invoice is uploaded into payables the Validation Status may say Never Validated. This means it has been validated by the upload process but the invoice needs to be validated in Oracle Payables via a concurrent program.
The ‘Line Status’ column is used to record the progress of the individual record for each distribution line of the invoice. The status may be:
Status
Status Explanation
Blank
Prior to running the validate/upload process.
Validated
All the information for this line has been successfully validated.
Pending
The information for this invoice distribution has been uploaded to the AP interface table ready for uploading to Oracle Payables.
Processed
The information for this invoice distribution has been successfully loaded into Oracle Payables.
Rejected
The information for this invoice distribution has not been successfully loaded into Oracle Payables.
Deleted
The information for this invoice distribution has been deleted from the interface table.
In the following example, one Invoice was rejected with the message ‘There is no Accounting for this Distribution’. All other Invoices were successfully processed.
