Table of Contents

Search

  1. Preface
  2. Start Here
  3. Financial Management
  4. Human Capital Management
  5. CRM
  6. Logistics and Discrete Manufacturing
  7. Process Manufacturing
  8. Trade Management
  9. Order Management
  10. Payroll
  11. Projects
  12. Workflow (FND)
  13. Business Intelligence

Oracle E-Business Suite Accelerator Reference

Oracle E-Business Suite Accelerator Reference

PO Purchasing

PO Purchasing

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.

0 COMMENTS

We’d like to hear from you!