Apps To Fusion

...
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

Thanks
Tony

...
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.

Regards,
Anil

...
written by priyasankaran , June 30, 2007

Hi,

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

Thanks
Tony

...
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.

Thanks
Fabio

...
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?
Thanks.

Hariom..

...
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.

Thanks,
Vineet

...
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?

Cheers
MicheleC

...
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.

Cheers
Michele

...
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.

Thanks!
Janel

...
written by R C Pandre , September 19, 2007

Hi,

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.

Thanks,

R C Pandre

...
written by RamKrishna , September 27, 2007

Hi,

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

Thanks in advance,
Ram.

...
written by Gareth Roberts , October 08, 2007

Hi,
You might like this post also:
http://garethroberts.blogspot.com/2007/10/excel-file-output-from-oracle.html
Gareth

...
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

Thanks

XML Publisher
written by vathana , November 10, 2007

Hi
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
Vathana

...
written by Frida , November 12, 2007

Thanks) That is what i needed)

----------------
http://chicagohouses.cn

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
thanks
quang

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

Hi,

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.

Thanks
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.

Regards
Raghu

...
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

...
written by Ashwini , September 11, 2008

Hi Anil

I have a doubt on the screen shots attached...

In the set up steps : 1) Does it mean by setting up the first step...always outputs of XML reports are in Excel format?

2) In the second step, by setting browser in the user level. It overrides the setting up of Excel in Site. Please let me know what is
the purpose of setting up of Browser in user level.

Thank you
Ashwini

Issue in opening the output directly in Excel
written by MP , December 03, 2008

Hi ,
Firstly Thank You for sharing such useful information in a detailed way!!!

I created a report with output type XML and also created the required data definition and the template . When I run the report through SRS ,I choose the output type to be EXCEL. Even the preview style in the datadefinition is EXCEL . The report completes successfully but when I click "View Output" browser opens up and then it closes off but no data is seen .

Not sure where I am going wrong . I even tried the same report registered as the new concurrant program with output type as "TEXT" but even in this case if I select "Microsoft Excel" in viewer option that is seen a browser open and it closes off . No excel sheet is seen .

Please suggest .

Thanks and Regards
MP

Defaulting to Excel
written by Ravi , March 18, 2009

Is there a way to default the XML publisher concurrent reports to Excel instead of going to option ans set the Formal to Excel.

Excel output from XML Publsiher report has all fields wrapped and amount column does not act as Number column..Please help!
written by aa , May 06, 2009

Hi

I have a XML Publisher report, when I run the request for the report I change the option to Excel format and sumit the request. But the output in Excel format has all fields wrapped and also the amount fields does not behave as Number field to summarize. Please help

Thanks

Native Excel templates for EBS XML Publisher
written by Grau , August 06, 2009

Try to use native Excel templates
Welcome to http://xlspe.com

zipping functionality while bursting
written by Allah Baksh , October 22, 2009

Hi Anil,

Thank you very for sharing this useful information.

Could you please let me know how we can zip the file before bursting the file to the user?

Thanks,
Baksh.