3 Replies Latest reply: Aug 13, 2013 8:30 AM by Rzuluaga - Oracle-Oracle RSS

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

    myluism

      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