Japanese

Hi experts,

I am using Oracle database 11

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0      Production
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

And database 10g

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

And Oracle developer suit 10g

Forms [32 Bit] Version 10.1.2.0.2 (Production)
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
     With the Partitioning, OLAP, Data Mining and Real Application Testing options

On same machine with different connecting stings let’s say US for 11g and USM for 10g.

Problem:

When I run report from FORM 10g while connecting to database (USM)10g I can run Report successfully but when I connect to database 11g using connecting string US(11g) it gives me error

FRM-41214 Unable to run report.

What I have tried:

1. Set REPORTS_PATH in registries of OS and also add it in enviroment veriable..
2. Set SINGLESINGON=YES in “C:\developersuitHOME\reports\conf\rwservlet.properties”
3. Recompile report logged in with US(11G) to report builder.

here is code in form builder that is use for running report (it works perfect for 10g database)

declare






    report_P varchar2(200) := 'COA'; -- REPORT NAME





report_format_p VARCHAR2(200) ; -- FORMATE LIKE PDF ETC









alt number;
repid REPORT_OBJECT; 
v_rep VARCHAR2(100); 
rep_status VARCHAR2(50);
list_id paramlist;


BEGIN 




--



-- Generate parameter list for where clause



--



list_id := get_parameter_list('p_soc');



if not id_null(list_id) then




destroy_parameter_list(list_id);



end if;



list_id:=create_parameter_list('p_soc');





-- Set report property 
--*/
repid := find_report_object(REPORT_P); 
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,BATCH); 
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS); 
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,(FILE));
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'PDF');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,'BIAS'); 
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER,'paramform=NO');
--
-- initialize report
--


v_rep := RUN_REPORT_OBJECT(repid,list_id); 
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
--
-- Call report in a web browser
--



--
IF rep_status='FINISHED' THEN




WEB.SHOW_DOCUMENT('http://'||:global.rep_ser||'/reports/rwservlet/getjobid'|| 




substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server=BIAS','_blank'); 



ELSE




--
set_alert_property('ALT_MSG',alert_message_text,'Error in While launching report.... '||DBMS_ERROR_TEXT);



alt:= show_alert('ALT_MSG');



END IF;



--
-- RETPORT CRITERIA : ELSE DO NOTHING
--


END;

what should I do ?

Thanks