How to Use XML Publisher to Generate Oracle Reports in Excel and PDF

In the past, Oracle E-Business Suite Customers seldom used outputs of the seeded Oracle reports because they were unfriendly, and frankly, hard to use. Unfriendly because the generated output was always fixed width courier only font, contained no graphics, and could only be in black and white. Hard to use because the only output was text. In the business world, we all know how important the final output is and text only is not even an option. Businesses require PDF and XLS output that support tables, charts, graphics, color, etc.

Today, Oracle offers a solution that enables our Oracle E-Business Suite Customers to turn the once unfriendly Oracle seeded reports into PDF and XLS outputs of color, graphics, and tables. The solution is XML Publisher. XML Publisher is a java based reporting tool that is bundled for free within the technology stack of the Oracle E-Business Suite. The concept is similar to that of “mail-merge” where the data and template are maintained separately until the two are “married” to generate the desired document. XML Publisher separates a report’s data and layout component into two manageable pieces while it supports the desired outputs of PDF, HTML, XLS and RTF. The prerequisites to use XML Publisher include:

  • XML Data
  • Report Template
  • Registration of Data Definition and Template at XML Publisher

How does XML Publisher leverage on Oracle seeded reports? An Oracle seeded report is a report definition file that integrates both the data query and the report layout into one file. XML Publisher will use Oracle Reports for only the data query portion and will ignore the defined report layout. This will fulfill one of XML Publisher’s prerequisites: XML Data. So the question is, how do you set up the Oracle system to only use the data query portion of the Oracle report?

  • Log into Oracle with System Administrator Responsibility
  • Navigate to > Concurrent > Program > Define
  • Search for the desired Oracle Report
  • Change the Output Format from the default ‘Text’ to ‘XML’
  • Take special note of the Program Short Name (you’ll need it later to register the data at XML Publisher)
CM

How does it benefit Oracle E-Business Suite customers? XML Publisher provides full control of the layout and look and feel of the report to the Customers. This means the Customer will fulfill the second prerequisite, the Report Layout. Customers will leverage on familiar tools like Microsoft Word and Adobe Acrobat to create the report layout with reference to the XML Data Tags. So the question is, how does the Customer create the Report Layout? PDF Forms template are intended for Customers that require a fixed look and feel such as completed IRS forms and are created in Adobe Acrobat. RTF templates are intended for all other purposes and are created in Microsoft Word. In this example, we’ll go over how to create an RTF Template.To create an RTF Template, you’ll want to download the XML Publisher Desktop Utility and its prerequisite Java Runtime Environment. This enables you to create and test your Report Template in a localized environment, your computer, before registering it at Oracle XML Publisher. So where to download the XML Publisher Desktop Utility?

  • Navigate to Oracle eDelivery Site
  • Select Product Pack: Oracle Application Server Products
  • Select Platform: MS 32 bit
  • Click on the GO Button
  • Select and Download Oracle XML Publisher Release 5.6.2 Media Pack for Microsoft Windows
desktop_dl

desktop_dl_option

The XML Publisher Desktop Utility is a plug-in to Microsoft Word. To create the RTF template, you must first load the XML Data File by clicking on the Data button and selecting Load XML Data. To get a sample XML data file, you can run the Oracle seeded report and download the output. Once the data file is loaded, you can make references to the XML Data elements. For example, if you want to reference the ‘Project_Number’ XML Data Element, the format you would type would be … The common used tags include:

  • for-each | end for-each
  • if | end if
  • choose | when | end when | otherwise | end otherwise | end choose

Alternatively, you can use the Desktop Wizard functionality by clicking the Insert button and selecting Table/Form to drag and drop the desired XML Data Elements into the Template window. This will automatically generate a table for you.

You can test your RTF template with the loaded XML Data File by click on the Preview button and selecting one of the supported output formats. Once satisfied with the created RTF Template, the final steps is to register both the Data Definition and the Template at XML Publisher. The steps are:

Register the Data Definition:

  • Log into Oracle with XML Publisher Administrator responsibility
  • Navigate to > Home > Data Definitions
  • Click on the Create Data Definition button
  • The Code must be the Concurrent Program Shortname from above
XDO_data

Register the Template

  • From Data Definitions, Navigate to > Templates
  • Click on the Create Template button
  • The Data Definition value should be the Data Definition you registered above
XDO_template

When the Customer runs this configured report through the Concurrent Manager, the Customer will follow the same steps to run the standard Oracle Report by selecting the report in the Single Request Screen and entering the desired run parameters. Now, the Customer has one additional option to select the desired output format of the report. From the Single Request Screen, click on the Options button and select the desired output.

CM_optionscreen

112 Thoughts on “How to Use XML Publisher to Generate Oracle Reports in Excel and PDF

  1. Rajesh on January 31, 2007 at 2:52 am said:

    Hi,

    Thank you. This article helped me to understand how to attach the xml template and the existing oracle report.

    thanks
    rajesh

  2. Charina on February 14, 2007 at 8:31 am said:

    Hello,

    Thanks for the informative post. A long awaited reprieve from overlapping frames on my part!

    Cheers,
    Charina

  3. Ravinder on February 27, 2007 at 11:01 am said:

    Thanks alot that worked. I was not able to get a Excel Output from XML Publisher through APPS, your Post here helped me do that.

    In case the Output is not opening in EXCEL set the Profile Option “Viewer: Application for HTML” as “Browser” , you can see the following Post “How To Change the Report Viewer”

    :) ravisayal

  4. MURLI on March 15, 2007 at 1:19 am said:

    hi,
    this document is very informative about XML Publisher
    THANKS

  5. hi

    Please let me know how to do a report from the scratch in XML PUBLISHER

    Do I have to do it in Reports 6i and then go that way??

    please e-mail please

    (not a seeded report).

  6. Nancy on April 4, 2007 at 5:30 pm said:

    Hi Pramod,

    You can:

    1) create a pl/sql and register as a concurrent program. then perform the same steps as highlighted on the blog. That is flip the output to generate XML, create an RTF template and register the data and the template at XML Publisher. you can then run the report using the concurrent manager.

    2) Or you can leverage on the data templates to create your XML Publisher report. I’m currently working on a project to use data templates and once I do, I will make another post.

    Let me know if you have other questions.

    Thanks,

    Nancy

  7. Pramod on April 4, 2007 at 5:31 pm said:

    Hi,

    Thnx for that response.

    So you are asking me to create a package/procedure which generates XML and register it as
    program in oracle applications and go that way.

    1) Create a pl/sql and register as a concurrent program. Then perform the same steps as highlighted on the blog. That is flip the output to generate XML, create an RTF template and register the data and the template at XML Publisher. You can then run the report using the concurrent manager.

    Pramod

  8. Nancy on April 4, 2007 at 5:34 pm said:

    Hi Pramod,

    Yes, that is correct. Let me know if you have any problems.

    Nancy.

  9. Its Excellent !

  10. Lavina on April 17, 2007 at 7:31 am said:

    Hi,

    I have an already existing pdf generated by a third part tool for a Purchase Order report.
    What is the best way to use this pdf as a template in XML Publisher to generate the pdf?

    1) I have added placeholders on the pdf with XML tags.I have created the data definition, added .xsd and .xml files.Created a template in XML Publisher, uploaded my pdf template, mapped the markup colums with the xml file.However when running the XML Publisher program, the ouput showed the template as it was…the xml data did not get loaded onto the template…
    Is this the correct way to handle a pdf template?
    Is this supported in Release 11.5.10.2CU?

    2) Is there anyway I can convert my pdf to an rtf template without losing the formatting?Or is there anyway that I could use the XML desktop utility to perform this task?

    I would really appreciate if you could help me out with this.

    Thanks

  11. anuradha on April 17, 2007 at 11:42 pm said:

    Please let me know how to do a report with more Parameters from the scratch in XML PUBLISHER (Not using Oracle Applications)

  12. hanish on April 24, 2007 at 10:16 am said:

    How to get the report parameters in the XML file?
    Or how to define tags which can refer the parameters passed to an RDF report.

    Thanks
    Hanish

  13. Is there an EXCEL plugin yet (to allow creation of templates like there is for WORD)?

  14. Nancy on June 26, 2007 at 7:38 am said:

    Hi Bob,
    Excel Analyzer is available but only in the standalone 5.6.2, not with Apps.
    - Nancy.

  15. vijay on July 16, 2007 at 1:02 am said:

    Hi all,

    In a request set, in that there are 2 concurrent Progrmas 2 Reports are defined.

    1st report report report to get the PDF format layout XML Template is defined.
    But it is not taking the Template.
    If we run the same report as a single request then it is taking the Template and working fine,
    But as a request it is not taking the XML template.
    and
    the secound one is the Standard report, in this the Layout is XML template is defined.it is working fine.

    i am unable to get the Solution.

  16. Omkar on July 18, 2007 at 4:54 am said:

    Hi,
    Created report with XML output and registered Data Definition , Template.
    But Im unable to see the output while run the report through SRS and while seeing the preview it throws error.

    If any body give the solution it is lot of helpful me.

    Thanks & Regds
    Omkar

  17. Nancy on July 18, 2007 at 3:51 pm said:

    Hi Omkar,
    What error do you receive? What template type do you use? If an rtf template, did you first build it in word and use the xml publisher desktop utility to confirm no errors were thrown before you registered the template at xml publisher?
    Thanks,
    - Nancy.

  18. Nancy on July 18, 2007 at 3:56 pm said:

    Hi Vijay,
    Are you saying:
    1) concurrent program 1
    * works fine with the pdf forms template only as a single request?
    * does not work in a request set? (can you tell me how you set up your request set?)

    2) concurrent program 2
    * this works fine as a single request and in a request set?
    * what type of template is this? RTF or PDF Forms?

    general question: what version of xml publisher are you on?

    Thanks,
    - Nancy.

  19. Omkar on July 19, 2007 at 12:22 am said:

    hi Nancy,
    Thank you for response. These are the steps followed.

    1. Created query through Report Builder and saved as XXCNREC02.rdf

    2. Registered Concurrent Program Executable and Define as XML output.
    Executable : XXCNREC02
    Short Name : XXCNREC02
    Application: Application Object Library
    Execution Method : Oracle Reports
    Execution File Name : XXCNREC02

    Definition window :

    Program : Received/Consumption Detailed Report
    Executable & Short Name : XXCNREC02
    Method : Oracle Reports
    Output : XML

    3. Attached to the request group i.e., ‘SYSTEM ADMINISTRATOR REPORTS’.

    4. Run through SRS , got output then save as XML type in local drive
    ie., XXCNREC02_25678.xml

    5. Through MS Word, Load XML Data and selected XML type file which is created in step 4.

    6. Insert /Table Form then created layout.

    7. Using ‘XML Publishing Administrator’ responsibility

    Data Definition-> Create Data Definition

    Name : Received/Consumption Details
    Application : Application Object Library
    Code : XXCNREC02
    Start Date : 17-Jul-07

    Templates -> Create Template

    Name : Received/Consumption Details
    Code : XXCNREC02
    Application : Application Object Library
    Data Definition: Received/Consumption Details
    Type : RTF

    File : Received/Consumption Details
    Language : English
    Territory : India

    8. Run the report through SRS with System Administrator Responsibility.
    select Upon Completion – > Options button – > Preview then
    shows error.

    Thanks
    Omkar

  20. Marian on July 24, 2007 at 1:49 pm said:

    Omkar,

    After finishing steps 5 and 6, did you manage to successfully preview your .rtf template in MS Word?

    Marian

  21. Anabil on July 24, 2007 at 8:32 pm said:

    Hi all,
    How can i use page break inside the XML publisher report?I have made a report through XML publisher behind which there is a RDF.There are 2 sections in my report,Summary and Detail.I need to give a page break after the Summary section is over.In RDF i can give this but through XML how to do that?
    Please help me…

    Many thanks

  22. Anil Lohan on July 25, 2007 at 1:57 am said:

    I have installed the XML Publisher on my local machine. I want to create the XML template from scratch. Please let me know what all the thing i need to do. i.e how to create XML file.

  23. Nancy on July 25, 2007 at 3:45 pm said:

    Hi Omkar,
    Can you send me your sample XML Data output and your RTF template? I’d like to take a look at it.
    Thanks,
    - Nancy.

  24. Nancy on July 25, 2007 at 3:49 pm said:

    Hi Anabil,
    XML Publisher will recognize page breaks made in MS Word. This means, XML Publisher supports a number of native MS Word features. To do this in MS Word: > Insert > Break. Or you can write an explicit page break with .
    - Nancy.

  25. Nancy on July 25, 2007 at 3:50 pm said:

    use the ?split-by-page-break? tag.

  26. Nancy on July 25, 2007 at 3:52 pm said:

    Hi Anil,
    Please start with the XML Publisher user’s guide. You can find it on otn.oracle.com.
    Thanks,
    - Nancy.

  27. Anil Lohan on July 25, 2007 at 10:12 pm said:

    Hi Nancy,
    Thanks a lot for your response.
    I have downloaded the XML publisher Oracle XML Publisher Release 5.6.2 Media Pack for Microsoft Windows as mentioned above and instaled it on my local machine. I lgged with the user admin, but i am not able to find the option Data definition and the template tabs as shown above in the screenshot. Can you suggest me how to enable the data definiton and template tabs.

    Thanks in advance.

  28. Hi,

    I have designed the XML template in .rtf format using MS Word Desktop plugins and which gives me the output as PDF. But now my question is How can i see the same output in Excel format?

    Anu

  29. Raj Arukonda on July 26, 2007 at 5:21 pm said:

    Hi,

    I have an already existing pdf generated by a third part tool.
    What is the best way to use this pdf as a template in XML Publisher to generate the pdf?

    I would really appreciate if you could help me out with this.

    Thanks
    Raj

  30. Hi,

    I’m creating 2 reports using RTF templates and their output type is PDF. I need to merge these 2 reports using App Engine / peoplecode. Can someone please give me a samplecode on how to do this? My code is not working. This is what I have coded in AE/pplcode action:

    import PSXP_ENGINE:*;

    &oPDFMerger = create PSXP_ENGINE:PDFMerger();
    &sErr = “”;
    &sFilesArray = CreateArray(&sTemplateId);
    &sFilesArray.Push(&sTemplateId2);
    &bResult = &oPDFMerger.mergePDFs(&sFilesArray, &sOutputFile, &sErr);

    Thanks!

  31. madhavi on August 1, 2007 at 10:18 pm said:

    I suppose to create a xml report using xml publisher.
    i have gone through ur article and doing step by step.
    i have downloaded seeded report output and save it as xml datafile.and downloaded xml desktop utility.but,i couldn’t find where to load data and how to create rtf template.can u pls guide me.urgently needed help.
    i am suffering like anything by not getting the process.
    can u pls…………..urgent
    thx in advance

  32. madhavi on August 2, 2007 at 4:40 am said:

    hi,
    I am deveolping xml report using xml publisher.downloaded xml pub desktop utility
    while loading xml data file unable to findout the options load data and template builder options.
    so unable to load data.
    immedaite help appriciate.
    thx in advance
    thx
    madhavi

  33. Good work Nancy

    Regards
    Habib

  34. Srinivas on August 6, 2007 at 5:14 pm said:

    Hi All,
    I have created a Data Definition & Template in XML Publisher, but I am unable to view or add the Template Name Under Layout in Submit Request, Options.
    any help would be appriciated
    Thanks
    Srinivas

  35. madhavi on August 8, 2007 at 8:36 pm said:

    Hi,
    I have created a template and data definition and registred in the template manager.then can i get any help regarding registration of a report to run a report.not getting idea for further approach.urgent help needed.
    ths in advance

  36. madhavi on August 8, 2007 at 8:36 pm said:

    Hi,
    I have created a template and data definition and registred in the template manager.then can i get any help regarding registration of a report to run a report.not getting idea for further approach.urgent help needed.
    thx in advance
    madhavi

  37. madhavi on August 8, 2007 at 8:39 pm said:

    Hi,
    i need to develop xml datafile for large chunks of data.can u provide me the method to write a xml program to load large volume of data.appriciated for immediate help.can anyone pls………………………..
    thx in advance

  38. madhavi on August 8, 2007 at 10:33 pm said:

    hi,
    can u pls send me the xml programming user guide
    which is more appropriate fro me to write a program using tags to load large volume of data.
    help needed urgently.i am new to xml

  39. ramkumar on August 9, 2007 at 1:20 am said:

    hi madhavi u want XML Publisher user guide.

    regards
    Ram

  40. madhavi on August 9, 2007 at 3:47 am said:

    hi ram,
    i need xml programming user guide not publisher user guide for reference to create xml data file
    thx
    madhavi

  41. madhavi on August 9, 2007 at 11:58 pm said:

    Hi Nancy,
    can u pls help me out how to create the concurrent pgm to register a xml report.
    i have created xml data file,and got the rtf file..
    my task is to develop xml report using xml publisher not from report builder.
    can u pls help me out in this regard.
    help needs asap
    TIA
    madhavi

  42. Swapana on August 10, 2007 at 1:10 pm said:

    Hi,
    I have a XML Report names”Print XML Packing Slip”which is already there .I just have to add one telephone number field to the existing Report.Please let me know how do I proceed.

    Thanks
    Swapana

  43. Hi Srinivas,
    Did you make sure you set the concurrent program to generate XML? Did you make sure the concurrent program shortname matches the data definition code you created?
    Thanks,
    - Nancy.

  44. Hi Madhavi,
    1) Since you’re not leveraging on the seeded rdf files, you can create a procedure to generate your xml for you. In this procedure you have your select statement and your writelines to generate the xml.

    2) Create your executable for #1 in Oracle

    3) Create your concurrent program for #2 in Oracle

    4) Then do everything like outlined in this blog.

    Write me if you want an example procedure.
    - Nancy.

  45. madhavi on August 12, 2007 at 8:44 pm said:

    Hi Nancy,
    Thx for ur response.
    Can u pls send me the example procedure with xml file so that i can go ahead with my application.
    Thx
    madhavi

  46. madhavi on August 12, 2007 at 8:46 pm said:

    Hi swapna,
    If u r working on xml publisher reports can u pls send me the sample report with necessary steps and screenshots for reference.
    NOW I HAVE JUST STARTED WORKING ON R12 XML REPORTS.
    THX IN ADVANCE
    Madhavi

  47. First off, I have to say your blog is very very informative. Now my question is, is it possible to find out the actual query being executed by a report? I was to use that query in say TOAD, for example?

  48. chidinma on September 7, 2007 at 2:30 pm said:

    Hi nancy, thank for the info. Pls how do i pass a parameter from the oracle report into the xml template. i.e, what tags do i use e.g , or do i have to make some adjustments to the report level?

  49. Praburam on September 12, 2007 at 6:43 am said:

    Hi,

    I have issue when i preview the output in MS word.

    I didnt get the same output format what i developed in the MS word RTF file.I got the fields which is some where in the pdf,excel,html format.I dont knw why all fields are not in correcy format whereas in my RTF(MSword) File that all headers and lines information are prefectly in right place but when i do preview i got wrost format output.

    please guide what should i do to solve this issue,even i tried in metalink i didnt get it.I hope that any one will give solution to close this issue.

    Awaiting solution very soon,its urgent for me.

    regards
    prabu

  50. Hi every one,
    Please very urgent
    I had attached image in my RTF,I didnt write any coding for tha image and then i attached the RTF in the template and so..on..

    After i ran the currencurent program,I didnt get that image when i see the output.I dont knw why that image which i have in RTF is not coming when i see the final output.
    please send the details if any xml tags that i should include for that particular image.
    with regards
    prabu

  51. Prabu -

    Make sure you followed these steps in RTF to display image in Apps after your run the program.

    1)Insert > picture > from file > FNDSSCORP.gif
    2) Right Click on picture > Format Picture
    3) Enter as follows in the Web tab of Format Picture.

    url:{‘${OA_MEDIA}/FNDSSCORP.gif’}

    This will works for you.

    Regards,
    Balu

  52. Balu,

    k thank you for the information,i will try it and give reply to you.And I have image in the format jpg whether it will work?… and also i copied the image from my local machine and then i paste into the template which i designed.
    How could i follow the path like insert->picture->from file.
    And in the web,u gave one xml tag,in that what is (OA_MEDIA),is it function in xml?..

  53. Prabu,

    Yes it will for jpg. In RTF template (in word), you can find the path. And, regarding OA_MEDIA (it’s not XML function). $OA_MEDIA means
    $JAVA_TOP/oracle/apps/media (this is unix directory)

  54. Balu,

    I am new to XML Pubilisher Administrator.I dont knw where should i place my RTF file whether in my local machine or server custom top.

    When i try to attach the RTF file in template tab(XML Publisher Administrator),I am getting confuse to give the file patch for the RTF file.

    please guide and give ur reply very soon.
    And also if possible give ur frequently using mail id.

    Regards
    prabu

  55. Is there any way we can set default output format for a report without going to options screen and changing output format. I have a report which user wants in excel (always), It would be nice if there is a way to tell apps that ouput for this report is excel and not pdf.

    Thanks

  56. Ravinder on October 1, 2007 at 5:51 am said:

    Do we need to upload rtf file to apps server? If yes, in which directory?

  57. sushma on October 8, 2007 at 10:10 am said:

    hi
    i am developing purchase order report in XML Publisher and i have requirement like
    ‘CANCELLED’ records should display in color ‘RED’
    ‘REJECTED’ records should display in color ‘GREEN’
    how can i get this..
    thanx

  58. Hi

    How to create a Exel output using the XML Publisher

    Gopal

  59. Hello

    I need to increase the size of the address field for existing report. How can I do that. I downloaded the XML template and opened in MS Word, but it is not allowing me to edit the field size. I right click on the address field changed to max length to Unlimited but it is still keeping the old query and missing some characters.

    Should I recreate the template after I modify the Oracle Reports Query ?

    Thanks in advance for your help.

    Monic.

  60. I let Nancy provide more details but I assume, with the seeded query, you are limited to the size as defined in the query. I also think it would be best to define a new template if you created a custom query.

  61. Thanks Marian, I will wait for Nancy’s response. If I need to create new template how do I do. I am very new to this XML. Right now I have Oracle Report (RDF) is registered with XML output but when I run SRS the output is showing in PDF and tried to save as XML it didn’t work. Any idea of how do I create new template with this kind of situation.

    Thanks,
    Monic

  62. Hi,

    Whenever i try to publish any XML report with Pie or Bar Graphs through Oracle Apps, it thros an error saying..

    APPLLCSP Environment Variable set to :

    XML_REPORTS_XENVIRONMENT is :
    /u02/applvis/visora/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb

    XENVIRONMENT is set to /u02/applvis/visora/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb

    Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
    American_America.UTF8

    ‘.,’

    Spawned Process 12166
    REP-3000: Internal error starting Oracle Toolkit.

    while the say XML works well if i put some tables or text in my report.

    Can anyone please help me on this.
    Its Urgent.

    Regards,
    Vikas

  63. Anusha on October 25, 2007 at 7:18 am said:

    HI,
    I am very new to xml publisher .
    I had basic questions like when I biud report in Xml not in reports builder what is the executable method .If it is java concurrent program what willbe execution file name.Plz help me out as soon as u can.

    Thanks,
    Anusha

  64. Nancy had provided a great XML Publisher overview and a good start for learning the tool. However, it was never meant to replace other learning channels like Oracle University’s training courses, user guides, white papers, OAUG presentations, etc. I encourage everyone new the the XML publisher to first do do your homework and study the resources before you try to use the tool.

  65. Anusha on October 25, 2007 at 9:24 am said:

    HI,

    cAN ANY ONE LET ME KNOW OUT TO GET THIS OF THIS ERROR OR WARNING

    Executing request completion options…

    +————- 1) PUBLISH ————-+
    Beginning post-processing of request 2046975 on node AUOHSSCHL02 at 25-OCT-2007 12:00:15.
    Post-processing of request 2046975 failed at 25-OCT-2007 12:02:15 with the error message:
    The Output Post-processor is running but has not picked up this request.
    No further attempts will be made to post-process this request, and the request will be marked
    with Warning status.
    Setting the profile option Concurrent: OPP Response Timeout to a higher value may be necessary.
    +————————————–+

  66. Hi,
    You should know basic funda of XML publisher.
    For any XML report the backend data feed is standard oracle report. In XML publsiher we will create only template for desired output on top of standard report.

    1) Develop standard report(RDF) and register it as concurrent program. Select the output type for this report as XML.

    2) Develop XML template for report output( the look n feel) using XML publisher add-on tool for word and register it in XML publisher ( where you have to assign it with the concurrent program name). Here you can select the desired output format (PDF, RTF, whatever..)

    Now when you execute the concurrent program, it will kick off the XML template and generate the output file.

    ** Auto kick off of this XML template is only avail from 11.5.10.2 I guess, with older versions and with some concurrent programs you may have to explicitly invoke the XML publisher template by API coding in AFTER_REPORT trigger.

  67. mallikarjun on November 19, 2007 at 5:46 am said:

    brief description about the tags which we are used in xml publisher : foreach|end foreach,
    if|end if, choose|when|end when|end choose

  68. mallikarjun on November 19, 2007 at 5:48 am said:

    how to get the report parameters in the xml file?
    or how to define tags which can refer the parameters passed to an RDF report.

  69. mallikarjun on November 19, 2007 at 5:50 am said:

    I had attached image in my RTF,I didnt write any coding for tha image and then i attached the RTF in the template and so..on..

    After i ran the currencurent program,I didnt get that image when i see the output.I dont knw why that image which i have in RTF is not coming when i see the final output.
    please send the details if any xml tags that i should include for that particular image.
    with regards

  70. mallikarjun on November 19, 2007 at 5:51 am said:

    How can i use page break inside the XML publisher report?I have made a report through XML publisher behind which there is a RDF.There are 2 sections in my report,Summary and Detail.I need to give a page break after the Summary section is over.In RDF i can give this but through XML how to do that?
    Please help me…

  71. sunil sane on November 22, 2007 at 8:34 pm said:

    Hi,
    Can any one solve this warning status, while running the xml concurrent program, actually it was generating the xml output but its not generating the pdf output once after attaching the template instead its showing some warning status, could any one please help me…?

  72. Govardhan on December 3, 2007 at 10:56 pm said:

    Hi,

    i am govi,Actually when we are Creating XML Reports through Reports 10g,go to data model create query then save as .xml,after that don’t need to go for oracle application frontend, directly open MS-word and load Xml data and develop report in word like this we can do it or not,pls let me know can i do it or not

    Regards
    Govardhan

  73. Hi Nancy
    C’est moi!
    Great article – for those of you posting questions and wanting more info. Some Oracle reosurces:
    Forum – http://forums.oracle.com/forums/forum.jspa?forumID=245
    Blog – http://blogs.oracle.com/xmlpublisher
    Home Page – http://www.oracle.com/technology/products/xml-publisher/index.html

    You’ll find me lurking on the first two and writing for the last two :o )

  74. Hi,

    When I publish my RDF report using XML Publisher, the lexical parameters (the one with ‘&’ in reports and the format triggers) are not displayed(ie, the values not displayed from the DB). Is anyone handled this with alternative solution, pls. guide me.

    Thanks,
    Mani

  75. Please let me know how to view output in Excel? I can run suceesfully to out in PDF format. Do we need to create diff kind of template for excel ?Kindly reply on urgen basis

  76. I am not able to get the Output in Excel.
    I have created RTF for Template and Rdf for Report. I want the Output in Excel. I am able to get the Output in pdf, html, rtf but not in Excel.

    The Error I am getting after running the report is :

    XML_REPORTS_XENVIRONMENT is :
    /apps1/applvis/visora/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb

    XENVIRONMENT is set to /apps1/applvis/visora/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb

    Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
    American_America.UTF8

    ‘.,’

    Spawned Process 7346
    REP-3000: Internal error starting Oracle Toolkit.

    Need help..

    Anuj

  77. Hi,
    I have changed output from PDF to EXCEL and it works fine. Is it possible to show first part of report onder first tab (in EXCEL) and second part of report onder another tab (in EXCEL).
    Now I got just one tab called FNDWRR. Is it possible to make 2 tabs and split output onder two tabs? Also is it possible to change name of tab(s)?
    Best regards, Zoran

  78. Divya on March 3, 2008 at 3:15 am said:

    HI,
    I am able to get the XML output in Excel, but there is an image in the Rtf which is not getting displayed in the Excel outptut.
    Thanks,
    Divya

  79. swapna on March 3, 2008 at 7:53 am said:

    Hi,
    Is it possible to get the xml publisher report output in excel or comma seperated file depending on the user’s wish

  80. Divya on March 3, 2008 at 10:10 pm said:

    Hi Swapna,
    We can get the XMLP report output in excel.
    I am not sure about comma seperated file.

    To get the output in Excel..
    Before submitting the request, click on the Options button in the concurrent program submit window and select Excel in the format. Submit the request.

    Divya

  81. Hi,

    I am new to XML Publisher Reports.I need solution for one of my report which iam working now. I have a RTF which is fixed for 12 records per page.This lines per page got fixed by declaring one variable.I need output like in first page ineed 12 records and rest of the pages ineed 14 Records per page.Is this possible to get output like this?

  82. salp on April 4, 2008 at 7:39 am said:

    when I set up XLM in Oracle, only 1 user at a time can submit a request. this is a huge problem. how do I change it so that each person can run a report without interfering with another. Also, the size of the file behind the scenes when a use selects excel is large. how can I make it smaller? Could it be too many tags?

  83. madhu on April 6, 2008 at 11:47 am said:

    I have one problem with one of my XML report. I have given condition in template .Because of this condition it is giving blank page in output when the inner group count is zero.I want to skip the page which has inner group count zero.Is it possible to skip the page when ever inner group count is ZERO?
    Is there any other solution to suppress this bank page?
    Thanks,
    madhu.

  84. dear all ..
    i have this error

    +—————————–
    | Starting concurrent program execution…
    +—————————–

    Routine FDPREP cannot read the file e:\oracle\testappl\per\11.5.0\reports\US\ADDRESSES.rep.

    Check if the file exists under correct product directory.

    Check if the person who started the Concurrent Manager has read privileges on the direct
    Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 283418.

    Review your concurrent request log and/or report output file for more detailed information.

    ——–

    can any body help me

  85. Radhika on May 20, 2008 at 2:09 am said:

    Hi,
    I have rtf template and xml template. I’m getting pdf output, i want that output in excel, tried by changing the viewer options format as ‘EXCEL’ before submitting the request. No data found coming. Any help ????
    Tks
    Radhika

  86. Hi,

    A quick question. Is the Oracle BI Publisher, which is a part of OBIEE, same as the XML Publisher?

    Thanks
    Rupa

  87. Hi,

    Just another query. How can the R12 XML publisher be interfaced to OBIEE?

    Do have any docs that gives a better understanding of this?

    thanks

  88. Sorry Rupa, I am not familiar with the integration of XML Publisher and OBIEE. Perhaps other experts can chime in…

  89. Could some one please help me. As i am not able to generate the putput of a report in XML format. Even the output format is set to XML. Do i need to update the any profile options or set up something.

    Regds
    sri

  90. Diptiman Roy on January 15, 2009 at 3:23 am said:

    This document is very useful to me. Thanks !!!!!!!!!

  91. Harsha on January 16, 2009 at 4:55 am said:

    I have added new query for the data model for a .rdf report. When I extract the report output which has xml as output, I’m not able to get the new query values as XML Elements in the output.! any help is appreciated. Thanks in Advance

  92. Dear All,
    Can you suggest me. I have one Arabic report employees monthly salary. i developed this report6i output is generating text format. In text format we can’t change Bold or Underline so i want to convert to Pdf format. I am tring to use xml publisher but after competing the process
    like data defination and create Templete
    when i am request the report output is not comming
    it was not accepting arabic data.

  93. hi
    this is anjan i developed one rtf file in my system. In real tiem where i can store my developed and succeed .rtf file for future references is there any specified folder are there pls give me info..

  94. Hi all,

    I’ve a requirement in XML Publisher reports wherein i need to show 10 records per page.Suppose my XML Query fetches 50 records i need to show 10 records in 5 pages .With what function can i implement this in the rtf file?
    Can anyone pls suggest ?

  95. Bikram on March 1, 2009 at 9:06 pm said:

    I have a requirement to print the page total at the end of each page. I have used carry-forward for that with “exceptlast” condition. But if there is only one page then the page total should not print. Can anyone please suggest me what to do?

    Thanks in advance!
    Bikram

  96. sandeep on March 7, 2009 at 8:38 am said:

    Hi Every one,

    i ran xml report in Excel output working fine and its giving output also but the problem is Text Number is converting as number
    for example in data there is column item 0192902930
    when i open xml report in excel 0192902930 converting as number 192902930 it is missing the zero prefix. is there any to restrict but when we submit the report in PDF format it working fine only in excel its giving problem
    Thanks
    Sandeep.Y

  97. Hi i am not finding the last step :Concurrent Manager ;
    is it from system administrator?
    And then what to select to open the last screen?
    Thanks in advance

  98. Hi Sandeep,

    As you are saying that you are not able to get the output correctly. It is the case with the EXCEL.In EXCEL if you give the 0192902930 it is taken as 192902930. So please check how exactly u can publish the data. I hope this might be a solution Please try enclosing the value in single Quotes like ’0192902930′ instead of 0192902930.

    I hope this should work fine

    Thanks and Regards
    Raghu

  99. Husen on March 25, 2009 at 4:26 am said:

    I’ve a requirement in XML Publisher reports where in i need to show 10 records per page.Suppose my XML Query fetches 50 records i need to show 10 records in 5 pages .With what function can i implement this in the rtf file?

    Regards,
    Husenaiah

  100. Shiva on April 9, 2009 at 2:35 am said:

    Hi,
    i am working on XML publisher.i have created template for Purchase order report.if a particular PO which runs it to mulitple page..then my template will show output continously with out page break..
    2nd Question:
    i need some fields to be shown at the 2nd page of that PO ..how can i do this in XML …in report 6i we can do it using format triggers …

  101. Mirjam on April 20, 2009 at 5:03 pm said:

    Good day!
    I am just statarting using oracle 10g and I want to know how to extract files from oracle to excel 2003 in which the records will not split into multiple sheet, I just want it on only one(1) sheet…

  102. Mirjam on April 20, 2009 at 5:09 pm said:

    Good day!
    I am just starting using oracle 10g and I want to know how to extract files from oracle to excel 2003 in which the records will not split into multiple sheet, I just want it on only one(1) sheet…

  103. Trupti on May 7, 2009 at 4:55 am said:

    How to change the application name of data definition in XML Publisher

  104. RANJITH.K on May 12, 2009 at 10:32 pm said:

    hI,

    I have developed a XML report . when I am running the report its o/p is opening in PDF.
    If I am manually change the option from SRS window as EXcell I am getting the o/p in excell also.
    My requirement is to make SRS window option as Excell as a default at runtime. how it is possible.
    Anybody can help?

  105. Neelima on May 14, 2009 at 3:04 am said:

    Hello,
    I am developing a XML report with PL/SQL Procedure as a source. While registering the concurrent program we changed the output stype as XML. To generate the XML file, i am submitting the concurrent program. When program completed normal and i check the output file, it is giving me the error-

    The XML page cannot be displayed

    Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later.

    ——————————————————————————–

    Invalid at the top level of the document. Error processing resource ‘https://***/OA_CGI/FNDWRR.exe?temp_…

    Any inputs are highly appreciated

  106. Mary on May 25, 2009 at 6:11 am said:

    Hi:
    This training material is Great. I want to practice but I could not find ‘Oracle Application Server Product’? Please tell me another way to download.
    Thanks

  107. Tammy on June 19, 2009 at 5:52 am said:

    Trying to find information on anyone that has created Customer Statements and/or Dunning Letters in XML.

  108. Shiva on June 30, 2009 at 5:11 am said:

    Dear All,
    Hi, i do every thing base on above text and i can see preview in template folder, but when i run program my request will be completed with warning, so there is no output. i send error text in below, please help me.

    Beginning post-processing of request 4375475 on node ORAVISSBC at 30-JUN-2009 17:19:21.
    Post-processing of request 4375475 failed at 30-JUN-2009 17:36:01 with the error message:
    The Output Post-processor is running but has not picked up this request.
    No further attempts will be made to post-process this request, and the request will be marked
    with Warning status.
    Setting the profile option Concurrent: OPP Response Timeout to a higher value may be necessary.

  109. hi,
    I developed one chart/graph report,it is generating graph when i run it in my system but when i run it through it in E business application,it is not generating any graph but when i attach the sample data in data sample at data definition and click on the preview at template,graph is generating fine.
    Can anyone please suggest where could be the problem or do it required need to do some setup?

  110. Have you had anu success registering multiple rtf template against the same data definition with the same language and territory?

  111. Hi we are using Oracle 12i, our requirement is to give report output in English or Arabic based on the language selected in the login page. We are using RDF-XML-RTF wa to create report. Currently English report comes correctly, when we try arabic for arabic data revers ‘?’ appears. Please give step-by-step instruction on how to create arabic report

  112. Thank you for your interest and comments. Please refer to Oracle BI Publisher forum with any future inquiries:

    http://forums.oracle.com/forums/forum.jspa?forumID=245&start=0

Post Navigation