In running rms_satotals_a.sh in daily batch, it fails when the committed processing status of a store is not successfully read in a while loop. The while loop loops through a number of stores contained in a table. The Script contents show below,

sqlplus -s $LOGNAME1/$PASSWORD1@$connstr @$SCRIPTPATH/get_store_no.sql

while read LINE
do
   $PGMFILEPATH/satotals $LOGNAME1/$PASSWORD1@$connstr $LINE
   sleep 3
done < $OUTPTH/store_no.txt

It is suspected that this is caused by the max_commit_propagation_delay init parameter setting (see 30761.1 for definition and 260304.1 for a problematic situation).

1) Any similar experience re this parameter.
2) The current value used in HK and any recommended value for this parameter

Oracle recommends max_commit_propagation_delay=0 for Oracle Applications running in RAC. Anyone experience the issue, Any suggestion will be appreciated!!