Skip to Main Content

DevOps, CI/CD and Automation

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!

Report Output File Name

326070Feb 23 2008 — edited Feb 23 2008
I am calling reports from forms using SET_REPORT_OBJECT_PROPERTY built-in.
The report is being generated in reports cache directory.
The output file name is appended with some 8 digit nos.
My requirement is to download file from Apps server to local directory.
I dont know how to get the actual file name in reports cache.
Anyone please help on this matter.

The code i used

PROCEDURE print_sales_report IS
l_success boolean;
report_id report_object;
reportserverjob varchar2(100);
rep_status VARCHAR2(20);
begin
report_id := find_report_object('UP001R');
set_report_object_property(report_id,REPORT_COMM_MODE,SYNCHRONOUS);
set_report_object_property(report_id,REPORT_DESTYPE,FILE);
--set_report_object_property(report_id,REPORT_SERVER,lc_current_app_server);
set_report_object_property(report_id,REPORT_OTHER,'P_DESTTYPE=File p_desname=UP001R P_MODE=Character INPUTDATE=''01-SEP-07''');
reportserverjob := run_report_object(report_id);
rep_status := REPORT_OBJECT_STATUS(reportserverjob);

WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED') LOOP
rep_status := report_object_status(reportserverjob);
END LOOP;

IF rep_status = 'FINISHED' THEN
WEB.SHOW_DOCUMENT('http://machine:port/reports/rwservlet/getjobid'||substr(reportserverjob,instr(reportserverjob,'_',-1)+1)||'?'||'server=rep_orsweb_oracleas2','_blank');
--l_except := webutil_file_transfer.url_to_client(reportserverjob, 'c:\temp\UP001R.txt');
ELSE
message('Error when running report');
END IF;
END;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 22 2008
Added on Feb 23 2008
2 comments
1,582 views