Re: temporary files

Posted by ErmanArslansOracleBlog on Aug 15, 2020; 6:47pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/temporary-files-tp8513p8645.html

APPLPTMP is a special directory used only for PLSQL temporary files. When a concurrent program uses the FND_FILE package, the concurrent manager uses APPLPTMP as the directory to which it writes temporary files.

APPLTMP is something different. APPLTMP does not need a utl_file_dir entry. It  the temporary directory used by the application. (it is not accessed through the database.)

So anyways, APPLTPTMP directory must be accessible with Full permission and it must be the first entry in UTL_FILE_DIR on Database Node.

So why don't you change the utl_file_dir parameter accordingly?