Login
Register

Home

Trainings

Fusion

R12

Blogs

Contact Us

Prasad Parmeswaran
  • Register

Oracle Gold Partners, training schedule is listed here designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active
 

In this article i will give an overview of Bursting in BI Publisher (Formerly XML Publisher ) and the Pre requisites to enable Bursting .Prasad CP

Background / Business Requirement for Bursting

In Oracle Purchasing we have PO Print Report which can be used to print new or selected Purchase order. Organizations usually schedule this program on a daily basis to print new purchase orders. If we want to integrate this Oracle Report to XML/BI Publisher to create eye candy layouts and email the PO automatically to the suppliers, the common issue we face is :-

How to split the XML file created by report ? This is because report will create a single XML file consisting of the all the PO selected and if we apply the template on this XML file , it will create a single PDF file consisting of all the PO’s , and we definitely don’t want purchase orders sent to a supplier which is not related to him .If we have to send PO to individual supplier there has to be a way to parse the XML file generated from the PO Print Report.After parsing the XML file we can break the XML into smaller chunks based on the PO Number and then email the PO to respective Suppliers.

 


Advantages of XMLP bursting

a. No Additional Coding, just need to create XML bursting File. ( Isn't it exciting , otherwise we would have to write java program to split the XML File and then use XMLP delivery manager API to send emails .
b. Process of Creating XML data Definition and Template remains AS – IS .

 

Prerequisites

a. Apply patch 5968876 if not already applied
b. Verify XMLP version is 5.6.3

Steps to Verify if XMLP is indeed 5.6.3

1. adident Header $OA_JAVA/oracle/apps/xdo/common/MetaInfo.class

Below matrix shows the the version you are and the patch to be applied to come to 5.6.3

Metainfo.class

 

Metainfo.class

XML Publisher

Patch Reference
120.6 XDO 5.6.3 Patch 4440000 
... for the Oracle E-Business Suite 11i   
115.28XDO 5.6.3
Patch 5472959
Note 422508.1
115.27XDO 5.6.2 (core)
Patch 5097966
Note 367394.1
115.26 XDO 5.6.1Patch 4905678
Note 357308.1
115.24XDO 5.6.0
Patch 4561451Note 337999.1
115.22XDO 5.5.0
Patch 4206181
Note 316447.1
115.21XDO 5.0.1 (core)
Patch 4236958
 
115.19XDO 5.0.0
Patch 3822219
Note 295036.1
    



c. Set Temporary Directory in the XML Publisher Administrator- > Administration- > General to a directory to which you have write permission .


d. After the Patch is applied we will see a new Bursting control file button in the XML Publisher Data Definition Page

To check this, please go to Responsibility "XML Publisher Administrator", and search for any existing report, and click on Update. While updating an existing data-definition, you should see the button Bursting Control File.

Now since we have finished setting up , now we will see how to implement Bursting . The major component in this is bursting control file


What is a bursting file ?

Its an XML file which tells bursting engine


a) How to split the XML File created ?

b) How to deliver the Documents ?


Lets see a sample bursting file and its components

 

a) <xapi:request select> tag tells busting engine , bursting should be done at the occurrence of which tag ?
b) <xapi:delivery > tag tells bursting engine , which delivery mechanism to be used and on what condition ?

Sample bursting file


<xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi" type="bursting">
<xapi:request select="/xxx_HQ_XML_POXPRPOL/LIST_G_INIT_INFO/G_INIT_INFO/LIST_G_HEADERS/G_HEADERS">
<xapi:delivery>
<xapi:email id="123" server="xxxort" port="25" from="This email address is being protected from spambots. You need JavaScript enabled to view it." reply-to="This email address is being protected from spambots. You need JavaScript enabled to view it.">
<xapi:message id="123" to="${CF_VENDOR_EMAIL}" attachment="true" subject=" Purchase Order No: ${POH_PO_NUM}">

Please review the attached PO ${POH_PO_NUM}
</xapi:message>
</xapi:email>
</xapi:delivery>
<xapi:document output-type="pdf" delivery="123">
<xapi:template type="rtf" location="/u0350/app/apps/UAT/xx/1.0/data/XXHPAPOPRINT.rtf">
</xapi:template>
</xapi:document>
</xapi:request>
</xapi:requestset>

Please Note : While doing testing please change the "to address" to your email address , else it will send the documents out to that email address .

Data Definition

Create the Data Definition and Template the normal way, where the Short name of the data definition is same as the short name of concurrent program to which you are integrating XMLP.While creating Data Definition Upload you bursting XML File . If there are any parsing issues in the XML file it will give error , please correct the format of the file and try to upload again .

 

Template File

Create the Template and Upload your Template file

 

 

Concurrent Program Registeration

In the Concurrent Program give the Output fomat as XML and the Concurrent Program Short name should be same as the data definition name .


After Report Trigger Changes

Now the Final Step , in the After report Trigger of your .RDf add the following code to call bursting program . This will lanuch the bursting program from your report , otherwise you will have to run the Bursting program ( which is a Java Concurrent Program ) manually .

 

Now you are all set to do the testing , run the report , please keep in mind to change "to email address" in the bursting control file to your email id while doing the testing . you will see the PO pdf coming to the email address given in the bursting control file.


Prasad-CP

Overall Rating (0)

0 out of 5 stars
  • Guest - vishwait

    hi,
    I am using xml publisher 5.6.3 fororacle apps. 11i and report containts both english and arabic language.
    the arabic language starts from right side.
    while generating rtf output whenever english word follows arabic ,the line changes its direction of formatting.
    please suggest any solution for above case

    2 Like
    Short URL:
  • Vishwajit ,
    if its a static text please try embeding it as image . please let me know if it works out .

    Thanks
    Prasad

    0 Like
    Short URL:
  • Guest - Surlina

    Hi,

    With HRMS, can we use XML publisher to create Manager Self-Service reports & analytics (ie. to replace Discoverer Viewer) and apply the same security profile?

    Thanks,
    Surlina

    1 Like
    Short URL:
  • Hi Anil,

    Can you plz tell me where I am wrong with a clear example.....
    close_po is a function which returns a boolean value.

    DECLARE
    l_return_status Boolean;
    l_return_status1 Boolean;
    BEGIN
    FND_GLOBAL.apps_initialize('111','222','333'); -- ( user_id, Resp_id, Appli_id )
    --call the Close API
    l_return_status := po_actions.close_po(1205813,-- p_docid
    'PO',-- p_doctyp
    'STANDARD',-- p_docsubtyp
    null,-- p_lineid
    null,-- p_shipid
    'CLOSE',-- p_action
    'TEST',-- p_reason
    'PO',-- p_calling_mode
    'N',-- p_conc_flag
    l_return_status1,-- p_return_code
    'Y',-- p_auto_close
    SYSDATE,-- p_action_date
    null); -- p_origin_doc_id
    -- Get any messages returned by the Cancel API
    DBMS_OUTPUT.put_line('l_return_status :'||l_return_status);
    end;


    This is very urgent, Appreciate ur help,

    Thx N Regs,
    Khan.

    0 Like
    Short URL:
  • Guest - Jai

    Hi Prasad,

    I am using XML publisher in OAF, and it is working fine with the English language data.
    But it is not displaying data for other language like Japan, China etc. it displays some junk characters like ¿¿¿¿¿ ¿¿¿¿ / ¿¿ in excel/PDF.
    Please help me in solving this issue.

    AM CODE: -

    public String initXmlReportVO(String pAction,String pEmployeeId)
    {
    //OADBTransaction oadbtransaction = (OADBTransaction)getTransaction();

    try
    {
    OAViewObjectImpl pervo=getcompVO1();

    if(pEmployeeId.equals(""))
    {
    pervo.setWhereClauseParam(0,null);
    pervo.executeQuery();
    return "N";
    }
    pervo.setWhereClauseParam(0,new Number(pEmployeeId));
    pervo.executeQuery();

    Row row[] = pervo.getAllRowsInRange();
    if(row.length >0)
    {
    return "Y";
    }
    else
    {
    return "N";
    }
    }
    catch(Exception e)
    {
    throw new OAException(e.toString(),OAException.ERROR);
    }

    }



    //XML Get data code
    public ClobDomain getXMLData()
    {
    OAViewObjectImpl voProject=getcompVO1();

    ClobDomain cd = new ClobDomain();
    Row row[] = voProject.getAllRowsInRange();

    if(voProject!=null && row.length >0)
    {

    try{
    cd.getCharacterOutputStream().write("
    ");
    cd.getCharacterOutputStream().write("
    ");

    XMLElement ele = (XMLElement)voProject.writeXML(0,XMLInterface.XML_OPT_ALL_ROWS);
    ele.print(new java.io.PrintWriter(cd.getCharacterOutputStream()));

    }
    catch(Exception e)
    {
    e.printStackTrace();
    }
    return cd;
    }
    return null;
    }// end of getXMLData

    CONTROLLER CODE

    //Export Event When user clicks on Export Button
    if(actionInMainEmployeeScreen.equals("export"))
    {

    actionEmployeeId=pageContext.getParameter("ssohide");

    if (actionEmployeeId.equals(""))
    {
    Serializable paramSearch[]={actionInMainEmployeeScreen,actionEmployeeId};
    result = (String)am.invokeMethod("initXmlReportVO",paramSearch);
    throw new OAException(" Please Enter any valid value for SSO", OAException.ERROR);
    }
    else
    {

    try
    {
    Number num =new Number(actionEmployeeId);

    }
    catch(Exception e)
    {
    throw new OAException("SSO must contain only numeric values :- "+e.toString(),OAException.ERROR);
    }


    Serializable paramSearch[]={actionInMainEmployeeScreen,actionEmployeeId};
    result = (String)am.invokeMethod("initXmlReportVO",paramSearch);
    ClobDomain xmlData = (ClobDomain)am.invokeMethod("getXMLData");
    if(xmlData!= null &&result =="Y")
    {
    InputStream l_erXML = new ByteArrayInputStream(((xmlData.toString()).trim()).getBytes());
    DocumentHelper.exportDocument(pageContext,"PER","XML_TEST_EMP","en","US",l_erXML,"PDF",null);
    }
    else
    {
    throw new OAException("Provided SSO does not have any active or valid Salary Proposal ", OAException.ERROR);
    }
    }
    } //Export If Ends

    Thanks,
    Jai

    1 Like
    Short URL:
  • Guest - A. Swain

    Hi Prasad,

    Thanks a lot for sharing your knowledge. I am having some problem i.e. the standard bursting program is erroring out. I am calling this from After report trigger as you mentsioned in this article. Also i have run stand alone. still same problem continues. Can you please have a look at the log messages.

    Exception in thread "main" java.lang.NullPointerException
    at java.util.Hashtable.put(Hashtable.java:396)
    at oracle.apps.xdo.oa.cp.CPUtil.getSessionProperties(CPUtil.java:42)
    at oracle.apps.xdo.oa.cp.JCP4XDOBurstingEngine.runProgram(JCP4XDOBurstingEngine.java:80)
    at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

    Regards,
    A. Swain

    2 Like
    Short URL:
  • Guest - Anil Passi

    Hi Swain

    We believe we have answered to you on [url]http://www.apps2fusion.com/technical-articles-mainmenu-27/miscellaneous-mainmenu-40/21-miscellaneous-technology/251-xmlp-concurrent-program-revisited-with-bursting[/url]

    Please do not post same question twice on different threads.

    Thanks,
    Anil Passi

    1 Like
    Short URL:
  • Guest - Anshul singhal

    Hi Prasad/Anil,

    This is really a very good post. I have a question related to XML publisher. I will be thankful if you could please answer me this question as i have asked this question to many forums and no body has even replied to me till now.

    how can we create parameters in XML report in case of new report to be developed? Also if there is any standard report with parameters that we are converting into XML, then how do we proceed to create the parameters in XML? Also how can we replace formula columns (of Oracle report6i) in XML publisher?

    I am desperatley looking forward for answer from you guys.

    Thanks,

    Regards,
    Anshul Singhal

    3 Like
    Short URL:
  • Guest - Tatapudi

    Hi Prasad,

    Please ignore if this comment is posted earlier.

    Thanks a lot for Knowledge sharing.

    Regading the location in Bursting Control File
    { location ="xdo://PO.XXHPAPOPRINT.en.US/?getSource=true" }

    Which application short name we need to refer ("PO" or "HPA Custom Application short Name/Code"),
    Since right from CP Definition to Template Definition every thing is refering to "HPA Custom application"

    Please clarify.

    Thanks You,
    Ramakrishna

    0 Like
    Short URL:
  • Ramakrishna ,
    It would be HPA .

    Thanks
    Prasad CP

    0 Like
    Short URL:
  • Hi Prasad,
    Iam looking for the schema file for bursting control file .
    Can you send me the details of the XML Schema that the control file is based on.

    Thanks,
    Prabhakar.S

    0 Like
    Short URL:
  • Guest - santosh shiva

    Hi Prasad,

    This is santosh, I a brand new bee to XML Publisher. I was asked to generate barcode on one of the xml reports (PDF Output).
    I searched the entire world for a sample code. could never find it.
    Could u please help me out in this.

    Thanks ,
    SSTz

    1 Like
    Short URL:
  • Guest - hDost

    this is in relation to the question Tatapudi posed

    my question is what directory should the rtf be in, and what what are some other syntax you can use to refer to the location

    additionally I believe you can, but are you able to use the rtfs of templates created for regular BI publisher reports

    0 Like
    Short URL:
  • Hi Prasad

    This is a realy good post. i am new to XMl publisher. Instead of bursting how can i setup delivery manager to FTP my rtf reports. With bursting we can only email the report.However, with Delivery manager there 're other options available. Please advice on the steps the way you explained bursting .Any response is highly appreciated

    Thanks

    1 Like
    Short URL:
  • Guest - Poorna

    Hi,

    Our requirement is to attach multiple files in Bursting.
    Eg :- for each Invoice generated, another static file need to be attached, which consists of Terms & Conditions. Since the requirement is to attach the T & C file&#40;PDF&#41; seperately, I can't suffix the T & C to the template.

    Please suggest how to achieve it.

    Thanks & Regards,
    Poorna.

    3 Like
    Short URL:
  • Guest - Satya Sri

    Hi,
    I created a Control file






    Please Find the Simmons Invoice as attachment.











    This i created in Microsoft word and saved it... when i am ready to upload this file i am changing its extension from SIMMBURSTREP.rtf to SIMMBURSTREP.xml and am trying to upload in data definition its says its bursting and comes up with this error...


    The uploaded file is invalid... The File should be XML-BURSTING-FILE format..


    Any help...

    Thanks
    satya

    1 Like
    Short URL:
  • Guest - Satya Sri

    Guys,

    I figured it out... I keyed the same thing in notepad and change the extension to xml... it worked i think word has so much hidden junk in it...

    Thanks
    sri

    0 Like
    Short URL:
  • Guest - jad

    Hi, Parsad
    You already answered the question concerning the arabic output of the rtf. I'm facing the same problem but i need to know a solution when it comes for non static text (as Fields).

    0 Like
    Short URL:
  • Guest - hi

    in Ebs 12 navigate to PO window, first query a PO for instance PO number 50. then click on inquire menu and then press view document. A Po report will be displayed in pdf format. this is XML based report. i want to edit this report. i tried my level best to find the based file and concurrent program. i have posted on multiple forums as well but nothing.

    please tell me in short how can i open based template in Word(bipublisher) and edit.

    0 Like
    Short URL:
  • Guest - Sarah

    Has anyone received this error?

    Bursting initiated ...
    java.lang.IncompatibleClassChangeError
    at oracle.apps.xdo.batch.DocumentProcessor.registerListener(DocumentProcessor.java:395)
    at oracle.apps.xdo.oa.cp.XMLPReportBurstASEL.runProgram(XMLPReportBurstASEL.java:243)
    at oracle.apps.fnd.cp.request.Run.main(Run.java:148)

    1 Like
    Short URL:
  • Guest - TRamarao

    Hi,
    Is there any way to attach multiple attachments to single email address by using XML bursting? Could you please let me know ASAP?
    Regards,
    Ramarao.

    1 Like
    Short URL:
  • Guest - SK

    Hi

    Whenever I attempt to specify the location in the beloe mentioned manner

    I get a blank attachment in the email. There is no data and no template whereas i can see the data in concurrent program window.
    Could you tell me is there something wrong in the syntax I ahve mentioned?

    4 Like
    Short URL:
  • Guest - vasu

    Dear,
    I want to generate arabic language report by using xml publisher.
    can any one try to help me with details.

    1 Like
    Short URL:
  • Guest - Alan Telford

    Just burst my first BI Publisher report! Thanks for taking the time to write the article.

    I got a bit hung up on the template location as I'm working in the e-business suite.

    The solution was to use the following bit of sql

    select lt.application_short_name || '.' || lt.template_code || '.' || lt.default_language || '.' || lt.default_territory as burst_template_xdo_location
    from xdo_templates_b lt
    where lt.template_code like 'MY_TEMPLATE%'

    then code the location as



    Also if you are trying to track down your concurrent request id (for the call to XDOBURSTREP) you can find it in PL/SQL using the profile function

    FND_PROFILE.VALUE('CONC_REQUEST_ID');

    cheers

    Alan

    2 Like
    Short URL:
  • Guest - Alan Telford

    0 Like
    Short URL:
  • Guest - amit1123q

    ;D >:( :( :o 8)

    1 Like
    Short URL:
  • Guest - Sripriya Srinivasan

    This is the issue I have. We have 5 number of regions and 10 number of recipient groups with in each region. Therefore I need to publish 50 reports. I am planning to do a row-level filtering based on the
    region input within the one single report and also hide or show different sections of data using the one template based on the recipient group user input. Now I don't want to run the concurrent programs 50 times to generate and send 50 reports but rather use the bursting control file in some way. At the same time, I don't want the report to be split up in any way. Hope this makes sense.

    1 Like
    Short URL:
  • Guest - nilesh

    I am facing some problem in this issue.
    Please help me....

    I need to develop mechanism for varying XML Publisher output by instance in other words Instance based Output of XML Report Publisher without customizing particular rdf or package.

    for this we need to call particular template or format that template depend upon Instance name.
    So we need instance name in XML file but we don't have instance name in that particular XML Data file.

    How can I add Instance name in rtf template and XML data file without customizing XML Source package or rdf Report to compare that Instance name with current instance name in RTF Template.

    For example:
    If Instance name = Production then call watermark of company logo otherwise simple report output.

    Note: don’t have Instance name in XML Data file.


    Thanks in Advance
    Nilesh

    0 Like
    Short URL:
  • Guest - Srivatsrs

    Hi,

    I have a scenario wherein we are generating checks using BI Publisher and in that process we have to do the following:

    a) Split the total number of checks into two sets (Each check will have check and its stub).
    b) Send one set to one printer and other set to a different printer

    Please help me as how to approach this. Do I need to write a custom java program or it can be achieved using the bursting xml itself ?

    Thanks & Regards,
    Srivats

    0 Like
    Short URL:
  • Guest - Venkanna Pasam

    Hi,
    This is an excellent article and which is helped me alot....
    I have followed the setps explained in this articles and getting emails when we submit the report, but if we check the email in the outlook "Sent Time" is displaying as None. Also we have implemented XML Bursting Program for another client, there we are getting Sent time in the outlook.
    Please advise me what could be the problem.

    Thanks in Advance...
    Venkanna.

    0 Like
    Short URL:
  • Guest - malla

    Hi ,

    This is a very good article.I was new to xml publisher but i did almost all my worlk with help of this article.

    Could you please tell me is there any command or syntax for new line in C /n.

    I have requirement that after bursting pdf's,it should be sent to the customer.I have done almost all the work.
    The issue is with email body.
    I am trying to get as

    Dear Customer XXXXXXX,

    Please find attached Invoice for the month of January.



    Regards,

    The Receivables Team XXXX Inc.

    but where as i am getting like

    Dear Customer XXXXXXX. Please find attached Invoice for the month of January Regards, The Receivables Team XXXX Inc.


    any idea.


    Thanks,
    Malla

    0 Like
    Short URL:
  • Guest - Vibhanshu

    How can i do bursting on different printer depending particular department. i.e. each department on different printer.

    0 Like
    Short URL:
  • Guest - Ravin

    Prasad/Anil,

    I have a PL/SQL procedure with multiple XML output. Only one output will be in the xml file-- which will based on the parameter passed in the procedure. I also have multiple teplate which I want to select based on parameter passed in the procedure.
    Can I use Burstin for this, if so, what should be in the
    I see I can use the filter to select the rtf file, but how do I use the parameter from procedure in the filter.

    Thanks,

    Ravin L. Gogri

    2 Like
    Short URL:
  • Guest - Devendar

    Hi,

    Thanks alot for the information you are providing through this web-site.

    I have used the above logic and it is working fine in our environment. Now I have got new requirement to change the language of the report based on the country.

    When I hard code the path of the template as below, it is working fine.



    But when I pass this value from Report builder, it is erroring out.


    The error I am getting is :
    [050409_041710370][oracle.apps.xdo.batch.bursting.FileHandler][EXCEPTION] java.io.FileNotFoundException: ${LANG_LOCATION} (No such file or directory (errno:2))

    Is there any setting, where we need to specify the location of the rtf files?

    1 Like
    Short URL:
  • Guest - Rama Calipatti

    Hi,

    Thanks for a Good Article on "Bursting" in XML Pubilisher. I have a different requirement. I don't want to email the pdf file.
    Instead I want to create pdf files with PO# like PO_12345.pdf (where 12345 is the PO #) and ftp all pdf files to a particular Windows directory.
    Please provide me the sample bursting file for this purpose.

    Thanks Much,
    Rama

    0 Like
    Short URL:
  • Guest - Krishna Poda

    Hello Prasad,

    In the above example you've mentioned that bursting happens on the specific occurrence of the tag. But is it possible to burst on the value of a specific element?
    Ex: G_HEADERS/VENDOR_CLASS= 'ABC' then burst in a different way.

    Pls let me know.

    Thanks,
    Krishna

    2 Like
    Short URL:
  • Guest - Kapil Sachdev

    Thanks. it is indeed very compact and covers everything.
    Best Regards.

    0 Like
    Short URL:
  • Guest - TomW

    I was having the issue where all of the email output was on the same line. All I did was change the content-type to text and formatted the text properly:


    Attached is the Abandoned Accounts Report

    Concurrent Program : Abandoned Accounts

    Concurrent Request ID: ${REQUEST_ID}

    Request Run By : ${REQUESTOR}

    0 Like
    Short URL:
  • Guest - Thangs

    HI Rama,
    I have the same requirement as that of you. I no need email the PDFs but to send the files to specific directory. Did u find solution??

    Friends,
    Is it mandatory to speficy the tag??? without that tag, its giving an error while uploading bursting control file..

    0 Like
    Short URL:
  • Guest - madhumr

    Hi Prasad,
    I have developed one xml publisher report based on RDF..Requirement is " when ever it submits from srs window mail needs to be sent to any person..
    could you please help me out ..Is this bursting concept is helpful in my case...

    Thanks,
    Madhu

    0 Like
    Short URL:
  • Guest - rupdipt

    Getting the following error for XML Publisher Bursting Program,

    XML/BI Publisher Version : 5.6.3
    --Exception
    For input string: "Y"
    java.lang.NumberFormatException: For input string: "Y"
    at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
    at java.lang.Integer.parseInt(Integer.java:447)
    at java.lang.Integer.parseInt(Integer.java:497)
    at oracle.apps.xdo.oa.cp.JCP4XDOBurstingEngine.runProgram(JCP4XDOBurstingEngine.java:142)
    at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

    Any ideas?

    Regards,
    Rupdipt

    0 Like
    Short URL:
  • Guest - Sonal

    Hi,

    I have a template in .rtf.It contains table. The requirement is to display table on some condition.
    How can I hide n show table as I cannot control it through our JDE code. Can you please help me out with this.

    0 Like
    Short URL:
  • Guest - Pranit Kumar Saha

    Very helpful document. It has really helped me to do the bursting for the first time.

    1 Like
    Short URL:
  • Guest - Mike Wyszynski

    I am having trouble with sending the XML bursted output through sftp. Does someone have experiance setting this up with Oracle EBS 11.5.10? I am not clear from the documentation if I need to setup up a custom delivery method or one alredy exists for SFTP, and how do I activate it.

    Thanks for your help

    0 Like
    Short URL:
  • Guest - Satyajitm

    Hi Prasad.

    Thanks for the sharing a very nice document on XML bursting concepts.
    In my case I have done XML bursting with RTF template.

    Is it possible to get the bursting done for output type to XLS and template type to XSL-XML?
    I tired with the above example but it didnt worked.

    Your help will be appreciated.

    Thanks
    Satya

    1 Like
    Short URL:
  • Guest - Kay

    Hi Prasad

    First of all thanks for the excellent article.

    Is it possible to use the XML bursting for AR invoices?
    Please let me know.

    Thank you

    Regards
    Kay

    0 Like
    Short URL:
  • Guest - swathib

    Configured HTTP server from BIPub UI but , when i click on SEND button, it is not recognizing HTTP server just added.
    Please help me with this

    1 Like
    Short URL:
  • Guest - Aiyaz

    Hi Anil,

    First of all cheers for the good work......Can you please mail me some inerview questions that will help in getting me a job in
    Oracle Applications.
    Your help will be apprieciated....

    Thanks
    Aiyaz

    0 Like
    Short URL:
  • Guest - Nitin_M

    Hi All,

    I am gettinf the following error while runing Brusting program, I am passing the proper value to the standard Oracle Brusting program

    "XML/BI Publisher Version : 5.6.3
    --Exception
    For input string: "Y"
    java.lang.NumberFormatException: For input string: "Y"
    at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
    at java.lang.Integer.parseInt(Integer.java:447)
    at java.lang.Integer.parseInt(Integer.java:497)
    at oracle.apps.xdo.oa.cp.JCP4XDOBurstingEngine.runProgram(JCP4XDOBurstingEngine.java:142)
    at oracle.apps.fnd.cp.request.Run.main(Run.java:157)"

    Can any one suggest me where i am making mistake?

    Thanks
    Nitin

    0 Like
    Short URL:
  • Guest - Bob Harrison

    my templates are in landscape
    using burst to CUPS server (ipp:...) output pdf
    fax sends portrait (half the landscape)

    need to force a Rotate 90, but cannot find a way to do this

    Any suggestions ?

    0 Like
    Short URL:
  • Guest - Ashihs Raj

    Bob,
    Try orientation-requested attribute. test with the value 1, 2, 3, I am not sure which is the correct value.



    Thanks
    -Raj
    www.adivaconsulting.com
    Adiva-blog

    0 Like
    Short URL:
  • Guest - Ashihs Raj

    xapi:print id="PRINT_DELIVERY" printer=" ipp://myhost:631/printers/P2165" copy-no="2" paper-size="letter" orientation-requested="3"

    0 Like
    Short URL:
  • Guest - Mustafa Darling

    The file gets generated in the Temp Directory and gets deleted and Concurrent request goes into error saying
    This request finished with an error and produced the following completion message: /u02/esdevdcomn/temp/110410_015702204/IR_WCF_Receipt_LEG5981.pdf (No such file or directory)

    0 Like
    Short URL:
  • Guest - Prem Raj Dasari

    Hi Prasad,

    Is it possible, Instead of Email address I want all the files in one location?.....

    0 Like
    Short URL:
  • Guest - Javed Kapoor

    Hi I've followed all the steps as given in the document but I'm getting the following error while running the bursting program.

    "XML/BI Publisher Version : 5.6.3
    --Exception
    For input string: ""
    java.lang.NumberFormatException: For input string: ""

    1 Like
    Short URL:
  • Guest - unknown

    Hi,

    I have a issue with bursting the Excel formatted output of BI publisher report. If the size is less than everything works fine. If the output file size is 33 MB, i am not able to view the output in the request form and also bursting is not working. Can you please let me know if there is any restriction in the size of excel output for bursting.

    Thanks in Advance

    0 Like
    Short URL:
  • Guest - mmyswamy

    Hi Anil
    The problem is that when the report runs I get the following error message
    Unable to Run Report to the Paper Design
    REP-1272: Column 'field' may not be used as a Break Column.
    I have no clue to whats wrong. I added another filed and deleted the old one and still get the same problem.

    Where should I look at for this problem? Can I not read a clob?

    InAdvance Thanks,

    0 Like
    Short URL:
  • Guest - MS PRASAD

    Hi Prasad,
    my problem is i am giving three mail ids out of which there is one wrong mail id then output is not delevired to rest of two mail id
    can please help me to fix this issuse

    0 Like
    Short URL:
  • Guest - JD

    Hi, Prasad,

    This is a very helpful article. I am able to generate email with separated PDf files.

    But the PDF attachment come with password protected when I try to open it. I don't see anywhere I have set up the password. Do you know where this could be? The original (unburst) pdf file is fine.

    Thanks,
    JD

    1 Like
    Short URL:
  • Guest - Ashish Harbhajanka

    Hi Prasad/Senthil/Kishore/Anil/....,

    I would like to know whether BI Publisher Template Builder is supported with MS Office 2007.

    I tried installing the MS Office 2007 but the BI Publisher Special Menu did not appeared. The same is there with MS 2003.

    Can you guys help. Who Knows, this could be your next article Title -' Installing BI Publisher Template Builder for MS 2007'

    If not atleast please send me a note /tips/tricks on ashish1234u@gmail.com.

    I am very comfortable with Office 2007 but was compelled to downgrade to Office 2003 for the same .

    Thanks
    Ashish

    0 Like
    Short URL:
  • Guest - Vinu Menon

    Ashish,
    Please check Add-in tab when you open your template. You should find the Template builder tool menu there.

    Cheers!
    -Vinu

    0 Like
    Short URL:
  • Guest - Hrishikesh Singh

    Hi,
    I tried creating the burst file on test environment and it works perfect.Now in production i need to move this file trough patch so can anyone please tell me what would be the DBDRV commands for the burst file so that ARU created and patch can be applied.

    0 Like
    Short URL:
  • Guest - Lakshmi narayana

    Dear Techies,

    In payable module when payments made to suppliers I need to send an email notification to that particular supplier. I have achieved this by using xml bursting. Every thing is fine but

    I have got an another change request from my client which is depends upon Payment method (Check, Wire or Cash ) they want one image to be in email body. (Image contains some text in different colors and different fonts)

    I am wondering how can i do this ?

    below is my control file code. Please let me know how can i mention image path , so that it will take from there and sends an email.






    Please find attached payment details report. ${CHECK_NUMBER}_${VENDOR_NAME}








    Thanks in advance guys

    0 Like
    Short URL:
  • Guest - Prasant Bhaskar

    Thanks Prasad, for sharing this knowledge....

    regards,
    Prasant

    0 Like
    Short URL:
  • Guest - Gopinath - M

    Hi Prasad
    Thanks for all the support in providing resolutions to all ... Appreciate if you can let us know how to handle the special characters in Bursting engine.
    The Bursting Engine request errors ... log file has "ZIP file must have one entry"

    thanks in advance
    Gopinath

    0 Like
    Short URL:
  • Guest - fillmore

    Has anyone been able to create a custom PO print using BI publisher where by we can email the PO attachments also ?

    -Fillmore

    0 Like
    Short URL:
  • Guest - vinay sawant

    i want to create password protected pdf report using bursting in oracle
    for each new pdf i want new password..but password should be dyanamic for each pdf..pls help me using oracle

    0 Like
    Short URL:
  • Guest - sam2228

    Hi,

    I wanted to know if there's a way we can delete the files that were burst. My requirement is i load the burst files in db..which means i will have the burst file in the file system and database..which is redundant so i want to delete the file from file system as soon as the file is loaded in db.

    -Sam

    0 Like
    Short URL:
  • Guest - Satish656

    Hi Prasad,

    Very nice article.

    I have Customized Pack Slip Acknowledgment for one of my client. My Client is expecting to have All the tracking numbers corresponding to a Delivery on to the Email Body.

    Please let me know if this can be achieved.

    Thank You.

    0 Like
    Short URL:
  • Guest - SealKunal

    Its a really good article.

    The argument passed in the Submit Request of 'XDOBURSTREP' is not correct, I think. One parameter 'Dummy for Data Security' is missing which will be the argument1 and ':P_CONC_REQUEST_ID' will be the Argument2.

    The Submit Request should be like

    FND_REQUEST.SUBMIT_REQUEST('XDO',
    'XDOBURSTREP',
    NULL,
    NULL,
    FALSE,
    'Y',
    TO_CHAR(:P_CONC_REQUEST_ID),
    'Y',
    chr(0));


    Thank You

    2 Like
    Short URL:
  • Guest - SealKunal

    On my last comment ': P' has been replaced by Smiley :P

    :)

    0 Like
    Short URL:
  • Guest - agautam

    Hi,

    How can I burst AP checks (format payment instructions) in R12?

    Thanks,

    0 Like
    Short URL:
  • Guest - oraclelearner

    Thanks for posting , keep up the good work.

    0 Like
    Short URL:
  • Guest - BI Publisher

    Hi,
    I have a shellscript file which is registered as host in the concurrent program.
    It calls the rdf file.
    and change the output into pdf and mail as an attachment to the email id provided in the parameter in SRS window.
    Now my requirement is to convert the report into BI Publisher report.
    There are some changes to the rdf.
    How to do,
    shall I need to create a new shellscript file?
    Anybody please advice me the alternate ways.

    1 Like
    Short URL:
  • Guest - bhshk.dubey

    Hi Anil/Prasad,
    I want to incorporate a table with 2 rows and 4 columns in the message body of the email, itself. I had tried many workarounds.

    Could you please help urgently!!!

    Thanks,
    Abhishek

    1 Like
    Short URL:
  • Guest - PuzzledbyXMLBursting

    Hi Prasad,
    Nice article.
    We used bursting for sending out AR statements. We want to email the statements and ftp the same to another server for backup copies. When I have my delivery as just email, everything works as expected. When I add 'ftp' delivery in addition to 'email', I see strange behaviour. If an element in XML is null, and this element is referenced in the email body/subject line, this element shows values from another element that has a value. For example, we have an element 'comment' which is referenced in subject of the email. This 'comment' can be null, and when it is null, the value shows 'party_name'. Any ideas on why XML Bursting program would show values from other elements when the referenced element value is null?
    Any help is appreciated.
    Thanks

    1 Like
    Short URL:
  • Guest - PuzzledbyXMLBursting

    Hi Prasad,
    Nice article.
    We used bursting for sending out AR statements. We want to email the statements and ftp the same to another server for backup copies. When I have my delivery as just email, everything works as expected. When I add 'ftp' delivery in addition to 'email', I see strange behaviour. If an element in XML is null, and this element is referenced in the email body/subject line, this element shows values from another element that has a value. For example, we have an element 'comment' which is referenced in subject of the email. This 'comment' can be null, and when it is null, the value shows 'party_name'. Any ideas on why XML Bursting program would show values from other elements when the referenced element value is null?
    Any help is appreciated.
    Thanks

    1 Like
    Short URL:
  • Guest - Adnan

    Hi, i want to create password protected pdf report using bursting in oracle
    for each new pdf i want new password..but password should be dyanamic for each pdf..pls help me using oracle

    Thanks

    0 Like
    Short URL:
  • Guest - samir kumar

    Hi ,

    I have developed a report to submit the bursting program and yes, the program is being submitted but it completes with error status where as the log file doesn't contain any error message.

    Could you please suggest, below is the log output.


    +---------------------------------------------------------------------------+
    XML Publisher: Version : 12.0.0

    Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

    XDOBURSTREP module: XML Publisher Report Bursting Program
    +---------------------------------------------------------------------------+

    Current system time is 13-AUG-2013 15:47:37

    +---------------------------------------------------------------------------+

    XML/BI Publisher Version : 5.6.3
    Request ID: 13182850
    All Parameters: Dummy for Data Security=Y:ReportRequestID=13182849:DebugFlag=Y
    Report Req ID: 13182849
    Debug Flag: Y
    Updating request description
    Updated description
    Retrieving XML request information
    Node Name:MACORACLE02
    Preparing parameters
    null output =/u01/MAHRUAT/mahrmsapp/inst/apps/MAHRUAT_macoracle02/logs/appl/conc/out/o13182850.out
    inputfilename =/u01/MAHRUAT/mahrmsapp/inst/apps/MAHRUAT_macoracle02/logs/appl/conc/out/o13182849.out
    Data XML File:/u01/MAHRUAT/mahrmsapp/inst/apps/MAHRUAT_macoracle02/logs/appl/conc/out/o13182849.out
    Set Bursting parameters..
    Temp. Directory:/u01/MAHRUAT/mahrmsapp/apps/apps_st/appl/xxmac/12.0.0/reports/US
    [081313_034743862][][STATEMENT] Oracle XML Parser version ::: Oracle XML Developers Kit 10.1.3.5.0 - Production
    [081313_034743868][][STATEMENT] setOAProperties called..
    Bursting propertes.....
    {user-variable:cp:territory=US, user-variable:cp:ReportRequestID=13182849, user-variable:cp:language=en, user-variable:cp:responsibility=52942, user-variable.OA_MEDIA=http://macoracle02.maaden.com:8072/OA_MEDIA, burstng-source=EBS, user-variable:cp:DebugFlag=Y, user-variable:cp:parent_request_id=13182849, user-variable:cp:locale=en-US, user-variable:cp:user=REDDYRA, user-variable:cp:application_short_name=XDO, user-variable:cp:request_id=13182850, user-variable:cp:org_id=110, user-variable:cp:reportdescription=MAC IRC Candidate Medical Fitness Letter, user-variable:cp:Dummy for Data Security=Y}
    Start bursting process..
    Bursting process complete..
    Generating Bursting Status Report..
    +---------------------------------------------------------------------------+
    Start of log messages from FND_FILE
    +---------------------------------------------------------------------------+
    +---------------------------------------------------------------------------+
    End of log messages from FND_FILE
    +---------------------------------------------------------------------------+


    +---------------------------------------------------------------------------+
    Executing request completion options...

    Output file size:
    4181


    Finished executing request completion options.

    +---------------------------------------------------------------------------+
    Concurrent request completed
    Current system time is 13-AUG-2013 15:47:50

    +---------------------------------------------------------------------------+



    Regards,
    Samir

    1 Like
    Short URL:
  • Guest - Bhaskar Naidu

    Hi,

    I face the same issue as 'Samir Kumar' said above. Is there any way to get the clear log or what is causing issue here. Your help would be much appreciated.

    Thanks,
    Bhaskar

    0 Like
    Short URL:
  • Guest - Ahmed Ahmedov

    Thanks for the great post!
    Currently we have ePO which sends out approved POs to their respective supplier. The requirement is to CC the same PO pdf output as an attachment to the PR creator so that the PR creator knows their PR is approved and sent to the supplier. We tried PO: Secondary Email profile option for that but it is not flexible enough and only sends CC emails to the PO submitter (i.e. Buyer).
    PO pdf files are created and submitted to the supplier by "PO: Communications for Output" concurrent program. Is it possible to apply XML bursting in this case to achieve what we need?

    0 Like
    Short URL:
  • Guest - fhariddin

    how to send a xml bursting data in customer wise, but my customer dont have the group name.
    with out group how to split the bursting file, is there any logic for spliting the bursting file in field wise?

    Please give me the answer

    0 Like
    Short URL:
  • Guest - PO Attachments

    My client's requirement is to print Purchase Order and it's file attachments in a single package...is it possible to print Attachments using BI Publisher. If so, how can we do it. If not, how can we achieve this using Bursting feature. <br />Please let me know.<br />Thanks.<br />PM

    0 Like
    Short URL:
  • Guest - Sureshece

    HI <br />How to added if else condtion in xml bursting contral file

    0 Like
    Short URL:
  • Guest - Worth ful

    Hi Prasad, This post is worth the effort, I was able to do the xml bursting. Initially I had errors, but I was able to fix all of them one by one. Best of luck.

    0 Like
    Short URL:
  • Guest - Das

    I am calling the 'XML Publisher Report Bursting Program' in one of the custom RDF report. But I want read the view out put of the burst program which is in standard xml formate.<br /><br />How can I read the view output.<br /><br />Thanks,<br />Das P

    0 Like
    Short URL:
  • Hi,<br />I am new to bip bursting concept and your article helped me a lot. I am now stuck with a problem where I am not able to figure out why my bursting report file is not getting saved in the location provided in the query? <br />Are we supposed to do it manually or how are we supposed to do it .. can you please throw some light on this would appreciate your early response.<br /><br />Thank you :)

    0 Like
    Short URL:
  • Guest - sankar

    Hello...<br /><br /> <br /><br />I have a requirement where i need to change the to email address in the bursting control file based on the instace.<br /><br />I have a parameter for email,If instance is production i have to take the email which is given in the parameter,in non production environments i have to change the email based on the lookup specified for each instance .<br /><br /> <br /><br />Please let us know how can i achieve this.

    0 Like
    Short URL:
  • Guest - Scott

    We currently generate an email to AR customers along with the invoice attachment for one business group.<br /><br />Another business group is looking to add this functionality to email invoices. The two groups share the same invoice template .rtf and data definition and hence, the same bursting control file. The only thing that will be different is the Subject and Body of the email.<br /><br />We have customized AR Invoice Print programs to allow bursting with the initial business group. We will add another parameter to the program with value set for each of the two business groups to allow for separate email content.<br /><br />Sorry for the long comment but my question is: What is the most efficient way to code for two separate email contents within the same bursting control file? One approach might be to pass variables to the control file for email Subject and Body rather than hard coding.<br /><br />Any feedback would be appreciated!

    0 Like
    Short URL:

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Apr 2016  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
      1  2  3
  4  5  6  7  8  910
11121314151617
1819202122
 

Enquire For Training

LOGIN