Oracle report 10g publsinng on web and Oracle Portal


I am converting a report that was using oracle OAS9i, we pass to URL(rdf file) userid/password and worked fine. We were not using Portal, even though it is installed by OAS. Now seems we have to use Oracle Portal to publish the same report. Is that right? If not how will I use report servlet to call a rdf file I assume I still need to send oracle user id/password as that is needed to run report(knowing this from old Oracle report 6.0). We really do not want to autheticate any user all users behind use the same Oracle account to print reports. Any hint?
Another thing I find that now reports are closely linked to Portal and looking at web publishing document it seems one needs to view them thru Portal. Please help me understand this why I can not just see the report as once they are processed they produce pdf that any borwser can show.


Any one??

November 30, -0001

Oracle report 10g publsinng on web and Oracle Portal

I am converting a report that was using oracle OAS9i, we pass to URL(rdf file) userid/password and worked fine. We were not using Portal, even though it is installed by OAS. Now seems we have to use Oracle Portal to publish the same report. Is that r

[Secure Configuration] Oracle Reports 10g Email Configuration...

Hi Everyone, In oracle Reports 10g, we have an option of sending mail as an attachment using destype = mail and desname = [email protected] For this to happen we have to add the outgoing mail server name in the <report server>.conf file. Once we con

Cofiguring & sending email with attachment from Oracle Report 10g

I want to run report from Oracle 10g reports to be sent as email attachement to differnt people with their respective personal content. The first problem is to know how to configure Oracle reports 10g to be able to send output to email address. The s

Differences between Oracle 8i for a UNIX Platform and Oracle 8i for a Linux Platform

Hello, J would like to know if there are some differences between Oracle 8i for a UNIX Platform and Oracle 8i for a Linux Platform. I know that there are some differences on Oracle 8i Parallel Server and i know that some products are not include like

Oracle Reports Not working in Web Layout

Hi, I am facing problem to run oracle reports in web layout working fine in paper layout. Please tell me the steps how to fix this problem? Regards, Waqar ShafiqueHello, The easiest way to develop is to use the Report Builder Wizzard.Other example ca

How to get an effective EXCEL Spreadsheet as output for Oracle report 10g

Hi All, I am a newbie in Oracle reporting. I am using 10g. I have an oracle report whose output format is PDF from the user interface. User asked for Spreadsheet output. I changed the JAVA CODE "desformat" = Spreadsheet and got the report in Exc

Oracle reports 10g not opening in Windows7

Hi, I installed oracle 10g developer suite in Windows7 and got installed successfully. I am able to run the oracle forms but when i execute oracle reports it opens and closes immediately. What is the solutions. Please help me in this regard10g Dev Su

Download Oracle Database 10g Release (10.2) and required patches

Hi I need to upgrade Database from to 10.2. So I need to get the Oracle Database 10g Release (10.2) Software and latest patches sets and required patches. SAP 4.7 Kernel Release: 640 with Patch 221 Windows2000 Patch 4 I am  not able to find o

After Parameter Form issue - Oracle Reports 10g

Hi All, I have compiled an .rdf report to an .rep file and when I run this file I get the "REP-1247: Report contains uncompiled PL/SQL" message. The issue is I have built the report with dynamic XML customizations in the after parameter form tri

Oracle Report Error (string buffer too small) in Portal

Hi, I have registered an oracle report (.rdf) with portal which works fine outside in Reports Builder, but when I try to run it in Portal it keeps throwing this error: SQL-6502: ORA-06502: PL/SQL: numeric or value error: character string buffer too s

Oracle reports 10g High Availability

Clustering is deprecated with 10g application servers and High availability is recommended by Oracle for fail over of Report services (standalone). I would like to get any incite , oracle references as to how the recommended solution could be impleme

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

Oracle Reports 10g with rwclient

Hi All, I m getting the following error when i try to run the report with rwclient. REP-0177: Error while running in remote server Unable to retrieve a string from the Report Builder message file. REP--1870655474: And i m able to execute the report s

Oracle Reports 10g Distribution - Dynamic file name

HI all. I have a problem in my distribution file. The following is my xml file: <destinations> <!-- Generate one file for all Employees --> <file id="MyFiles1" name="C:\Apps_Attach\Jan2007\Rep_all_Employees.pdf" format=&

Page cannot be displayed error on oracle report 10g

hi, when i ran the report from Live server , I had run through "CACHE" option. page cannot be displayed is coming on the screen. how to do.... Thanks and advance, Maranhi did u start OC4j? If not please start and also start u r report server. al

Requirement with Oracle report builder

Hi All,, I had a requirement like this...i am very new to Oracle report builder tool and Oracle APPS i need to develop a sample report in this format.......please help me which tables i need to use?? i know how to create user parameters,field columns

Oracle Report vs JSP efficiency and Excel XML in Web Source Questions

I have used Oracle Reports in the past 6i, but haven't used them in about 4 years. We are now using 9.0.4 reports and I am trying to generate Excel XML from an Oracle report by manipulating the web source of the report. Basically copying and pasting

How to call Reports in oracle forms 10g

Dear All, How to call Reports in oracle forms 10g. I am using Oracle Forms 10g Reports 10g and Database 10 and and Operating system Windows XP. Please give me the Solution. Thanks and Regards, FaziludeenHi Omkar, Please check the following code. DECL

Oracle Streams b/w MS-Access 2007 and Oracle 10g.

Can we set up Oracle Streams between MS-Access 2007 and Oracle 10g? Ms-Access as source and Oracle 10g as destination database. If so, can any one please give me little heads up with supported doc's or any source of info.Help Help....!!!Read other 2

Reports ---- Form calling on Web (Pay Attention : Oracle Team)

Hi, we are trying to call form from Report in Drill Down Report we are working on Client/Server system. Please help . We can call form FROM Report on MS Windows platform by using App.Begin Routine but we are unable to do so on web. srw.set_hyperlink