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!

Oracle Report 12c - Error The report terminated with error: REP-69: An internal error occurred REP-

SANPATFeb 6 2018 — edited Feb 23 2018

Dear Friends

I am getting the following error message while running the report from 12c form.

Oracle Report 12c - Error The report terminated with error:  REP-69: An internal error occurred REP-56132: Access is denied to the report definition file. .  

As per below script If i change the Path from c:\erp\master to c:\erp\mm then i gets this error

declare

  xpath           varchar2(45);

  PARALIST        paramlist;

  rep_id       report_object;

  v_rep       varchar2(100);

  v_report_server varchar2(100);

  v_servlet_url   varchar2(500);

    v_job_id        varchar2(100);

    rep_status      varchar2(100);

    P_FILE_NAME     varchar2(100);

begin

  P_FILE_NAME:='C:\erp\'||'State.PDF';

  xpath:='C:\erp\MASTER\State.rdf';

 

PARALIST := Get_Parameter_List('param_list_main');

IF id_null(paralist) THEN

   PARALIST := CREATE_PARAMETER_LIST('param_list_main');

ELSE

   Destroy_Parameter_List(paralist);

   PARALIST := CREATE_PARAMETER_LIST('param_list_main');

END IF;

--ADD_PARAMETER(PARALIST,'DOC_NO',TEXT_PARAMETER,:BANK_RECEIPT_H.doc_no);

--ADD_PARAMETER(PARALIST,'year1',TEXT_PARAMETER,:block3.year1);

  v_report_server := 'rep_wls_reports_erp';

    v_servlet_url   := 'erp:9002/reports/rwservlet';

  rep_id:=find_report_object('Report5');

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

    set_report_object_property(rep_id,REPORT_DESNAME,P_FILE_NAME); 

    ---v_rep:=run_report_object(rep_id,PARALIST);

    v_rep:=run_report_object(rep_id);

    rep_status := REPORT_OBJECT_STATUS(v_rep);

   

  Message(rep_status);

Message(rep_status);

    V_JOB_ID := SUBSTR(V_REP,INSTR(V_REP,'_',-1)+1);

   

    IF rep_status = 'FINISHED' THEN

       web.show_document('http://'||v_servlet_url||'/getjobid'||V_JOB_ID,'_blank');

    END IF;

  

exception when no_data_found then

null;

end;

This post has been answered by Matej D. on Feb 6 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 6 2018
Added on Feb 6 2018
2 comments
5,706 views