ORA-20100: File l5234004.tmp creation for FND_FILE failed


ORA-20100: File l5234004.tmp creation for FND_FILE failed

1. The $APPLTMP, $APPLPTMP variables and UTL_FILE_DIR database parameter should point to the same location and should have  enough space and oracle and applmgr users have written permission on that directory.

2. FND_FILE.PUT_LINE is able to create new files in the temporary directory.

SQL> exec FND_FILE.PUT_LINE(FND_FILE.LOG, ‘THIS IS A TEST’);

This should dump a FND_FILE.LOG file on APPLPTMP.
Then check for UTL file path in db.
SQL> connect / as sysdba
SQL> show parameter UTL_FILE_DIR
If everything same as $APPLTMP and $APPLPTMP, then there is an issue with application.  We can ask the user to submit the program again or user can check with Dev team.


Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."