2 Replies Latest reply: Nov 5, 2012 2:55 AM by Nitesh Sharma RSS

    How to save automatically scheduled Discoverer workbook as a file?

    user410510
      Hi,







      When I run a Discoverer report I have the option to export as a file in various formats (PDF, TXT, Excel).



      I’ve scheduled a workbook in discoverer and I want it not only to be saved in the Discoverer itself, I also want it to be saved as a file (PDF, TXT, Excel) when it finished running.



      Can someone please explain how can it be done?


      Another issue:

      Is it possible to use other kinds of triggers to run the report beside a schedule?
      Meaning – I want the report to run immediately when payroll (trigger exists in DB) finished running.





      Thanks!







      Rafi
        • 1. Re: How to save automatically scheduled Discoverer workbook as a file?
          Rod West
          Hi,
          Can someone please explain how can it be done?
          You cannot save Discoverer scheduled into a file automatically.
          Is it possible to use other kinds of triggers to run the report beside a schedule?
          If you want to automatically generate Discoverer reports in files then you should consider using a third party scheduler such as windows task manager to automatically generate reports using Disco Desktop.

          We run Discoverer workbooks through the EBS concurrent manager, so that, for example, you can schedule a workbook as part of a payroll request set. You can look at this [url http://ascbi.com/downloads/Third%20Party%20Documents/Scheduling%20through%20Concurrent%20Manager.pdf]article for ideas on how to do this.

          Rod West
          • 2. Re: How to save automatically scheduled Discoverer workbook as a file?
            Nitesh Sharma
            Hi,

            I had the same requirement and i achieved it by the combination of Descoverer Scheduled report and oracle concurrent program. In a brief the process goes like this:

            1.) Create and schedule the discoverer Report on periodic basis. For example every hour starting from morning 9:00 AM.
            2.) As soon as schedule report start running at 9:00 AM, it will create a table in DB to store the output of the execution.
            3.) Create a query to fetch the last executed report output.
            4.) Get the table name created for the last executed output.
            5.) Create the oracle apps concurrent program to perform step 3 & 4 dynamically.
            6.) Also, write the code in the concurrent program to Generate Excel/Text/CSV/PDF file by selecting values from the last created table.
            7.) Schedule the concurrent program at the time which is the possible/approximate end time of discoverer report execution. For example, if your report take 15 mins to complete, then schedule your program at 9:20 (giving some buffer time just in case).

            Now, your discoverer report is scheduled every hour and take 15 mins to complete. And your concurrent program is also schduled to fetch last executed data and create file (and possible Email/FTP them) form the output.

            Hope this helps. Do feel free to revert in case you require queries that i have used to perform above mentioned steps.

            regards
            Nitesh