7 Replies Latest reply on Mar 21, 2009 12:43 PM by Hussein Sawwan-Oracle

    How to view/list all concurrent request output

    649606
      Hi,

      How do I view all the concurrent request jobs?


      Thanks a lot
        • 1. Re: How to view/list all concurrent request output
          Hussein Sawwan-Oracle
          Hi,

          From the application, login to System Administrator responsibility and navigate to Requests > View.

          From the database, query FND_CONCURRENT_REQUESTS table.

          Note: 462063.1 - What Tables Store Concurrent Program Details?
          https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=462063.1

          Regards,
          Hussein
          1 person found this helpful
          • 2. Re: How to view/list all concurrent request output
            649606
            Thanks Hussein...but the >System Administrator responsibility and navigate to Requests > View.
            Only allow to view per user :( i want all users in the list.

            Or I need to select it on the database as the only option. :)
            • 3. Re: How to view/list all concurrent request output
              Hussein Sawwan-Oracle
              Hi,

              You need to set "Concurrent:Report Access Level" profile option.

              Review the following note for more details.

              Note: 1014007.102 - How can SYSADMIN View Other Users Reports?
              https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=1014007.102

              For R12, UMX Role Based Access Control (RBAC) controls who can view request output files, and this profile option is no longer used.

              Note: 736547.1 - Concurrent Report Access Level
              https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=736547.1

              Note: 563946.1 - How To See Log And Output Files Of Requests Ran By Other Users Using Same Resp In R12
              https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=563946.1

              Search Metalink for this profile option, you will find many hits.

              Regards,
              Hussein
              1 person found this helpful
              • 4. Re: How to view/list all concurrent request output
                649606
                Thanks again,

                I selected/counted the fnd_concurrent_requests table in apps/apps
                SQL> select count(*) from fnd_concurrent_requests;
                
                  COUNT(*)
                ----------
                       489
                I want to delete all the concurrent request output and logs(at the application menu level) such that when
                i run again the count, I will get zero (0).
                SQL> select count(*) from fnd_concurrent_requests;
                
                  COUNT(*)
                ----------
                         0
                How do I carry it out on the apps menu?

                Thanks a lot
                • 5. Re: How to view/list all concurrent request output
                  Hussein Sawwan-Oracle
                  Hi,

                  You need to run "Purge Concurrent Request and/or Manager Data" concurrent program. The "Count" parameter indicates the number of (most recent) records for which you want to save concurrent request history, log file, and report output files.

                  System Administrator's Guide, Page 2-43 (Purge Concurrent Request and/or Manager Data Program).

                  Oracle Applications System Administrator's Guide - Maintenance
                  http://download-uk.oracle.com/docs/cd/B25516_14/current/acrobat/115samg.pdf

                  Regards,
                  Hussein
                  1 person found this helpful
                  • 6. Re: How to view/list all concurrent request output
                    649606
                    Thanks hussein, so i will put "0" so that nothing is left remaining...
                    • 7. Re: How to view/list all concurrent request output
                      Hussein Sawwan-Oracle
                      Hi,

                      For the Mode Value parameter, valid values are 1 - 9999999.

                      Note: 104282.1 - Concurrent Processing Tables and Purge Concurrent Request and/or Manager Data Program (FNDCPPUR)
                      https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=104282.1

                      Regards,
                      Hussein