This discussion is archived
6 Replies Latest reply: Sep 2, 2010 1:29 PM by rcintron100 RSS

BURSTING - separate output file to individual

rcintron100 Newbie
Currently Being Moderated
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 Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Email is now working - but only sends one email - instead of splitting the request per Statement.
    Any suggestions will be greatly appreciated

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points