3 Replies Latest reply on Nov 19, 2016 10:45 AM by Beauty_and_dBest

    How to purge XLA_ACCOUNTING_ERRORS

    Beauty_and_dBest

      Hi ALL,

       

      EBS R12.1.3

       

      We have this big table which is  selected for dump to be given to Oracle Support.

      How can I purge it and retain the latest logs only?

       

      SQL> select count(*) from XLA_ACCOUNTING_ERRORS;

       

       

        COUNT(*)

      ----------

         1334911

       

       

      Please help...

       

      Kind regards,

      jc