11g reports - compile error
I am trying to compile a 11g report 2 different ways. The first scenario works. The second scenario does not produce a rep file. Thanks.
Scenario ONE
unset DISPLAY
rm $REPORTS_PATH/$1.rep
$ORACLE_INSTANCE/config/reports/bin/rwconverter.sh userid=camsadm/camsadm2010@cfssand batch=yes source=$1 stype=rdffile dest=$REPORTS_PATH/$1.rep dtype=repfile
overwrite=yes compile_all=yes > $1.log chmod 777 $REPORTS_PATH/$1.rep >> $1.log
VS.
Scenario ONE
unset DISPLAY
rm $REPORTS_PATH/$1.rep
$ORACLE_INSTANCE/config/reports/bin/rwconverter.sh userid=camsadm/camsadm2010@cfssand batch=yes source=$1 stype=rdffile dest=$REPORTS_PATH/$1.rep dtype=repfile
overwrite=yes compile_all=yes > $1.log chmod 777 $REPORTS_PATH/$1.rep >> $1.log
VS.
Scenario TWO
LOG=$PWD/$0.log
cat /dev/null >$LOG
echo
ORACLE_HOME=/u03/app/oracle/Middleware/as_PFRD
export ORACLE_HOME
ORACLE_INSTANCE=/u03/app/oracle/Middleware/pfrd_inst
export ORACLE_INSTANCE
MW_HOME=/u03/app/oracle/Middleware
0