xml report output in excel format without using options tab in EBS

613838

How to get xml publisher report output in excel format without using options tab in EBS?
I am getting XML Publisher report output in excel format by using options tab while submitting the concurrent request .
But i want to get excel output automatically.
Can anyone give idea to get XML publisher Report output in excel without selecting options tab.

Thanks in advance
Sandeep V

599062

Hi,

you can change the format in the Concurrent Program Define...

Navigation is Responsibility - System Administrator

Concurrent - Define - Enter the Name of Concurrent Program

Change the Output format to XML and save it.


Regards
JDev..

552855

Hey Sandeep,

I am working on a similar format for a report and if possible can you please give me some guidelines. I have initially created reports using XML Publisher, but for those , the output preview format was PDF. So, if I select the preview format as EXCEL will it give me output in Excel and for this to happen, how do I define the rtf template. I believe the working will be same as for PDF, create a rdf report, get output in XML and apply the template to get the data in Excel or there is something different to this.

Thanks,
Sunil

611365

Hi Sunil,

This option of defining the output format to be only EXCEL does not exist.

552855

I got the solution for this. Define the report as you do for PDF output. And for Excel output, while submitting the program, in the layout, change the format to Excel and you will get Excel output.