Periodic alert runs successfully and fails ..
The alert runs twice successfully, then fails twice, then runs twice successfully then fails twice etc.
Would understand if it failed all the time, or ran successfully all the time, but can't understand why the fail / complete loop.
On the occasions the job does complete, it triggers emails as expected.
$Header: alepea.lc 115.22 2008/08/20 15:39:20 jwsmith ship $
$Header: alucmn.lc 115.19 2008/06/26 20:38:31 jwsmith ship $
Alert log file:
+---------------------------------------------------------------------------+
Alert: Version : 11.5.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
ALECDC module: Check Periodic Alert
+---------------------------------------------------------------------------+
Current system time is 05-SEP-2011 09:15:10
+---------------------------------------------------------------------------+
APP-ALR-04106: Please correct the user-defined SQL statement for this alert.
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
Would understand if it failed all the time, or ran successfully all the time, but can't understand why the fail / complete loop.
On the occasions the job does complete, it triggers emails as expected.
$Header: alepea.lc 115.22 2008/08/20 15:39:20 jwsmith ship $
$Header: alucmn.lc 115.19 2008/06/26 20:38:31 jwsmith ship $
Alert log file:
+---------------------------------------------------------------------------+
Alert: Version : 11.5.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
ALECDC module: Check Periodic Alert
+---------------------------------------------------------------------------+
Current system time is 05-SEP-2011 09:15:10
+---------------------------------------------------------------------------+
APP-ALR-04106: Please correct the user-defined SQL statement for this alert.
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
0