XML Publisher report default output in Excel format.

Advertisement

Hi,
We have defined one concurrent program whose output format is text, this concurrent program executable is PL/SQL and in this PL/SQL program we are generating XML data and displaying XML using below fnd_request.
l_conc_id := FND_REQUEST.SUBMIT_REQUEST('GMP','GMPPDROP','', '',FALSE,
     p_sequence_num,chr(0),'','','','','','','','','','','',
We have also defined template for this.
Using below fnd_request we are choosing template and data is getting generated in PDF format. Now our requirement is to display the output by default in Excel format.
FND_REQUEST.SUBMIT_REQUEST('XDO','XDOREPPB','', '',FALSE,'',
l_conc_id,554,G_comb_pdr_temp,
G_comb_pdr_locale,'Y','RTF','',scale_report,'','','','','',
When i saw XML Report Publisher concurrent program, there is one parameter for Output Format and i tried passing 'Excel'/EXCEL/excel to this parameter but output is still coming in PDF format.
FND_REQUEST.SUBMIT_REQUEST('XDO','XDOREPPB','', '',FALSE,'',
l_conc_id,554,G_comb_pdr_temp,
G_comb_pdr_locale,'Y','RTF','Excel',scale_report,'','','','','',
I have also tried giving Default Output to EXCEL in template definition but this is also not working.
Your valuable suggestions highly appreciated.
Thanks
Vijay

Advertisement

Hi;
What is EBS version? Please see below which could be helpful for your issue:
Changing Output Format to RTF or Excel in XML Publisher Request Does Not Display Output Correctly [ID 404512.1]
Cannot View BI Publisher (formerly XML Publisher) Report Output In Excel Format or XHTML [ID 359875.1
How is Default Output Type Determined for Reports Submitted Using XML [ID 888972.1]
Also see:
XML PUBLISHER report in Excel out put problem
XML PUBLISHER report in Excel out put problem
Regard
Helios

October 11, 2015

XML Publisher report default output in Excel format.

Hi, We have defined one concurrent program whose output format is text, this concurrent program executable is PL/SQL and in this PL/SQL program we are generating XML data and displaying XML using below fnd_request. l_conc_id := FND_REQUEST.SUBMIT_REQ

Xml publisher report using RTF in Excel is coming as wrap text?

Hi, I am working on XML publisher report, I have converted standard report to xml publisher , to generate the report in excel. But the output is coming as Wrap text, is there a way to get the output directly without wrap ? Thanks DevHi Dev, You can t

XML Publisher Report not generating the PDF output.

Hi, I am trying to develop a XML Publisher Report in R12 Vision Instance. I have developed the rdf report and concurrent program with XML as output format. Ran the concurrent program and I got the XML output. Based on XML output I have created the rt

Oracle reports output in excel format does not display the graphs

Oracle reports output in excel format does not display the graphs: "linked image cannot be displayed". The output file in PDF format the graph is supported.Do you have any header and footer on your template? If you have any header and footer the

Problem with data size in XML Publisher report

Hi Experts, I am working on EBS11i and database 9i. I working on XML Publisher reports, i have one XML Publisher report with generating output in EXCEL format. If i submit the report, if the data is huge (like 2.3 million records), it's ending up wit

XML Publisher Report Bursting

I have created report using XML Publisher Report Bursting. The output-type of the report is pdf.. <xapi:document output="${PROJECT_APPROVER}" output-type="pdf" delivery="123"> But if I change the format to xls it's show

Advantage and disadvantage of xml publisher, report builder and discoverer

Hi, anyone can explain advantage and disadvantage of xml publisher, report builder and discoverer? thanks in advance!The best way i found was to put a equals and then double quotes... this only works for excel however it will allow you to cut and pas

Output in Excel Format Issue

Hi all, I am not able to view the output in EXCEL format after registered the RTF file in the XML Publisher Administrator to run as a concurrent program. I am wokring in XMLP 5.6.2 and Microsoft Office 2003. When i preview the output as EXCEL in the

Pdf reports to run in excel format

I have a report and output is in pdf format. Some users want the report to run in excel format for them to make changes and do mail merging. How can I acomplish this. I have reports 10g Thanks in advance AnuUse DESFORMAT=SPREADSHEET http://download.o

XML publisher report works fine in English environment but NOT in Dutch

We are using Oracle Reports to generate XML file which will be input for XML Publisher report . Our requirement is to generate report in Dutch (Netherlands) language. We developed a report which is working fine in English. Then we copied this RDF fil

XML publisher report thru fnd_request.submit_request

Hi All, I have oracle application 11.5.10.2 and created many XML publisher reports in RTF format (RDF as a source of XML output) . Now i want to run these reports thru fnd_request.submit_request and generate report output in PDF. I have successfully

Xml publisher report problem

I have a xml publisher report which list job names. After submitting concurrent program, I am getting below error A semi colon character was expected. Error processing resource some of the Jobs have special character '&'. below is code CREATE OR REPL

XML Publisher Report Bursting Program (XDOBURSTREP) is failing after ATG7

Hello After upgrading ATG RUP7, we have issue related to the XML Bursting Program. XML Publisher Report Bursting Program (XDOBURSTREP Short Name) is failing with error when there is no output is generated by the Oracle Report, this was working fine b

Submitting a XML Publisher Report from JSP page

Hello, We have need to submit a XML Publisher report from Quoting/iStore module in Oracle Ebusiness. The out put should be viewable in PDF format and user should be able to print. can anyone pls help on how this can be achieved. TIAReally appreciate

Custom XML Publisher Reports in EBS 11.5.10.2 Fails Randomly

Hi Experts, I have a Custom XML PUblisher Report Concurrent Program in EBS 11.5.10.2. The Report fails randomly with a Warning. I get the following error, [11/21/08 12:17:21 PM] [UNEXPECTED] [915997:RT3085490] java.io.FileNotFoundException: /u01/PROD

XML Publisher Report with PL/SQL

Hi Like to know how to develop the XML Publisher Report with PL/SQL, i did the following 1. created a pkg like as below CREATE OR REPLACE PACKAGE BODY APPS.TEST_XMLTAG_PKG AS PROCEDURE main (errbuf OUT VARCHAR2, retcode OUT NUMBER ) IS BEGIN DECLARE

Getting OPP LOG Error for XML Publisher report

Hi Experts                            We are facing warning message for Xml Publisher report  please advise how can we avoid this warning message. {code} Post-processing of request 12345678 failed at <sysdate> with the error message: The Output Post

Xml publisher report giving warning

Hi friends, I have a issue with xml publisher report. All existing xml publisher reports are working fine. Only the problem is newly created one. Application version 11.5.10.2 dDtabase 9i BIdesktop version is 10.1.3.4.1 MS office  2010 i checked the

How to add different versions of layout in XML Publisher Report?

How to add two versions of layout(RTF) for different languages in xml publisher report template so that user can see the report in two languages? Is that possible? If so then what is the procedure to do that? Can anyone help in this regard?Soma, Refe

App-V PowerShell: Script to Query XenApp Servers for App-V Publishing Errors and Output an Excel Document with the Results

Please Vote if you find this to be helpful! App-V PowerShell:  Script to Query XenApp Servers for App-V Publishing Errors and Output an Excel Document with the Results Just posted this to the wiki: http://social.technet.microsoft.com/wiki/contents/ar