6 Replies Latest reply: Sep 2, 2010 3:29 PM by rcintron100 RSS

    BURSTING - separate output file to individual

    rcintron100
      I have a report that generates a batch of documents, in one request each separated by one ID.
      How can I have this file split to have one document for each Page, instead of one document?

      The example below shows my XML Data Output and how it hold all the information together. I am looking to segragate the output for each <G_PP_NUMBER> to generate one .pdf file that will be sent to the <EMAIL_ADDRESS>
      <G_PP_NUMBER>
      <PP_NUMBER>PP100</PP_NUMBER>
      - <LIST_G_INVOICE>
      - <G_INVOICE>
      <INVOICE_CONTACT>M PALMER</INVOICE_CONTACT>
      <LINE_NUMBER>1</LINE_NUMBER>
      <PRINT_FLAG>Y</PRINT_FLAG>
      <QUANTITY_INVOICED>15</QUANTITY_INVOICED>
      <UNIT_SELLING_PRICE>-5</UNIT_SELLING_PRICE>
      <INVENTORY_ITEM_ID1>37384</INVENTORY_ITEM_ID1>
      <LINE_TYPE1>LINE</LINE_TYPE1>
      <DESCRIPTION>Primer Extensions</DESCRIPTION>
      <EXTENDED_AMOUNT1>-75</EXTENDED_AMOUNT1>
      <CUSTOMER_NAME>Health Protection Agency</CUSTOMER_NAME>
      <CUTOFF_DATE1>21-DEC-96</CUTOFF_DATE1>
      <REPORT_DATE>30-AUG-10</REPORT_DATE>
      <PROJECT>96269</PROJECT>
      <PP_AMOUNT />
      <CUST_TRX_TYPE_ID>1205</CUST_TRX_TYPE_ID>
      <CUSTOMER_TRX_ID1>230471</CUSTOMER_TRX_ID1>
      <CURRENCY_CODE>GBP</CURRENCY_CODE>
      <INVOICE_DATE>21-SEP-09</INVOICE_DATE>
      <INVOICE_NUMBER>10735</INVOICE_NUMBER>
      <ITEM_NUMBER>00 - PT</ITEM_NUMBER>
      <BEFORE_START_TOTAL>0</BEFORE_START_TOTAL>
      <TOTAL>75</TOTAL>
      </G_INVOICE>
      -----------------------------------------------------------------------------------------------
      <G_PP_NUMBER>
      <PP_NUMBER>PP101</PP_NUMBER>
      - <LIST_G_INVOICE>
      - <G_INVOICE>
      <INVOICE_CONTACT />
      <LINE_NUMBER>1</LINE_NUMBER>
      <PRINT_FLAG>Y</PRINT_FLAG>
      <QUANTITY_INVOICED>1</QUANTITY_INVOICED>
      <UNIT_SELLING_PRICE>0</UNIT_SELLING_PRICE>
      <INVENTORY_ITEM_ID1>37421</INVENTORY_ITEM_ID1>
      <LINE_TYPE1>LINE</LINE_TYPE1>
      <DESCRIPTION>Customer deposit</DESCRIPTION>
      <EXTENDED_AMOUNT1>0</EXTENDED_AMOUNT1>
      <CUSTOMER_NAME>Imperial College London</CUSTOMER_NAME>
      <CUTOFF_DATE1>21-DEC-96</CUTOFF_DATE1>
      <REPORT_DATE>30-AUG-10</REPORT_DATE>
      <PROJECT />
      <PP_AMOUNT>432</PP_AMOUNT>
      <CUST_TRX_TYPE_ID>1204</CUST_TRX_TYPE_ID>
      <CUSTOMER_TRX_ID1>231349</CUSTOMER_TRX_ID1>
      <CURRENCY_CODE>GBP</CURRENCY_CODE>
      <INVOICE_DATE>30-SEP-09</INVOICE_DATE>
      <INVOICE_NUMBER>11127</INVOICE_NUMBER>
      <ITEM_NUMBER>999 - DEPOSIT</ITEM_NUMBER>
      <BEFORE_START_TOTAL>0</BEFORE_START_TOTAL>
      <TOTAL>0</TOTAL>
      </G_INVOICE>
      </LIST_G_INVOICE>
      <PP_TOTAL>0</PP_TOTAL>
      <AMOUNT_BEFORE_START>0</AMOUNT_BEFORE_START>
      <PP_INVOICE_CONTACT>Imperial College - Prof Wells</PP_INVOICE_CONTACT>
      <ADDRESS1>Level 3</ADDRESS1>
      <ADDRESS2>Sherfield Building</ADDRESS2>
      <ADDRESS3 />
      <ADDRESS4 />
      <CITY>London</CITY>
      <COUNTRY>United Kingdom</COUNTRY>
      <EMAIL_ADDRESS>rmcintron@beckman.com</EMAIL_ADDRESS>
      </G_PP_NUMBER>


      ANY Help will be greatly appreciated
        • 1. Re: BURSTING - separate output file to individual
          502042
          It depends strongly what BI Publisher version you are talking about, since bursting is differently
          provided in EBS, Peoplesoft or a standalone BI Publisher.

          In the following I assume that your question is about a standalone BI Publisher
          That is what our bursting functionality is for. It runs the data in one query and creates a large XML dataset.
          However, we seperate the bursting information from the data. you will need to create a seperate bursting
          query that requires all the delivery information for a specific key - i.e. PP_NUMBER.

          While we provide a funtionality as you require in E-Business Suite, we had customers that do not have
          the delivery information in the data and we found it a cleaner approach to have delivery information
          independent of the data.

          If your email address and pp_number are in a database it should be easy to create a query that provides
          the bursting information. Hope that helps,

          Klaus
          • 2. Re: BURSTING - separate output file to individual
            rcintron100
            We are using XML Publisher with EBS - Not the Enterprise version.

            We also do have the PP_NUMBER and the EMAIL_ADDRESS in the XML DATA, can you point me to an example on how I can then trigger the segreation of documents??

            Thanks in Advance
            • 3. Re: BURSTING - separate output file to individual
              457157
              Have a look on XDOBURSTRPT executable seeded in EBS for Bursting Report.

              Here are the steps

              Concurrent Program:
              ------------------
              -Name : XML Publisher Report Bursting Program
              -Short Name : XDOBURSTREP

              Process:
              -------
              Upload the bursting control file to respective Report Data Defintion. Run the Report as Normal Report.
              Once the Report completed successfully, Run the XML Publisher Report Bursting Program and pass
              the Report Request ID as parameter. This will access the data and control file based on the Parent Request ID.

              The Bursting Listener can be added as an attribute to Bursting control file. Please see the sample control
              file for implementation details.

              ------

              Please refer userguide on how to design the control file. You can refer following articles as well

              http://blogs.oracle.com/BIDeveloper/bursting/
              http://blogs.oracle.com/BIDeveloper/2009/12/working_with_bursting_listener.html
              http://blogs.oracle.com/BIDeveloper/2010/08/xdoburstrpt_passing_parameters.html
              • 4. Re: BURSTING - separate output file to individual
                rcintron100
                I keep getting error:
                [083110_105605801][][EXCEPTION] The URL ( xdo://XBOL.XXB_PPINV_ALL.en.US/?getSource=true ) is invalid.


                Can any one share some light on this?
                • 5. Re: BURSTING - separate output file to individual
                  457157
                  Make sure in xdo://XBOL.XXB_PPINV_ALL.en.US/?getSource=true,

                  XBOL is your application Short Name/Application code
                  XXB_PPINV_ALL is template code
                  en is your language
                  US is territory

                  and Template type = "rtf"

                  and you should be using this through XDOBURSTREP executable not through Java API.

                  Edited by: Ashish Shrivastava on Sep 1, 2010 3:52 AM
                  • 6. Re: BURSTING - separate output file to individual
                    rcintron100
                    Email is now working - but only sends one email - instead of splitting the request per Statement.
                    Any suggestions will be greatly appreciated