Procurement - EBS (MOSC)

MOSC Banner

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

  1. Purge Requisitions
  2. Purge Purchase Orders (POs)
  3. Purge Receipts
  4. Purge Invoices
  5. 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center