1 Reply Latest reply on Jul 17, 2018 5:13 AM by Safi Qadri

    How to restore archive and purge the  shadow tables(Upgrading from 12.1.2 to 12.2.5)

    Safi Qadri



      According to below reference anybody tell me, How to restore back archive and purge the  shadow tables in Oracle EBS again after archive and purge the shadow tables.






      Disable AOL Audit Trail (conditional)

      If you use the Oracle Applications Object Library Audit Trail feature, then you must

      disable it before the upgrade.

      From the System Administrator responsibility under the R12.0 or 12.1 APPL_TOP,

      navigate to Security > Audit Trail > Groups. In the Audit Groups window, set the

      Group State field to Disable - Prepare for Archive for each audit group defined. Run

      the Audit Trail Update Tables report from the Submit Requests window (Requests >


      If you plan to re-enable auditing after the upgrade, then archive and purge the

      shadow tables now. Data changes made after implementing this step are not


      Note: See Audit Trail in Oracle E-Business Suite Security Guide.