EBS Customizations (MOSC)

MOSC Banner

FND_FILE package calling through a concurrent programme is not working

edited Apr 22, 2012 5:47PM in EBS Customizations (MOSC) 16 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