temporary files

Posted by latifa on Jul 16, 2020; 1:31pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/temporary-files-tp8513.html


Hi Erman,

Requests can't write temporary file as per error message follwoing:

FDPSTP failed due to ORA-20100: FND_FILE could not write to file o1083344.tmp.

According to DI:261693.1, utl_file_dir should be the same as APPLPTMP and rights to write should be done for both users: database and application. Checking this directory on the database server, The owner is database user and the right of (.) is for all like this:

drwxrwxrwx   2 oracle dba   35682 Jul 15 22:48 .
drwxrwxrwt 2169 root     sys       360645 Jul 16 15:22 ..

utl_file_dir contains APPLPTMP but it's not the first value (second position between 3 values).

I have done the test :

exec FND_FILE.PUT_LINE(FND_FILE.LOG, 'THIS IS A TEST');

however no file in the APPLPTMP directory :(

What's wrong ?

This behavior is happening for all the child requets.


Thanks in advance for your help.

Regards,
LD