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!

REP-51002 Bind to report server failed in forms 12c

KalpataruJan 2 2016 — edited Jan 4 2016

Hi All,

I have calling report from forms 12c but getting error my report server name is rep_wls_reports_kalpataru started successfully see image.

rwserver.jpg

REP-51002.jpg

REP-51002 Bind to report server rep_wls_reports_kalpataru failed in 12c

run report button code

----------------------

DECLARE

PARALIST paramlist;

n number;

p_file_name varchar2(200);

BEGIN

P_FILE_NAME:='C:\Oracle\Middleware\Oracle_Home\reports\'||user||'Employee'||'.PDF';

paralist := Get_Parameter_List('param_list_main');

IF id_null(paralist) THEN

PARALIST := CREATE\_PARAMETER\_LIST('param\_list\_main');

ELSE

Destroy\_Parameter\_List(paralist);

PARALIST := CREATE\_PARAMETER\_LIST('param\_list\_main');

END IF;

ADD_PARAMETER(PARALIST,'P_DEPT_NO',TEXT_PARAMETER,:DEPT.DEPTNO);

Report_Print(p_file_name,'PDF','EMPLOYEE.rdf',PARALIST);

Destroy_Parameter_List(paralist);

END;

Report print procedure

-----------------------

PROCEDURE Report_Print(p_file_name varchar2,p_desformat varchar2,p_report_filename varchar2,p_paramlist paramlist) IS

rep_id report_object;

v_rep varchar2(100);

v_report_server varchar2(100);

v_report_path varchar2(100);

v_servlet_url varchar2(500);

v_job_id varchar2(100);

BEGIN

v_report_server := 'rep_wls_reports_kalpataru';

v_report_path := 'C:\Oracle\Middleware\Oracle_Home\reports';

v\_servlet\_url   := '127.0.0.1:7779/reports/rwservlet';

rep_id:=find_report_object('report1');

set\_report\_object\_property(rep\_id,REPORT\_SERVER,v\_report\_server);

set\_report\_object\_property(rep\_id,REPORT\_EXECUTION\_MODE,BATCH);

set\_report\_object\_property(rep\_id,REPORT\_COMM\_MODE,SYNCHRONOUS);

set\_report\_object\_property(rep\_id,REPORT\_DESTYPE,FILE);

set\_report\_object\_property(rep\_id,REPORT\_DESFORMAT,p\_desformat);

set\_report\_object\_property(rep\_id,REPORT\_FILENAME,v\_report\_path||'\\'||p\_report\_filename);

set\_report\_object\_property(rep\_id,REPORT\_DESNAME,p\_file\_name);

v\_rep:=run\_report\_object(rep\_id,p\_paramlist);

V\_JOB\_ID := SUBSTR(V\_REP,INSTR(V\_REP,'\_',-1)+1);

web.show\_document('[http://'||v\_servlet\_url||'/getjobid'||V\_JOB\_ID,'\_blank');](http://'||v_servlet_url||'/getjobid'||V_JOB_ID,'_blank');)

END;

Please any one guide me to solve this.

This post has been answered by Kalpataru on Jan 3 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 1 2016
Added on Jan 2 2016
9 comments
7,158 views