developers

    Forum Stats

  • 3,873,872 Users
  • 2,266,625 Discussions
  • 7,911,648 Comments

Discussions

FRM 41219 cannot find report, invalid id error

SandyM
SandyM Member Posts: 61 Green Ribbon

I have pll which calls the report as below, since it's pll there is no report object defined. can you please advise how to fix this issue without report object in pll ?


XPATH:= XPATH||P_CURRENT_FORM||'.rdf';

 P_FILE_NAME:=P_FILE_NAME||REPORT_NAME1;

 W_REPORTS_DOC_PATH:=W_REPORTS_DOC_PATH||REPORT_NAME1;

   --rep_id:=find_report_object('CCA_Report');

   set_report_object_property(rep_id,REPORT_SERVER,v_report_server);

  set_report_object_property(rep_id,REPORT_EXECUTION_MODE,BATCH);

 set_report_object_property(rep_id,REPORT_COMM_MODE,SYNCHRONOUS);

  set_report_object_property(rep_id,REPORT_DESTYPE,FILE);

  set_report_object_property(rep_id,REPORT_DESFORMAT,'PDF');

  set_report_object_property(rep_id,REPORT_FILENAME,XPATH);  

 

  if WS_PAGE_ADVANCE = 1 then

  set_report_object_property(rep_id,REPORT_DESNAME,''''||P_FILE_NAME||''''); 

  else

  set_report_object_property(rep_id,REPORT_DESNAME,''''||W_REPORTS_DOC_PATH||''''); 

  end if;

  v_rep:=run_report_object(rep_id,pl_id);

  rep_status := REPORT_OBJECT_STATUS(v_rep);

    if WS_PAGE_ADVANCE = 1 then

   copy_command:=webutil_file_transfer.AS_To_Client(W_CLOSING_DOC_PATH,P_FILE_NAME);

  end if;

Answers

developers