<-----Google Analytics Code Start----> <-----Google Analytics Code Close---->
Skip to content



Default screen resolution  Wide screen resolution  Increase font size  Decrease font size  Default font size  Skip to content Default color Pink color Green color Green color
This website has now moved to http://apps2fusion.com

How to open using excel spreadsheets directly from the concurrent request | Print |  E-mail
Written by Anil Passi   
Thursday, 28 June 2007
I was asked a question on one of the comments.

How to make XML output to be displayed in excel spreadsheet, when the report has been registered to run using XML Publisher?
Thankfully my friend Fabio kindly sent me these screenshots/steps

Add highlighted line using System Administrator > Install > Viewer Options

Add the following for each listed user.

Comments (24)add
written by santosh , June 28, 2007
Thank you. I was looking for this info.
written by tony , June 28, 2007
Hi Anil,

This is fine, But what about the Template?
How will we develop the template for excel output

written by Fabio Ielpi , June 28, 2007
Hi Anil/Tony,

When setting up the template we opted for RTF as the type, however this will need to be amended at run time using the Options... button prior to submitting the Concurrent Request.

Once clicking on the Options button, you should see the template you have assigned to this concurrent request, you will need to change the format from PDF/RTF to EXCEL. Click OK and submit your concurrent request.

This should then allow you to open the output directly into Excel.
written by Anil Passi , June 29, 2007
Hi Kishore

Thanks for sharing this.

written by priyasankaran , June 30, 2007

Thanks for posting such useful information.

I tried the same and it is working .

I have a small doubt in this.
I have set the viewer text at my user level.
But when I login as different user and use
tools-->copy , i am getting viewer option.
What should I do that it will not affect any other users?

It will also be useful if you explain the different levels wherein the viewer option can
be set.
written by Tony , July 01, 2007
Hi Anil,

I got the solution, thanks for the patience,
I am getting the Excel Output now, but with a white background(as the template is rtf and has a white backgroud), How can we avoid this white background

written by Fabio , July 06, 2007
Hi Tony,

You can amend the background on your .rtf document which will then change how the excel spreadsheet looks.

written by Hariom Pandey , August 20, 2007
Hi Anil,
How can we customize any Report 6i to produce .csv file output enabling the user to open it in excel?

written by Srinivas.Kondu , August 21, 2007
Hi Anil,
I have tried the same as explained by u, but i couldn't get the outpout in Excel sheet.
The output file is empty.
The log file has the error: REP-3000: Internal error starting Oracle Toolkit.
What should i do to overcome this.
Kindly help me out.

Thanks in advance.

written by Vineet , August 22, 2007
Hi Anil,

Is there anyway we can set default Preview mode from PDF to excel so that while submitting XML report for excel output we need not to go to option screen to set Format as excel.

written by Michele , August 22, 2007
Hi there

I have been stuggling to get reports to output to an Excel spreadsheet for some time, so I was hoping this would solve my problem. Still no luck. Output file is empty. PDF output is fine, so process/template is not the problem. Is XML publisher version relevant to the solution? According to Metalink Note 358296.1, Excel output problem is a bug that has been solved in version 5.6.1. I am working on version 5.0.1

Anyone got any suggestions?

written by Anil Passi , August 22, 2007
Hi Michele

Hope you are well, it was great to catchup with so many friendly people in SA.

If you are using Excel 2002, then you must be on at least XMLP 5.6.1

Also, if you are on CU2, excel output will not work from FNDRSRUN (View Requests).
This issue was fixed in CU3.

Anil Passi
written by Michele , August 28, 2007
Hi Anil

Sorry for the delay in replying but thanks for the feedback. Will be upgrading XML Publisher soon. Then will retry.

And glad to have you in South Africa. It was great to share tech info with you. Hope you will return someday.

written by Janel , September 07, 2007
Is there anyway we can set default Preview mode from PDF to excel so that while submitting XML report for excel output we need not to go to option screen to set Format as excel.

We get asked this a lot as well. Does anyone have any ideas? As far as I know it is not possible.

written by R C Pandre , September 19, 2007

Once I had my friend calling me of such requirement to work on a Oracle report. They wanted the o/p to be displayed on Excel rather than on the browser. They did not have Excel installed as an option in Install- Viewer Options. It was an older version of EBS where there was no XML publisher.

Solution: Once the report o/p is generated, Just ask the user to Save the o/p file as .csv. This would resolve the issue.

It works irrespective of user.It is a simple solution. But those were old days, but now since we have XML Publisher in place, I would defintely like to try and explore ways suggested by you all.


R C Pandre

smilies/grin.gif smilies/grin.gif
written by RamKrishna , September 27, 2007

Is it possible to create editable PDF reports in Oracle applications?

Thanks in advance,
written by Gareth Roberts , October 08, 2007
You might like this post also:
written by Anjana , October 19, 2007
Thanks for the information..
I have the rtf template (preview shows me excel output as desired) attached in XML publisher , alsofollowed above steps but once i submit the concurrent request (set the option as excel) i get a warning "unable to find the published output for your request"..where am i going wrong

XML Publisher
written by vathana , November 10, 2007
Currently I am developing a XML report.This is my first XML report. I have a requirement to pass a parameter for order by from the concurrent program. I designed the template in RTF format. Everthing is working fine. But, I have no idea how to create a dynamic sort in XML report. If anyone has any idea please share with me.

Thanks in advance

written by Frida , November 12, 2007
Thanks) That is what i needed)

Loss character when output Excel
written by Mr.Quang , November 29, 2007
Hi.I'm developing XMLP Report.
my data is varchar2(tax code) as :00123456789
when output excel display : 123456789 loss 00 (excel is number)
Please,give me solution

Issue Showing the output in the EXCEL Format for an XML Report
written by Sudhamsu Josyam , January 04, 2008

I have a simple XML report whose output I want to show in EXCEL format. I have followed the steps below:

1. Set the profiles for the Excel (for which the screen shots were provided).
2. Entered the concurrent program name in the SRS form
3. Before Submitting the request, I changed the Format to EXCEL.
4. Submitted the request.

The request completes normal but when I click on the View Output button, it says NO DATA FOUND and in the Details with the below error:

ORA-01403: no data found

FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06502.

Please suggest.

Sudhamsu Josyam
Reply to Issue Showing the output in the EXCEL Format for an XML Report
written by Raghu , February 04, 2008
Hi Sudhamsu Josyam ,
I hope for this problem you need to install the patch (4334965)
I hope this is the solution if you are using 11i.
I hope this may solve your problem.
I hope you can see the output in Excel Format.

written by sivakumar , February 21, 2008
how to get xml tag for R12 CHECK PRINT.
i Want to get the value for supplier code, supplier site, beneficaiare name etc.
pl. let me know where will i get these information
You must be logged in to a comment. Please register if you do not have an account yet.