4 Replies Latest reply: Jul 20, 2012 11:09 PM by Ashish_Apps RSS

    How to save the output of a concurrent proram automatically

    Vimal
      Hi Friends,

      We have a requirement to save the output of a concurrent program to a specific folder for a reporting purpose. whenever we run that concurrent program it should save the out file in the network folder \\out_files\con_prg like that
      instead of storing it in its default folder in unix.(or I should recoganize which out file is for my concurrent program from the default folder and to move it to windows shared network folder). If it is one time , I can do it manually. But I need to schedule that concurrent program to run every day and transfer the output to the windows folder.

      Our system is Oracle Apps 11i , Data base 9i in Solaris.

      If you have any idea or sugesstion for this , please share it with me here.

      Thanks in advance,
      Vimal...
        • 1. Re: How to save the output of a concurrent proram automatically
          Hussein Sawwan-Oracle
          We have a requirement to save the output of a concurrent program to a specific folder for a reporting purpose. whenever we run that concurrent program it should save the out file in the network folder \\out_files\con_prg like that
          instead of storing it in its default folder in unix.(or I should recoganize which out file is for my concurrent program from the default folder and to move it to windows shared network folder). If it is one time , I can do it manually. But I need to schedule that concurrent program to run every day and transfer the output to the windows folder.

          Our system is Oracle Apps 11i , Data base 9i in Solaris.

          If you have any idea or sugesstion for this , please share it with me here.
          To copy the output files of the concurrent requests, you can simply read it from FND_CONCURRENT_REQUESTS table (OUTFILE_NAME column) and copy it from $APPLCSF/$APPLOUT directory to your destination directory.

          TABLE: APPLSYS.FND_CONCURRENT_REQUESTS
          http://etrm.oracle.com/pls/trm11510/etrm_pnav.show_object?c_name=FND_CONCURRENT_REQUESTS&c_owner=APPLSYS&c_type=TABLE

          Thanks,
          Hussein
          • 2. Re: How to save the output of a concurrent proram automatically
            Vimal
            Hi

            Thanks for the reply. I can get the name from the fnd_concurrent_requests table, But how can I identify which is the one submitted by me. Because there is possibility of multiple submission by the users with different parameters.
            I can give you more details.

            We are having a BI report (not oracle) for AR Aging Report details. It has a staging table to get the data from Oracle EBS.

            My job is to run Our Customized AR Aging Report with 2 different parameters like sysdate and the same date for last month.
            Get the output file and processs it (for this we are using VB Script) to populate the staging table from where the BI report get the data.
            So far I am doing this manually for more than a month.

            The Users wants to have all the above mentioned process to be combined as a single concurrent program , so that they can submit easily and populate the data any time of the day like other Oracle Standard reports.

            The BI report can be viewed any time of the day by more than 15 users and also AR Aging report can be run so many times in a day by another set of users.

            In this situation how can I get the exact output file of the request submitted by me.

            Thanks,
            Vimal...
            • 3. Re: How to save the output of a concurrent proram automatically
              Hussein Sawwan-Oracle
              Thanks for the reply. I can get the name from the fnd_concurrent_requests table, But how can I identify which is the one submitted by me. Because there is possibility of multiple submission by the users with different parameters.
              Join REQUESTED_BY in APPLSYS.FND_CONCURRENT_REQUESTS with USER_ID in APPLSYS.FND_USER table and get the user_name -- http://etrm.oracle.com/pls/et1211d9/etrm_pnav.show_object?c_name=FND_USER&c_owner=APPLSYS&c_type=TABLE

              Thanks,
              Hussein
              • 4. Re: How to save the output of a concurrent proram automatically
                Ashish_Apps
                since you want to copy the current report output you can very well get the data from fnd_global.conc_request_id

                I would suggest create a shell script which takes input as request id and copies the output file from $APPLCSF/$APPLOUT to target directory.

                Create a conc program from this shell script.

                CAll this concurrent program as a last step of you main program passing the current programs conc request_id

                something like
                ln_req_id := fnd_request.submit_request('XXC','XXCCOPYOUTPUT',fnd_global.conc_request_id);
                where XXC - Application short name of custom schema
                XXCCOPYOUTPUT - conc program short name( which will copy output to specific folder)

                Hope this helps