2 Replies Latest reply on May 17, 2017 4:07 PM by BhaskarKoniki

    Purge Obsolete Workflow Runtime Data

    Shaik

      Hi All

       

      EBS R12.1.3

      DB 11.2.0.3

      OS HP Unix 11.31

       

      I have run the program Purge Obsolete Workflow Runtime Data with below parameters

       

      What type of data will purge by this program?

       

      Is notification status Open Sent will puge by this program when we given  Age as 0?

      Is notification status Open Closed will purge by this program when we given Age as 0?

       

       

      Regards

      Shaik

        • 1. Re: Purge Obsolete Workflow Runtime Data
          mdtaylor

          Shaik,

           

          This program primarily purge core workflow tables like wf_item_activity_statuses.  You will need to query your own workflow tables to determine if the rows present are mostly temporary or permanent persistence types.  Personally, I prefer to purge both temporary and permanent workflows after 45 or 60 days, giving us most of the month to review previous month's AP/OM/PO workflows for issues.

           

          Quick Reference: How To Purge Obsolete Workflow Runtime Data For Applications (Doc ID 264191.1)

          Performance Issues Caused by Purge Obsolete Workflow Runtime Data Not Purging Everything (Doc ID 148678.1)

          How To Diagnose Issues Related To Purge Of Purchasing Workflow Data That Remain Even After Running The 'Purge Obsolete Workflow Runtime Data' Concurrent Program? (Doc ID 458886.1)

          Purge Obsolete Workflow Runtime Data Concurrent Request (FNDWFPR) Is Not Purging Data (Doc ID 752383.1)

           

          Regards,

          Michael

          1 person found this helpful
          • 2. Re: Purge Obsolete Workflow Runtime Data
            BhaskarKoniki

            It will purge the workflows ( including notifications ) with status in COMPLETED or CANCELED