EBS Customizations (MOSC)

MOSC Banner

Concurrent program to write a file in apps server

edited Jul 23, 2015 10:02AM in EBS Customizations (MOSC) 4 commentsAnswered

We are in 11.5.10.2 apps and 10g database.  Apps is in apps Linux server and database is in database linux server ( 2 nodes ).

I create a concurrent program.  It is required to create one output with specify file name and the file must save in some other directory in the apps server.

Since the database is in different linux box, if I use UTL_FILE.FOPEN, it will create the file in database linux server.   I like the file is created in apps server.  I also cannot use the apps.fnd_file.put(apps.fnd_file.output, 'ABC...') because it will write to the standard output file which name like o123456.out.  the file name must be called file_14JUL2015_120132.txt  ( file name include current date and time )

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