Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How and where can we set variable for report server to be used in every form redirecting to a Report

User_S7PVRMar 9 2022

Problem Description
---------------------------------------------------
We have recently completed FMW, Forms and Reports 12.2.1.4.0 version.
We can run forms and reports successfully.
However in the code which redirects to reports from a form- this is a part of PL/SQL trigger block which calls report from a form.
-----------
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESFORMAT,'PDF');
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESTYPE,CACHE);
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_SERVER,'rep_wls_reports_kbn1pp-oawl003');
vc_ReportServerJob:=RUN_REPORT_OBJECT(v_report_id);
vjob_id := substr(vc_ReportServerJob,instr(vc_ReportServerJob,'_',-1)+1);
vc_rep_status := REPORT_OBJECT_STATUS(vc_ReportServerJob);
IF vc_rep_status = 'FINISHED' THEN
WEB.SHOW_DOCUMENT('http://kbn1pp-oawl003:8002/reports/rwservlet/getjobid'|| vjob_id ||'?server=rep_wls_reports_kbn1pp-oawl003','_blank');
ELSE
message ('Report failed with error message '||vc_rep_status);
END IF;
WHILE vc_rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED')
LOOP
vc_rep_status := report_object_status(vc_ReportServerJob);
END LOOP;
-------------------
We do not want to define Server name every time in code when redirecting to Report from a Form.
How and where we can set a global variable in configuration and use it in the code ?

Comments

Post Details

Added on Mar 9 2022
1 comment
444 views