This discussion is archived
3 Replies Latest reply: Aug 13, 2013 6:30 AM by rzuluaga - Oracle RSS

getting frm-41214 unless complete path is given to report file

myluism Newbie
Currently Being Moderated

Hi all.

 

I'm using Forms / Reports 11g rel2 (11.1.2.1) deployment mode on a Linux box.

 

In trying to test a simple forms / reports integration, i get error frm-41214 unless i specify a full path for report module.

 

I know this is related to REPORT_PATH setting. According to output from rwserlvlet  showenv command. This is the actual setting:

 

REPORTS_PATH http://mluis.azucarerarioturbio.com:8888/reports/images/space.gif   /u01/app/oracle/middleware/FRHome1/reports/templates:/u01/app/oracle/middleware/FRHome1/reports/samples/demo:/u01/app/oracle/middleware/FRHome1/reports/printers:/u01/app/oracle/middleware/asinst_1/reports/fonts:/home/oracle/sistemas/fuentes/reportes 

 

So i have set this value at two places:

 

- ORACLE_INSTANCE/config/reports/bin

 

[oracle@mluis bin]$ pwd

/u01/app/oracle/middleware/asinst_1/config/reports/bin

[oracle@mluis bin]$ grep REPORT_PATH reports.sh

[oracle@mluis bin]$ pwd

/u01/app/oracle/middleware/asinst_1/config/reports/bin

[oracle@mluis bin]$ grep REPORTS_PATH reports.sh

REPORTS_PATH=/u01/app/oracle/middleware/FRHome1/reports/templates:/u01/app/oracle/middleware/FRHome1/reports/samples/demo:/u01/app/oracle/middleware/FRHome1/reports/printers:/u01/app/oracle/middleware/asinst_1/reports/fonts:/home/oracle/sistemas/bin:${REPORTS_PATH}; export REPORTS_PATH

[oracle@mluis bin]$

 

- ORACLE_HOME/bin:

 

[oracle@mluis bin]$ cd

[oracle@mluis ~]$  cd /u01/app/oracle/middleware/FRHome1/bin

[oracle@mluis bin]$ grep REPORTS_PATH reports.sh

REPORTS_PATH=$$Instance.oracle_home$$/reports/templates:$$Instance.oracle_home$$/reports/samples/demo:$$Instance.oracle_home$$/reports/printers:$$Instance.directory$$/reports/fonts:/home/oracle/sistemas/bin:${REPORTS_PATH}: export REPORTS_PATH

[oracle@mluis bin]$

 

I have two questions:

 

- /home/oracle/sistemas/fuentes/reportes was set some place before (don't remember). Where do i find this setting...? from showenv.

- Which reports.sh should be changed if using in-process report server?. Guess must be the one located at ORACLE_INSTANCE, but it seems is it not picking the right value???


Please HELP!!!


Best regards. Luis

Legend

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