ORA-20100: Error: FND_FILE failure. Unable to create file

I was getting the below error during the dashboard collection.

ORA-20100: Error: FND_FILE failure. Unable to create file


 

APPLTMP and APPLPTMP are sourced and referenced to the correct locations with all the write  permissions and no files with the same name exists.


When I try to create the log file manually from the database:

SQL> conn apps/
Connected.
SQL> exec FND_FILE.PUT(FND_FILE.LOG,'shaik.log');
BEGIN FND_FILE.PUT(FND_FILE.LOG,'shaik.log'); END;

*
ERROR at line 1:
ORA-20100: Error: FND_FILE failure. Unable to create file, o0169751.tmp in the
directory, /database_tempfile/appltmp.
You will find more information in the request log.
ORA-06512: at "APPS.FND_FILE", line 417
ORA-06512: at "APPS.FND_FILE", line 456
ORA-06512: at line 1





Solution:
UTL_FILE was not set properly i.e it was defined as a single path location hence was not working.

SQL> alter system set utl_file_dir='/database_tempfile/appltmp','/usr/tmp'  scope=spfile sid='*';

System altered.

Tried again:

SQL> conn apps/
Connected.
SQL> exec FND_FILE.PUT(FND_FILE.LOG,'shaik.log');

PL/SQL procedure successfully completed.

SQL> exit





460643.1