ORA-20100: Mistake: FND_FILE failure. Not able to create file, oXXXXXXX.tmp in the listing, /UTL_Files
Posted by zohebsh on Oct 8, 2012
ORA-20100: Error: FND_FILE failure. Not able to build file, oXXXXXXX.tmp in the directory, /UTL_Files
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
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
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
This entry was posted on Oct 8, 2012 at 4:40 pm and is filed underneath Difficulty and Resolution.
You can follow any responses to this entry via the RSS 2. feed.
You can go away a reactionor trackback from your have website.