FND_FILE failure. Unable to create file, oXXXXXXX.tmp in the directory, /UTL_FILES « Application DBA and Oracle DBA Concepts

Exception Particulars.

ORA-20100: Error: FND_FILE failure. Not able to build file, oXXXXXXX.tmp in the directory, /UTL_Files

OR

oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20100: Error: FND_FILE failure. Not able to create file, oXXXXXXX.tmp in the listing, /usr/tmp.
You will obtain a lot more data in the ask for log.
ORA-06512: at “APPS.FND_FILE”, line 417
ORA-06512: at “APPS.FND_FILE”, line 526
ORA-06512: at “APPS.IBY_FD_Consumer_API_PUB”, line 661
ORA-06512: at “APPS.IBY_FD_Person_API_PUB”, line 311
ORA-06512: at “APPS.AP_PAYMENT_UTIL_PKG”, line 886
ORA-06512: at line 1

OR

Application-FND-01914: File oXXXXXX.tmp creation failed
File could not be opened or operated on as asked for
Action: Make guaranteed this listing is a legitimate listing with write permissions on
the databases server node and is detailed below utl_file_dir parameter in the
occasion parameter initialization file (init.ora) for the database you are
working with.(TEMP_DIR=/usr/tmp)

Alternative
___________________________________________________________________________________________________________________________________________________________________________

1) Check for the directory locale and authorization. It ought to have 777 permission.
test generating a file with software consumer in that directory.
Listing must have 777 authorization

2) Verify UTL_FILE_DIR entry and worth shoud be exact as $APPLPTMP. Worth $APPLPTMP should really be very first entry in UTL_FILE_DIR.

present paramter utl_File_dir

in our situation it is /usr/tmp

IF not do the adhering to steps

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

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

Refernce
————-
392635.1