Working on Oracles is mostly a piece of cake. But sometimes when you get stuck on something, it can take forever for you to get out of it. Something similar has happened to me. I started getting the ora 20100 temp file creation for FND_FILE failed error on my database. How can I resolve it?
The ora 20100 error and more similar errors are very common. During processing, Oracle writes some temporary files. Errors like this occur when there is some problem in the processing of the files. They simply tell you that something has gone wrong while processing the files.
In this case, the temp file creation failure error has occurred. This could mean that the system has encountered a problem while performing the write operation of temp files or temporary files.
The solution is simple. Check the directory where the temp files are stored. Check the location of the APPLPTMP on the server. Make sure that your entry in the util_file_dir of your initSID.ora matches the entry on the server.
