EBS Customizations (MOSC)

MOSC Banner

fnd_file.output fails to work in pl/sql package when called from a Host concurrent program

edited May 19, 2016 11:02AM in EBS Customizations (MOSC) 3 commentsAnswered

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

Tagged:

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