1 Reply Latest reply on Mar 25, 2016 12:39 PM by Bashar.

    How to setup EBS reporting DB with all data since inception and keep only 2 years EBS Data in Production

    Safi Qadri

      Hi there,


      We have Oracle EBS R12 and Database 11g (


      We are looking to split EBS reporting as follows:

      1. Oracle Production EBS Database should only have last 2 years data

      2. Oracle Reporting EBS Database should have all data since inception including what we have in current Production (as mentioned in Step 1 above)


      Using ADG, we can offload reporting to other database server. However, we can not keep history of all data once it is truncated to last 2 years in Production as it will also be deleted from ADG.


      Looking for practical suggestions to achieve this?