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!

FRM-41214: Unable to run report when calling reports

Aymen Ben HeniaJul 8 2015 — edited Jul 9 2015

Hi to everyone,

I work with Forms 10g on windows7(local working with OC4j),i have a form with a button that call a report,this is the code of the button:

declare

  repid      REPORT_OBJECT; 

  v_rep      VARCHAR2(100); 

  rep_status VARCHAR2(20); 

BEGIN 

  repid := find_report_object('EMPS_BY_DEPTS');

  SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,BATCH); 

  SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS);

  SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'pdf');

  SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,CACHE);

SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,'repetat');

  SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER,'paramform=no');

  v_rep := RUN_REPORT_OBJECT(repid); 

 

  rep_status := REPORT_OBJECT_STATUS(v_rep);  

 

  WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED')

    LOOP

      rep_status := report_object_status(v_rep);

    END LOOP;

  IF rep_status = 'FINISHED' THEN

   

    WEB.SHOW_DOCUMENT('/reports/rwservlet/getjobid'||substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server=repetat','_blank');

  ELSE 

    message('Error when running report'); 

  END IF; 

END;


I create a report object in object navigator with name "EMPS_BY_DEPTS" with propertie filename = emps_by_depts.rdf.

i also created a server report with command wserver server=repetat

When i press button to call the report i get this famous FRM-41214: Unable to run report.

i tested the execution of report with rwservlet : http://acer-pc:8889/reports/rwservlet?report=emps_by_depts.rdf&userid=hr/hr@orcl&desformat=pdf&destype=cache&expiration=…

and it works fine.

Any idea and thanks


This post has been answered by Celal Özdemir on Jul 9 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 6 2015
Added on Jul 8 2015
11 comments
1,828 views