1 2 Previous Next 22 Replies Latest reply on Jun 2, 2016 3:42 PM by BrandonZ

    Oracle 12c Report - Call report from Oracle 12c Form

    SPathak

      Hi ,

       

      I am unable to call the report from form Oracle 12c Windows . 

      From Name : Test

      Report name : Test.fmb

      Trigger : When-button-pressed

       

      When trigger is pressed getting a error message as : FRM-41214 : Unable to run report.

       

      How do you want this type of link to open

      after selecting  firefox browser

       

      it is asking for (which username and password i can give ?)

       

      SYSTEM USER AUTHENTICATION

      USER NAME , PASSWORD

      ERROR MESSAGE : REP-51019 : System user authentication is missing

       

       

      DECLARE

          Repid REPORT_OBJECT;

          v_rep VARCHAR2(100);

          rep_status VARCHAR2(20);

      BEGIN

          repid := FIND_REPORT_OBJECT('REPORT5');

          set_report_object_property(repid, REPORT_EXECUTION_MODE, BATCH);

          set_report_object_property(repid, REPORT_SERVER, 'WLS_REPORTS');

          set_report_object_property(repid, REPORT_COMM_MODE, SYNCHRONOUS);

          set_report_object_property(repid, REPORT_DESTYPE, CACHE);

          set_report_object_property(repid, REPORT_DESFORMAT, 'PDF');

          set_report_object_property(repid, REPORT_FILENAME, 'C:\erp\pp\test.RDF');

       

          v_rep := RUN_REPORT_OBJECT(repid);

          web.show_document('http://sanjay:9002/reports/rwservlet/getjobid'||substr(v_rep,instr(v_rep,'_',-1)+1)||'?server=rep_wls_reports_sanjay

      ');

       

      END;

       

      sandy

        1 2 Previous Next