This content has been marked as final. Show 2 replies
steve.g wrote:Please see if these docs help.
I have set up a periodic alert which runs a sql procedure and sends email if not successful. I can show the concurrent job id and the output in the email, but when I write to concurrent log, it does not end up there. I tried both log and output.
Does anyone know how to get the info to show in the log?
The Request Stay In Status Running Instead of Finish [ID 580463.1]
Creating a PL/SQL Concurrent Program in Oracle Applications [ID 73492.1]
How to Handle New Date Formats in SQL*Plus and PL/SQL Procedures? [ID 376034.1]
APPS:FND - Using DBMS_OUTPUT.PUT_LINE in Concurrent Programs [ID 186094.1]
I have looked at these threads and many more and can not understand why the apps.FND_FILE.put_line (apps.FND_FILE.output, 'Result XML');
apps.FND_FILE.put_line (apps.FND_FILE.LOG, v_msg);
lines are not writing to the logs.
Both the session id and the concurrent id are available.
I tried fnd_global.INITIALIZE and fnd_global.APPS_INITIALIZE and no output or logging.
Is it even possible to write to the periodic alert log?
If so, can someone send me an example?
ps I know I can do it by spawning another concurrent job, but I would like to just put it in the alert log if possible.
Edited by: steve.g on Mar 11, 2013 11:34 AM