Urgent: Calling Reports from Oracle Forms 10g (10.1.2.0.2) fails

Advertisement

Problem displaying a report from within Oracle 10g forms.
After a lot of work, we are able to access and actually display a report directly from Internet explorer and view the report from the report server as well.
The successful url was:
http://york.vrc.virginia.gov:7778/reports/rwservlet
?report=/u01/app/oracle/produ ct/vrcmidtier/reports/vrc/pmw41051.rdf
&userid=vrcpr/[email protected]&destype=cache&desformat=HTML
The form displays correctly back to the screen
When executing from within the form, however, the report runs but does not display back to the screen.
Forms Steps so far:
created a report object called pmw41050
static parameters are:
file name: /u01/app/oracle/product/vrcmidtier/reports/vrc/pmw41051.rdfination format
execution mode: batch
communication mode: synchronous
destination name; null
destination format: HTML
reportserver:: vrc_york_midtier
Built a when button pressed trigger as follows:
declare
l_report_file varchar2(200);
l_report_id REPORT_OBJECT;
l_report_status varchar2(200);
begin
-- capture the report
l_report_file := 'pmw41051';
l_report_id := find_report_object(l_report_file);
-- set the parameters for this output
set_report_object_property(l_report_id, REPORT_EXECUTION_MODE, BATCH);
set_report_object_property(l_report_id, REPORT_COMM_MODE, SYNCHRONOUS);
set_report_object_property(l_report_id, REPORT_DESTYPE, CACHE);
set_report_object_property(l_report_id, REPORT_DESFORMAT, 'PDF');
set_report_object_property(l_report_id, REPORT_SERVER, 'rep_york_vrcmidtier');
set_report_object_property(l_report_id, REPORT_OTHER, 'PARAMFORM=NO');
set_report_object_property(l_report_id, REPORT_DESNAME, 'DESNAME');
-- and run the report
l_report_status := run_report_object(l_report_id);
-- monitor progress
while l_report_status in ('RUNNING', 'OPENING_REPORT', 'ENQUEUED') loop
l_report_status := report_object_status(l_report_status);
end loop;
message('back from the report'); -- test message for return
end;
The report executes without error (as indicated by the message on the last line) but does NOT display back to the screen
checking the rwservlet/showjobs verifies the report completed and the reportcan be displayed from there.
So, bottom line: how to make a 10g form call report and display it on the screen?

Advertisement

Thanks MIke for your feedback...
Will this surfice?
Procedure Test_Report Is
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status VARCHAR2(50);
BEGIN
repid := find_report_object('report5');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,BATCH);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,CACHE);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'html');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,'repserver90');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER,'paramform=no pdeptno='||:dept.deptno);
v_rep := RUN_REPORT_OBJECT(repid);
rep_status := REPORT_OBJECT_STATUS(v_rep);
WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED')
LOOP
rep_status := report_object_status(v_rep);
END LOOP;
IF rep_status = 'FINISHED' THEN
/*Display report in the browser*/
WEB.SHOW_DOCUMENT('http://<YourServerName:8888/reports/rwservlet/getjobid'||
substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server=repserver90','_blank');
ELSE
message('Error when running report');
END IF;
END;

October 11, 2015

Urgent: Calling Reports from Oracle Forms 10g (10.1.2.0.2) fails

Problem displaying a report from within Oracle 10g forms. After a lot of work, we are able to access and actually display a report directly from Internet explorer and view the report from the report server as well. The successful url was: http://york

Calling Crystal Reports from Oracle Forms 10G

Hi everyone, I am trying to call a crystal report from Oracle Forms 10G. I have a button on my Form which when clicked calls a Crystal Report which the uaser then wants to save as a PDf file. Can someone please send me the code to do this and also th

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

Calling Report From Oracle Forms

Hi I am calling this one report from oracle forms, I am using global temporary table to run that report. I am first inserting data into the temporary table through oracle form and then i am calling report in that form to view the data in that tempora

How to send a character mode report from Oracle Form 10g to a printer.

how sending a character mode report from Oracle 10g report to a printer. I'm sending to a printer located in the network i have theses parameter report desformat = prtname desname=?????? destype= ????? mode=character i would like to preview the repor

Invalid ID calling report from oracle forms 10 G

Hi, I have a problem during calling a report object 10g from a FORM, the source code is below the message, an the error message is can't not find PLAN_FUZZY (my report module name)...... WHY ??? DECLARE      repid REPORT_OBJECT;      v_rep VARCHAR2(1

Calling crystal reports 11 from oracle forms 10g

Could you provide me step by step a solution on how I can call crystal reports 11 from oracle forms 10g application.Hi, Use web.show_document for calling the reports. Check out forms online help for syntax and example of web.show_document. -ArunRead

Calling Java Script to open a Map (Like Google Map) from Oracle Forms 10g

Hello, We are on Oracle EBS rel 12, Forms 10g. We have a requirement of calling a Custom Map application (Like Google Maps) from Oracle Forms 10g. When the user enters the address like town, city, country etc and clicks on a button there should be a

How to invoke crystal reports from Oracle forms 11g R2 along with passing p

How to invoke crystal reports from Oracle forms 11g R2 along with passing parameter to it. how to pass parameters to crystal report, please help.how to pass parameters to crystal report, please help.This would entirely depend on crystal reports and y

Calling Word document from Oracle Forms 10g

Hi all, I would like to call a Microsoft Word document from my Oracle Forms 10g. What would be the best way to do this? Thank you in advance.Have you tried something like WEB.SHOW_DOCUMENT('file:///<documentpath>','_blank');Read other 2 answers

Calling web service from oracle forms 10g

Problem Description: I'm following the steps as per the doc: http://www.oracle.com/technology/products/forms/htdocs/10gr2/howto/webservicefromforms/ws_10_1_3_from_forms.html to create a java stub to call external web service and then use java importe

Issue calling report from a Form(11.1.2).

Hi, I have an existing code in the form to call a report and it seems to be working in the current 10g version of production server and I am migrating forms 10g to 11gR2. My issue here is when, I want to call the report from Forms 11g ( i.e. in devel

Generating a Report from Oracle Forms

If a want to generate a report in Oracle Reports by pressing a Button on my Oracle Forms for example for 5 text items on that form ...then how do i do it ??? plz helpwell when i create a report module in the object navigator of oracle forms its opens

URGENT: Calling Reports from Forms (10g)

Hi, I've tried to understand a pdf file on this subject, but I still can't do what I want. I need to create a button on a form that, When pressed, calls a report. Could someone help me showing some code?? Thanks!!Tiago, there's a good Whitepaper at h

Oracle reports 6i to Oracle forms 10g migration

Hi, I have .rdf files which were created on Oracle Reports 6i. I would like to migrate the .rdf files into Oracle Reports module which is present as a part of Oracle Forms 10g to generate PDF output. Please let me know the detailed steps to be follow

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

Passing a value for date parameter from Oracle Forms to BIP

Hi I have created a report with the following SQL query: select d_tables.d_seq, to_date(d_tables.d_created) creation_date, d_tables.d_created_by created_by, d_tables.d_pk, d_tables.table_name, d_tables.comments from d_tables, d_applications where d_t

REP 110 & REP 0110 .calling reports from Form 10g(10.1.2.0.2)

Hi All, We are migrating form from Oracle form 6i to Oracle 10g(10.1.2.0.2). I am calling reports from forms using Web.Show_Docment(). When we run reports in report builder 10g it works fine. But when we try to run reports from Forms 10g it throws er

How to call reports 6i or forms 6i directly from oracle procedure

Hi, Hi, Env: 6.0.8.25.2 (forms 6i/reports 6i) Database: Oracle 10g r2 We are running a client server environment and not web based. I want to run the forms 6i or reports 6i directly from a database procedure/function and not by creating a procedure i

How to run a report from oracle 10g form in .csv format

dear all, how to run a report from oracle 10g form in .csv format? i've already run in pdf & excel format. i'm using SET_REPORT_OBJECT_PROPERTY (ro_report_id, report_desformat, 'PDF'); --for pdf SET_REPORT_OBJECT_PROPERTY (ro_report_id, report_desfor