2 Replies Latest reply: May 15, 2013 7:50 AM by InoL RSS

    FRM-41214: Unable to run Report geting as error

    1008983
      I am converting 6i reports to 11g for that i am compiling 6i report in 10g reports and copy in 11g server

      in that report is calling from form i have writen query
      like


      DECLARE
      paramlistname VARCHAR2(30) := 'PLIST1';
      plid PARAMLIST;
      cnt number;
      report_id report_object;
      BEGIN
      plid := GET_PARAMETER_LIST(paramlistname);

      IF NOT ID_NULL(plid) THEN
      DESTROY_PARAMETER_LIST(paramlistname);
      END IF;
      plid := CREATE_PARAMETER_LIST(paramlistname);

      ADD_PARAMETER(plid, 'paramform', TEXT_PARAMETER, 'NO');
      ADD_PARAMETER(plid, 'p_division_code' , TEXT_PARAMETER, :control_007.division_code);
      ADD_PARAMETER(plid, 'p_depot_code' , TEXT_PARAMETER, :control_007.depot_code);
      ADD_PARAMETER(plid, 'P_VALIDITY_DATE' , TEXT_PARAMETER, to_char(:control_007.valid_date,'DD/MM/YYYY'));
      ADD_PARAMETER(plid, 'MAXIMIZE', TEXT_PARAMETER, 'YES');

      report_id := find_report_object('Report_NTP_Pending_QtyP');
                web_reportn(report_id,plid);
                          
      DESTROY_PARAMETER_LIST(plid);
      go_block('Control_007');

      end;



      while runging a report from form i am getting error FRM-41214 Unable to run Report



      So Please Help Me how to solve this problem in 11g