fnd_file.output fails to work in pl/sql package when called from a Host concurrent program
Hi,
I have a host concurrent program through which I am invoking a pl/sql package / procedure.
When I want to write through FND_FILE.OUTPUT, it didn't write into the out file of the concurrent program.
One reason I can understand here is that it lost the reference of request ID or session.
While running the PL/SQL procedure, I tried getting the fnd_global.request_id which is -1.
I have used fnd_global.APPS_INITIALIZE on the start of pl/sql procedure but no luck.
I tried another solution "write tmp log file in $APPLPTMP" mentioned in the thread