Converting a simple Oracle Report to XML Publisher report template

Advertisement

Hello,
I have a simple Oracle Report 9i which displays data from four tables. It uses three different queries to get the data. How can I simply generate a template file(say RTF) or atleast an XML source from that report? I tried joining the queries (like outer join) but wasn't able to get the format which report 9i was generating. Could anyone please help me out with a clear approach?

Advertisement

Hi,
Are you referring to how to get xml out put from seeded report i mean from EBS that already in oracle reports,
then you need to query from respective application by creating new concurrent program and then change the out put to XML, you will get xml file then save it to your system.
By using this input xml fle you can create RTF template whatever you want the foramat, after that you upload back this RTF file to EBS using XML PUBLISHER ADMINISTRATOR responsibility.
hope this might give you idea,
let us know if it is not clear or you are asking different question,
srinuk

October 11, 2015

Converting a simple Oracle Report to XML Publisher report template

Hello, I have a simple Oracle Report 9i which displays data from four tables. It uses three different queries to get the data. How can I simply generate a template file(say RTF) or atleast an XML source from that report? I tried joining the queries (

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

FO processing for XML Publisher Report Bursting Program

Hello, I am facing the following problem: if i try to burst a report using XML Publisher Report Bursting Program special characters like (ş,ţ,ă, etc.) in the resulting PDF look strange. I have tried running the report without bursting it and the char

Run XML Publisher Report  via URL (like Oracle Reports)

Hi All, Is it possible to run xml-publisher report via URL? In Oracle Reports works this fine: http://test:7777/reports/rwservlet?server=test_bihome1&report=test1.rdf&userid=test/[email protected]&desformat=pdf&destype=cache We need this for public

PeopleSoft XML Publisher report error with java.io.FileNotFoundException

Hi, I have created two reports using XML Publisher in Peoplesoft Financials. The two reports are not related and they were submitted for processing separately. The first report completes without any issues. The second report results in error with 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

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 getting errored out

Hi, I have created a basci XML Publisher report. When I run the report I am getting the following error in concurrent program log. XDO Data Engine ver 1.0 Resp: 51553 Org ID : 996 Request ID: 5040983 All Parameters: p_po_number=11 Data Template Code:

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

Sorting Problem in XML Publisher Report

Dear Members, I am facing problems with sorting data in my XML Publisher Report. We are using Oracle E-Business Suite 12.1 Version and i developed a rtf Template and executable is an RDF which generates XML Data. I want the whole report to group by e

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

Formula column in XML publisher report

Hi I need to include formula column in my XML publisher report, please any one guide me on this. Thanks in advanceYou can see this , it may helping you http://oracle.ittoolbox.com/groups/technical-functional/oracle-dev-l/formula-columns-in-xml-publis

Calling XML Publisher report(RDF based) From OAF

Hi All, I have requirement where i need to call one of the custom XML Publisher report from oaf by passing the parameters. and i dnt want this using concurrent program. I have an idea of calling xml publisher report which is Data Template based(XML).

Store XML Publisher report in the database

Hi all, Is is possible to generate an XML Publisher report in the background and store the report as a blob in the database. I have an APEX application that needs to generate the report when the user clicks an 'Update' button. This report can then be

Calling subtemplate.rtf in maintemplate.rtf in XML Publisher reports

Hi, I am working on XML Publisher Reports. I have two subtemplate.rtf; based on condition in the maintemplate.rtf, i have to call either of the subtemplate.rtf. Doubts: 1. Do i need to register both subtemplate.rtf in oracle applications? If yes, wha

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

Interactive pdf reports - Reports thru XML Publisher

Hello All, We have a requirement wherein the customers should be able to keyin the data in the pdf reports that are generated through oracle and save the same. This way the customers can reduce lot of paper work. Our reports are developed through Rep

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