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 ( 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   /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


[oracle@mluis bin]$ grep REPORT_PATH

[oracle@mluis bin]$ pwd


[oracle@mluis bin]$ grep REPORTS_PATH

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@mluis bin]$ cd

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

[oracle@mluis bin]$ grep REPORTS_PATH

REPORTS_PATH=$$Instance.oracle_home$$/reports/templates:$$Instance.oracle_home$$/reports/samples/demo:$$Instance.oracle_home$$/reports/printers:$$$$/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 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


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