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 reports without user login.


I was waiting to get home before Tim replied... He got the better of me this time :-)
You say you want to let your users run reports using XMLP just by clicking on an URL same way you do with reports and without having to login. If I got the question right and assuming that:
1.Your company is not overly concerned on who runs what reports
2.Who sees what data
3.Your XMLP installation is on your intranet and firewalled from the outside
What you can do is:
On the main page of your XMLP Enterprise installation you should see a folder called "Guest". Any report you create under this folder is run as user "guest" which means you don't have to authenticate yourself as you would normally do.
I have tested this on my home server and this is what I've done:
1.Logged in as admin or any other user you've created with admin privileges created a report under the "Guest" folder.
2.Copied the URL, on my server it is ""
4.Logged off as admin and pasted the URL to a new browser window
5.Hit return and Voila, my report runs without the need to login to XMLP.
Hope this helps. Let us know how you got on.
PS: If you want to see the report for yourself here's the URL from the outside:
I'll keep the link alive for a couple of days.

October 11, 2015

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

Running Web Layout Of JDBC Query in Oracle Report Builder 11g.

javax.servlet.jsp.JspException: REP-4100: An attempt to execute data source failed. JDBCPDS-62008:A SQL error occurred: {0}. S1000 [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt javax.servlet.jsp.JspException: RE

Outputing reports to Word from Oracle reports

I have already created the template in word, I saved it as an html file. Opened it from Oracle reports and have started working on the web source, but I don't really know where to go from here. Help it urgent. ThanksPlease refer "Building reports&quo

Report printing problem in Oracle Report 10g

Hi group, I have one report which I am callinng from form. Out put is comming directly in PDF format, While taking printout on EPSON Printer allignment is not comming properly. But If i convert in to text format and print from MS-DOS prompt on same p

How to avoid IE pop-ups when running BIP reports(w/ SSO) from Oracle Forms?

Hi all, We have an OID/SSO integrated Oracle Forms and BI Publisher environment in place. We/users expect the same behavior when running Oracle Reports or BIP reports from Oracle Forms... which means receiving no intermediate pop-ups and simply getti

Large XML Publisher reports fail with client-error-request-value-too-long

We are running BI Publisher 5.6.3 with Oracle Applications (ATG.H RUP 5), and are having frequent failures with client-error-request-value-too-long messages on large PDF reports that cause the entire report to not print. The exact error mes

XML Publisher to generate Excel reports

Can we use RTF template to generate Excel reports? Is all the process the same or do I need to do some additional set ups? Also, can I create a custom report , set the output format to xml and run XML Publisher on the top of it to generate output of

Oracle report 6i(some problems,when running thru internet)

how can i fixed the page size of report(when i am running thru internet) i fixed the vertical elasticity of outmost frame(in layout) is fixed and in layout's main section height is 11.50 inch (physically it takes 8.50 inch) ,when i am running it in s

Strange error with xml publisher

I was testing sub-templates on a clone of our production environment and encountered a strange error. When I run the concurrent program I get an xml publisher error and then when I do a preview in xml publisher I also get an error. These are the exac

XML publisher on ubuntu ?

dont know if this is the right place to ask this. but does any 1 know if there is possible to run xml publiser. (word plugin) in ubuntu? could it work with open office..? ive googled around but couldnt find a good answer. so have any 1 tried running

Oracle Reports - PDF layout

Hi, I've just 2 questions: 1 - when i run a Report from my Report Builder client (Oracle Developer Suite) to produce a PDF report file, the report have just 1 page. When I call the same report via URL (http://<ip adress>:<port>/reports/rwservl

Unable to start Oracle Reports Server for 10g version

Attention Oracle Reports Team or anyone else: I am unable to start the Oracle Reports Server for 10g version of the Application Server. I have included the trace files see below. I marked the text in bold that might indicate the issues. An

XML Publisher does not attached pdf file java.lang.StackOverflowError

Hi there I have Bursting program which email the pdf report, some times when I have all of data the report does not attached and send to the user, I get following messages in log file. XML Publisher 5.6 Build 45 Oracle Set Bursting paramete

Launching XML publisher from OAF

Hi , I am trying to run an XML publisher report from an OAF page. I get the following error whenever I run the report, "An error encountered either due to invalid Template details or due to null Data Input Stream". The code fails at,            

E-Business Suite  XML Publisher Issue.

Hi DBAs, I am getting following error while uploading a big size (5 GB and up) .rtf file from XML Publisher Administration>template (from application). oracle.apps.fnd.framework.OAException: oracle.jbo.JboException: JBO-29000: Unexpected exception ca

Embedded images disappear on column sorts when viewing SSRS via url in an iframe

RE:   SQL Server - 2008 R2  Reporting Services We deliver an ASP.Net MVC (5) application and some of the views show/display SSRS report via url in an iframe (so the report is displayed vi the web viewer).   There are images in the header of some of t

Using JNI in Oracle Reports

Hi. I have some difficulties understanding the Oracle Reports mechanism of JNI. The problem I have is the report job is crashed when I use the imported java class. I am using Oracle Reports on Oracle Linux The scenario of generating report i

Oracle Report

Hello all, I have just been given the task to find a suitable reporting tool for our application. Currently our web based application has been developed using Javascript, pl/sql packages etc with OAS and Oracle 8 database. The database will be upgrad

About using cursor expressions in Oracle Reports

I've just discovered a rather old syntax of the mighty select statement. It seems related to the concept of inline view or more precisely scalar view. It's the cursor syntax in a select statement. Example: select d.dname ,cursor(select e.empno,e.enam

Oracle Report Server Engine is getting stopped after starting.

Hello, Reports Engine is shutting down after starting. OS = Solaris 10 Application Server = Oracle 10gr2 *** 2011/1/4 3:59:34:723 -- Shutting down engine rwEng-0 *** 2011/1/4 3:59:34:726 -- Reports Server shut down engine rwEng-0 *** 2011/1/4 3:59:34