5 Replies Latest reply: Jun 1, 2011 12:38 PM by user466652 RSS

    PL/SQL log in java concurrent program is missing

    user466652
      Hi,

      I'm experiencing something strange with EBS R12 concurrent program logs.

      Our concurrent program is just a normal program that runs fine in most cases. It is written in java, which calls PL/SQL procedures. Usually the log is concatenation of logs from both like following

      ...
      ---------------------------------------------------------------------------

      (log from mid-tier java codes ...)

      ---------------------------------------------------------------------------
      Start of log messages from FND_FILE
      ---------------------------------------------------------------------------

      (log from database tier PL/SQL codes ...)

      ---------------------------------------------------------------------------
      End of log messages from FND_FILE
      ---------------------------------------------------------------------------
      ...


      But on one customer's environment the PL/SQL log is missing. This makes us unable to see the important messages.

      I tried to directly look at the files but had no luck.

      select 'cat '||c.value||'/'||p.plsql_log
      from fnd_concurrent_processes p, fnd_concurrent_requests r, fnd_env_context c
      where r.controlling_manager=p.concurrent_process_id
      and p.concurrent_process_id=c.concurrent_process_id
      and c.variable_name='APPLPTMP' and r.request_id=...

      (file not exist in file system)

      req=...; nedit ${APPLCSF}/log/l${req}.req&

      (pl/sql part is missing)

      We verified database tier log directory is writable and has free space.

      Also verified that other concurrent programs written in PL/SQL has correct logs.

      How can we get PL/SQL logs? Please help.

      Thanks