Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Monday, July 23, 2012

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

2 comments:

Anonymous said...

I've read some good stuff here. Definitely worth bookmarking for revisiting.

mehak kashish said...

excellent piece of information, I had come to know about your website from my friend kishore, pune,i have read atleast 8 posts of yours by now, and let me tell you, your site gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanx a lot once again, Regards, obiee training in hyderebad