The Feature

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

December 31, 2006 on 5:49 pm | by Nancy Chung | In How To Guides | |

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)

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_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:

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

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

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.

online prescription tramadol

112 Comments

Hi,

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

thanks
rajesh

Comment by Rajesh — January 31, 2007 #
Hello,

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

Cheers,
Charina

Comment by Charina — February 14, 2007 #
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

Comment by Ravinder — February 27, 2007 #
hi,
this document is very informative about XML Publisher
THANKS

Comment by MURLI — March 15, 2007 #
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).

Comment by pramod — April 4, 2007 #
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

Comment by Nancy — April 4, 2007 #
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

Comment by Pramod — April 4, 2007 #
Hi Pramod,

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

Nancy.

Comment by Nancy — April 4, 2007 #
Its Excellent !

Comment by Siva — April 10, 2007 #
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

Comment by Lavina — April 17, 2007 #
Please let me know how to do a report with more Parameters from the scratch in XML PUBLISHER (Not using Oracle Applications)

Comment by anuradha — April 17, 2007 #
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

Comment by hanish — April 24, 2007 #
Is there an EXCEL plugin yet (to allow creation of templates like there is for WORD)?

Comment by Bob — June 22, 2007 #
Hi Bob,
Excel Analyzer is available but only in the standalone 5.6.2, not with Apps.
- Nancy.

Comment by Nancy — June 26, 2007 #
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.

Comment by vijay — July 16, 2007 #
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

Comment by Omkar — July 18, 2007 #
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.

Comment by Nancy — July 18, 2007 #
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.

Comment by Nancy — July 18, 2007 #
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

Comment by Omkar — July 19, 2007 #
Omkar,

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

Marian

Comment by Marian — July 24, 2007 #
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

Comment by Anabil — July 24, 2007 #
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.

Comment by Anil Lohan — July 25, 2007 #
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.

Comment by Nancy — July 25, 2007 #
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.

Comment by Nancy — July 25, 2007 #
use the ?split-by-page-break? tag.

Comment by Nancy — July 25, 2007 #
Hi Anil,
Please start with the XML Publisher user’s guide. You can find it on otn.oracle.com.
Thanks,
- Nancy.

Comment by Nancy — July 25, 2007 #
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.

Comment by Anil Lohan — July 25, 2007 #
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

Comment by Anu — July 26, 2007 #
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

Comment by Raj Arukonda — July 26, 2007 #
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!

Comment by Andy — August 1, 2007 #
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

Comment by madhavi — August 1, 2007 #
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

Comment by madhavi — August 2, 2007 #
Good work Nancy

Regards
Habib

Comment by Habib — August 4, 2007 #
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

Comment by Srinivas — August 6, 2007 #
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

Comment by madhavi — August 8, 2007 #
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

Comment by madhavi — August 8, 2007 #
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

Comment by madhavi — August 8, 2007 #
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

Comment by madhavi — August 8, 2007 #
hi madhavi u want XML Publisher user guide.

regards
Ram

Comment by ramkumar — August 9, 2007 #
hi ram,
i need xml programming user guide not publisher user guide for reference to create xml data file
thx
madhavi

Comment by madhavi — August 9, 2007 #
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

Comment by madhavi — August 9, 2007 #
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

Comment by Swapana — August 10, 2007 #
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.

Comment by Nancy — August 12, 2007 #
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.

Comment by Nancy — August 12, 2007 #
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

Comment by madhavi — August 12, 2007 #
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

Comment by madhavi — August 12, 2007 #
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?

Comment by Wale — August 29, 2007 #
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?

Comment by chidinma — September 7, 2007 #
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

Comment by Praburam — September 12, 2007 #
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

Comment by prabu — September 12, 2007 #
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

Comment by Balu — September 12, 2007 #
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?..

Comment by prabu — September 12, 2007 #
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)

Comment by Balu — September 13, 2007 #
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

Comment by prabu — September 13, 2007 #
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

Comment by Ashok — September 24, 2007 #
Do we need to upload rtf file to apps server? If yes, in which directory?

Comment by Ravinder — October 1, 2007 #
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

Comment by sushma — October 8, 2007 #
Hi

How to create a Exel output using the XML Publisher

Gopal

Comment by Gopi — October 17, 2007 #
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.

Comment by Monic — October 17, 2007 #
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.

Comment by Marian — October 17, 2007 #
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

Comment by Monic — October 17, 2007 #
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

Comment by vikash — October 24, 2007 #
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

Comment by Anusha — October 25, 2007 #
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.

Comment by Marian — October 25, 2007 #
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.
+————————————–+

Comment by Anusha — October 25, 2007 #
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.

Comment by Desi — October 25, 2007 #
brief description about the tags which we are used in xml publisher : foreach|end foreach,
if|end if, choose|when|end when|end choose

Comment by mallikarjun — November 19, 2007 #
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.

Comment by mallikarjun — November 19, 2007 #
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

Comment by mallikarjun — November 19, 2007 #
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â€¦

Comment by mallikarjun — November 19, 2007 #
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…?

Comment by sunil sane — November 22, 2007 #
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

Comment by Govardhan — December 3, 2007 #
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)

Comment by Tim — December 7, 2007 #
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

Comment by Mani — December 26, 2007 #
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

Comment by Pooja — January 24, 2008 #
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

Comment by Anuj — February 19, 2008 #
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

Comment by Zoran — February 20, 2008 #
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

Comment by Divya — March 3, 2008 #
Hi,
Is it possible to get the xml publisher report output in excel or comma seperated file depending on the user’s wish

Comment by swapna — March 3, 2008 #
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

Comment by Divya — March 3, 2008 #
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?

Comment by madhu — March 28, 2008 #
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?

Comment by salp — April 4, 2008 #
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.

Comment by madhu — April 6, 2008 #
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

Comment by Anas — April 15, 2008 #
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

Comment by Radhika — May 20, 2008 #
Hi,

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

Thanks
Rupa

Comment by Rupa — November 10, 2008 #
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

Comment by Rupa — November 10, 2008 #
Sorry Rupa, I am not familiar with the integration of XML Publisher and OBIEE. Perhaps other experts can chime in…

Comment by Marian — November 17, 2008 #
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

Comment by Sri — December 1, 2008 #
This document is very useful to me. Thanks !!!!!!!!!

Comment by Diptiman Roy — January 15, 2009 #
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

Comment by Harsha — January 16, 2009 #
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.

Comment by VASU — January 20, 2009 #
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..

Comment by anjan — January 29, 2009 #
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 ?

Comment by Betty — February 26, 2009 #
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

Comment by Bikram — March 1, 2009 #
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

Comment by sandeep — March 7, 2009 #
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

Comment by ME — March 9, 2009 #
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

Comment by Raghu — March 24, 2009 #
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

Comment by Husen — March 25, 2009 #
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 …

Comment by Shiva — April 9, 2009 #
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…

Comment by Mirjam — April 20, 2009 #
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…

Comment by Mirjam — April 20, 2009 #
How to change the application name of data definition in XML Publisher

Comment by Trupti — May 7, 2009 #
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?

Comment by RANJITH.K — May 12, 2009 #
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

Comment by Neelima — May 14, 2009 #
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

Comment by Mary — May 25, 2009 #
Trying to find information on anyone that has created Customer Statements and/or Dunning Letters in XML.

Comment by Tammy — June 19, 2009 #
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.

Comment by Shiva — June 30, 2009 #
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?

Comment by ajay — August 3, 2009 #
Have you had anu success registering multiple rtf template against the same data definition with the same language and territory?

Comment by Sean — August 3, 2009 #
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

Comment by suresh — August 25, 2009 #
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

Comment by Marian — August 25, 2009 #

Sorry, the comment form is closed at this time.

8 Users Online

Most Recent

Quick Oracle Links

Disclaimer

Opinions expressed on this site are entirely of their authors and do not neccessarily reflect the position of Oracle, its partners and customers, or any other organization.

Oracle Applications and other Oracle products and services mentioned on this site are trademarks of Oracle Corporation, and use of these product names does not imply any association with Oracle.

Any tips or advice provided on this site may not apply to your own particular circumstances and no warranty is offered on their use.

This site is brought to you by:

This site looks its best if you

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

112 Comments

Recent Comments

Most Popular

Most Recent

Categories:

Quick Oracle Links

Disclaimer