What is the correct order for purging AP/PO data in Oracle E-Business Suite?
Using: Oracle Applications : 12.2.12 RDBMS : 19.0.0.0.0 EBS
Got a big data retension/deletion project coming up.
Question: What is the correct order for purging AP/PO data in Oracle E-Business Suite? I would imagine it is as follows
- Purge Requisitions
- Purge Purchase Orders (POs)
- Purge Receipts
- Purge Invoices
- Purge Payments
This sequence ensures that you start with requisitions, move through purchase orders, receipts, invoices, and finally payments. However, one could argue that one should go via the reverse sequence...Any views? Anybody with experience of this? What about associated things like categories, attachments etc? I'm also assuming that the standard oracle AP/PO data purge process will not allow one to purge anything that has dependencies right? Thanks