Hi All,
We are on 12.1.3 with Database 11.2.0.3.0. We have written a concurrent program which is defined as a stored plsql procedure.
What we are observing is that, in between some times, the program will not write to log file or output file.
In the program, just after the first BEGIN, we have put a command to write to log file: Started.
BEGIN
fnd_file.put_line (fnd_file.LOG, 'Started');
So this string atleast should be printed, before there is any chance of an exception.
We see the program running fine for many times, in between suddenly there is a run where it is not writing anything to the fnd log.
How can we find why this is happening?
+---------------------------------------------------------------------------+
Current system time is 30-DEC-2014 04:23:54
+---------------------------------------------------------------------------+
**Starts**30-DEC-2014 04:23:55
**Ends**30-DEC-2014 04:25:02
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
Executing request completion options...
Output file size:
0
+------------- 1) PRINT -------------+
Disabling requested Output Post Processing. Nothing to process. The output of the request is zero byte.
+--------------------------------------+
Finished executing request completion options.
+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 30-DEC-2014 04:25:03
+---------------------------------------------------------------------------+