How to delete Old Invoices from AP_INVOICES_ALL which are no more required by organization?

You can purge invoices, provided following conditions should match:

If you are purging invoices, the Purge program purges related invoice distributions, invoice approvals, and invoice batches. You can purge invoices that meet the following criteria:

- Last Update Dates of the invoice and its distributions, and the Invoice Date, is less than or equal to the Last Activity Date.

- Invoice is fully paid or is a zero–amount invoice.

- Invoice is fully posted.

- Invoice does not have any 1099 distributions, and is not for a 1099 supplier.

- Invoice was not generated by a recurring invoice template.

- Invoice is not a prepayment, and no prepayments have been applied to the invoice.

- All of the invoice’s payments meet the Payment Purge Criteria.

- No open encumbrances are associated with the invoice.

- Invoice is not Oracle Projects related.

- All purchase orders referencing the invoice meet the Purchase Order Purge Criteria (this condition applies only when you
choose Matched Invoices and POs for the purge category).

- If Oracle Assets is installed, all of the invoice’s distributions were tested by Mass Additions.

Notes:

If we have few invoices pending from a long which are not paid, and the Suppliers are vanished from Market from 5 years.
They will never be paid, Can we Purge them also.
Or do you advice back end delete for those invoices!

Avoid deleting the invoices.

- Create a credit memo from the supplier.

- Apply it to this invoice.

That will close it. 

Have a Oracle Question
Do you have an Oracle Question?

Oracle Books
Oracle Certification, Database Administration, SQL, Application, Programming Reference Books

Oracle Application
Oracle Application Hints and Tips

Oracle Home
Oracle Database, SQL, Application, Programming Tips