This discussion is archived
2 Replies Latest reply: May 15, 2013 5:50 AM by InoL RSS

FRM-41214: Unable to run Report geting as error

1008983 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points