Journal Entry Reserve Ledger for BE market completes with 'No Data' found.
hi,
we are randomly facing the issue with Journal Entry Reserve Ledger.
this report with the BE option completing normal but out file with 'No Data' found.
we checked the temp table space;
TABLESPACE GB_TOTAL GB_USED GB_FREE
------------------------------- ---------- ---------- ----------
TEMP 187.332031 1.95898438 185.373047
we taken the trace file and uploading here.
TKPROF: Release 10.2.0.4.0 - Production on Tue Jan 3 05:11:58 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Trace file: ppfizi1_ora_12358_FA_TRACE.trc
Sort options: exeela
********************************************************************************
count = number of times OCI procedure was executed
cpu = cpu time in seconds executing
elapsed = elapsed time in seconds executing
disk = number of physical reads of buffers from disk