2. Isn't something that Oracel stores in a DB.
3.FND_FILE.PUT_LINE() calls use the UTL_FILE package to write the line to a temporary file in the $APPLPTMP directory.
4. If you are using the FND_FILE.PUT_LINE() from within a concurrent program, the actual temporary files used can be found with the following query (directory, output temporary file, log temporary file):
select cp.plsql_dir, cp.plsql_out, cp.plsql_log
from fnd_concurrent_requests cr, fnd_concurrent_processes cp
where cr.request_id =
and cp.concurrent_process_id = cr.controlling_manager;
Once the concurrent request completes, the data in the temporary files is copied to the concurrent request output and log files (for example $APPLCSF/out/
If you are not using this from inside a concurrent request, you would need to be file handling yourself (ie set file names, open, fetch contents once complete, close, etc) - you would need to trawl through FND_FILE and FND_FILE_PRIVATE to work out exactly how to do that.
No comments:
Post a Comment