9 Replies Latest reply: Nov 3, 2011 2:45 PM by Hussein Sawwan-Oracle RSS

    concurrent programs

    609621
      12.0.4 on Solaris 10

      Is it mandatory to schedule the below concurrent programs after live ?

      Workflow Background Process
      Purge Concurrent Request and/or Manager Data
      Purge Logs and Closed System Alerts
      Purge Concurrent Request and/or Manager Data
      Synchronize WF LOCAL tables
      Workflow Work Items Statistics Concurrent Program
      Workflow Agent Activity Statistics Concurrent Program
      Workflow Mailer Statistics Concurrent Program
      Purge Obsolete Workflow Runtime Data
      Purge Signon Audit data
      Workflow Control Queue Cleanup
      Synchronize Workflow LOCAL tables (Report Set)
      Remove obsolete sessions from fnd_sessions

      Kai
        • 1. Re: concurrent programs
          Srini Chavali-Oracle
          All are mandatory except

          Synchronize WF LOCAL tables
          Synchronize Workflow LOCAL tables (Report Set)

          These only need to be run upon the recommendation of Support.

          HTH
          Srini
          • 2. Re: concurrent programs
            609621
            Thanks Srini.

            Do we need to defragment any table after the completion of purging concurrent programs

            Kai
            • 3. Re: concurrent programs
              Srini Chavali-Oracle
              Defragmentation is typically not necessary - it may be required in some extreme cases if you are seeing extreme performance issues.

              HTH
              Srini
              • 4. Re: concurrent programs
                Hussein Sawwan-Oracle
                Kai,
                Is it mandatory to schedule the below concurrent programs after live ?
                I would say yes for all programs -- See (How to Optimize the Purge Process in a High Transaction Applications Environment [ID 311552.1]) for details.

                Thanks,
                Hussein
                • 5. Re: concurrent programs
                  Hussein Sawwan-Oracle
                  Do we need to defragment any table after the completion of purging concurrent programs
                  Yes, some tables need defragmentation after purging.

                  Concurrent Processing - Best Practices for Performance for Concurrent Managers in E-Business Suite [ID 1057802.1]
                  Performance Issue When Using the Autocreate Form to Create a Standard Purchase Order [ID 1109873.1]

                  Thanks,
                  Hussein
                  • 6. Re: concurrent programs
                    Srini Chavali-Oracle
                    AFAIK, "Synchronize Workflow LOCAL tables (Report Set)" is obsolete in 12.0.3 and above - pl see MOS Doc 858003.1 (How To Stop The FNDRSSUB "Synchronize Workflow LOCAL Tables" Request?).

                    Srini
                    • 7. Re: concurrent programs
                      Hussein Sawwan-Oracle
                      You mentioned before "These only need to be run upon the recommendation of Support" and now you have mentioned "is obsolete" :)

                      Anyway, please see these docs -- I believe "Synchronize WF LOCAL tables" can still be used (but not the Request Set).

                      Diagnosing database invalidation issues with Java Cache for eBusiness Suite [ID 455194.1]
                      How To Update The Email Address For Employees And Keep In Synchronization With The Wf_Local_Roles Table ? [ID 1319528.1]
                      After Upgrading to EBS 11i RUP6 or EBS R12 with a 10g / 11g RDBMS, "Switch Responsibility" (Top Hat) Takes Much Longer In Forms [ID 745701.1]
                      Synchronize WF LOCAL Tables (FNDWFLSC) Program Error With ORA-12801 ORA-01452 [ID 783073.1]
                      Receive java.lang.nullpointerexception when accessing Internet Expenses responsibility [ID 1065055.1]

                      Thanks,
                      Hussein
                      • 8. Re: concurrent programs
                        609621
                        Thanks a lot Hussein and Srini.

                        Do we have to schedule any other concurrent program considering purging and performance

                        Kai
                        • 9. Re: concurrent programs
                          Hussein Sawwan-Oracle
                          Kai,

                          In addition to the docs referenced above, please see these links.

                          https://forums.oracle.com/forums/search.jspa?threadID=&q=Purge+AND+Schedule+AND+Concurrent&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001
                          https://forums.oracle.com/forums/search.jspa?threadID=&q=Purge+AND+Strategy&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001

                          Thanks,
                          Hussein