Your Doorstep to the Temple of Oracle

Oracle EBS

ORA-20100: Error: FND_FILE failure. Unable to create file, l*****.tmp in the directory

Posted by appsdba11i on May 15, 2011

Hi Folks

I got recently a issue with FND_FILE, i.e a concurrent program is unable to creae a ffile in directory /SID/tmp.

Error may look like this

Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20100: Error: FND_FILE failure. Unable to create file, o9875234.tmp in the directory, /usr/tmp.
You will find more information in the request log.
ORA-06512: at "APPS.FND_FILE", line 417
ORA-06512: at "APPS.FND_FILE", line 526
ORA-06512: at "APPS.IBY_FD_USER_API_PUB", line 661
ORA-06512: at "APPS.IBY_FD_USER_API_PUB", line 311
ORA-06512: at "APPS.AP_PAYMENT_UTIL_PKG", line 886
ORA-06512: at line 1

OR

APP-FND-01914: File o0001236.tmp creation failed
File could not be opened or operated on as requested
Action: Make sure this directory is a valid directory with write permissions on
the database server node and is listed under utl_file_dir parameter in the
instance parameter initialization file (init.ora) for the database you are
working with.(TEMP_DIR=/usr/tmp)

If someone Get similar type of issue please do the this steps .

Approach:
————–
1) chk wether that directory physically Exist or not.
2) Directory Shoud Have Write permissions to the application user(applmgr) as
it will create a some .tmp file .

change Directory file permssion to 777. so that others can write a file into it

chmod 777 /usr/tmp

3) Check UTL_FILE_DIR entry and value shoud be same as u r directory

show paramter utl_File_dir

in our case it is /usr/tmp

4) chk APPLTMP varaible value in MT & the first value of UTL_FILE_DIR shoud be
APPLMTP variable..

echo $APPLTMP

IF not do the following steps

1. Change the UTL_FILE_DIR to have the same first value as the $APPLPTMP,
in our case : /usr/tmp
Change it in the initSID.ora and reboot the database after.

2. Grant all users read/write permissions to that directory:
chmod 777 /usr/tmp

Refernce
————-
392635.1

Regards
Reddy

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

 
%d bloggers like this: