Core Concurrent Processing - EBS (MOSC)

MOSC Banner

fnd_file calling through concurrent request not working.

edited Aug 13, 2014 5:02AM in Core Concurrent Processing - EBS (MOSC) 7 commentsAnswered
Hi,
We are calling below sql through a concurrent request.
===
[appltest4@tvlap73 sql]$ cat KCLSQL1.sql
SET SERVEROUTPUT on
set head off
set pages 0
set lines 600
set trimspool on

DECLARE



BEGIN

   fnd_file.put_line(fnd_file.output,'KCL Testing);


      fnd_file.put_line(fnd_file.log,'KCL');
      fnd_file.put_line(fnd_file.log,'SQL');
      fnd_file.put_line(fnd_file.log,'TEST');

END;
/
============

The expected results are...
In concurrent request log file it should print the fnd_file.log entries as "KCL","SQL","TEST". And In Concurrent request output file it should print "KCL Testing".
But in my case both are not happening. At DB level we verified APPLPTMP, utl_file_dir values are fine.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center