Calling Report From Oracle Forms

Advertisement

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 temporary table. The problem is, we can not view the data of an other session if we are using temporary table. When i call report from that form a new session get created due to which i can not see the data. Is there any method of calling report from oracle form that a same session is used to run the report?
Thanks.

Advertisement

As you mention Forms and Reports do not share the database session. I had the same problem and resolved it using record groups and DATA_PARAMETER to transfer data from Forms to Reports. You could also read the Note 110495.1 on Metalink to find useful information regarding this issue.
Adi

October 11, 2015

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

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

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

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

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

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

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

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

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

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 REPORT from FORM usning a Button ?

Hi All, Please Help me and Help other Beginers in this : Hot to call a report from a form using WHEN_BUTTON_PRESSED trigger (using Oracle 10g R1) Should i save the report as .rdf or .jsp ? Should i save the report in a specific path ? Should i add th

Calling Report from Form Error ORA-06508

Dear all, I want migrate from Fom6i to Oracle Developer Suite 10g (10.1). Folder Form = C:\APLIORA\IRS\FORM Folder Report = C:\APLIORA\IRS\REPORT I have modified file DEFAULT.ENV FORMS_PATH=C:\APLIORA\IRS\FORM;C:\APLIORA\IRS\REPORT i do not have prob

How to call OA Framework Page from Oracle Forms?

Hi, I have read the OA Guide on "Forms / OA Framework Page Integration" which guide on how to launch OA framework pages from Oracel Applications Forms. I would like to perform the same whereby to call the OAF page from Oracle Form itself. Howeve

Calling a Report from a Form

I have uploaded my form to the app server and compiled to Linux. I have copied my RDF file to the reports_path/demo directory. I can run the report via a link from our portal using the URL as follows: /reports/rwservlet?report=IndRpt.rdf&desformat=pd

Supressing the parameter form when calling report from form...

Hi everybody I call a report from a form passing a parameter. After pressing the button, the runtime parameter from appears. How do I suppress it so that the report appears right after pressing the button??? Thanks SergueiHi Serguei , You have to add

Call an executable file from oracle forms 6i

Hello , i want to call a local .exe file from oracle forms 6i passing along a couple of parameters in the command line . Can anyone help me out here ? thanks C. Edited by: user539712 on Jan 21, 2011 11:55 AM Edited by: user539712 on Jan 21, 2011 11:5