Forum Stats

  • 3,874,184 Users
  • 2,266,680 Discussions


Purge Transactional Data on Cloned Instance

Trithankar Mittra
Trithankar Mittra Member Posts: 7 Blue Ribbon

We have a requirement to create a Clone/POC environment from PROD and purge all the Transactional data from it. The modules we heavily use are OM, Finance and SCM. We are talking about Oracle EBS (12.2.9) on latest AD/TXK patch levels and Database (19c). While it may be big effort to perform the purging, can anyone please provide any guidance on how should we approach this requirement. I've already read the reducing EBS Footprint note from Oracle but am looking at options , approaches that can be used.



  • AmitGargOCE
    AmitGargOCE Member Posts: 125 Blue Ribbon
    edited Sep 28, 2022 7:32AM

    There is no standard way of Perge all transaction data in EBS R12. You can use provided purge / archive programs to reduce data footprints as you already know: Reducing the Oracle E-Business Suite Data Footprint (Doc ID 752322.1)