Data Archive handles Purchase Orders and its requisitions and receipts in two entities, Simple Purchase Orders and Matched Purchase Orders. A third entity, Requisitions, handles simple requisitions. A simple PO is a PO that is not matched to an invoice. A matched PO is a PO that has been matched to an invoice. The business logic for purging a simple PO and a matched PO is exactly the same. The only difference is that the Matched PO entity enforces the transaction chain links between AP and PO. To purge a matched PO, all invoices matched to that PO must be purgeable.
Requisitions are handled in all three PO entities. A simple requisition is a requisition that does not reference a PO. All requisitions that do reference a PO are processed in Simple POs and Matched POs or Invoices.
In versions R12.2 and later, delete the table "PO_NOTES" from all three of the Purchase Orders entities before you run the retirement job. Delete the table from both the
Insert Default Steps
tab and the
List of Tables
tab in the Enterprise Data Manager. If you do not delete the PO_NOTES table from the PO entities, you receive a "table not found" error when you run the archive or retirement job, because the table does not exist in versions R12.2 and later.