Oracle APPS.FND_FILE Error
Sometimes Oracle concurrent completed with error message as below: -
ORACLE error 20100 in FDPSTP
Cause: FDPSTP failed due to ORA-20100: File o5516887.tmp creation for FND_FILE failed.
You will find more information on the cause of the error in request log.
ORA-06512: at “APPS.FND_FILE”, line 410
ORA-06512: atThis happens when APPS.FND_FILE package couldn’t write the temporary files in UTL_FILE_DIR.
First you have to check the value of your UTL_FILE_DIR in v$parameter table.
Once the value was identified, proceed to the Unix and check the status of the mount point where the UTL_FILE_DIR.
Troubleshoot Oracle APPS.FND_FILE Error
$ bdf bdf: /appl: Stale NFS file handle
As you can see, there’s some error in the NFS sharing on the mount point where the temporary file was created thus the error FDPSTP failed due to ORA-20100 happens.
Fix the mount point issue and it will resolve your error in Oracle concurrent as well.
Related Posts
- Oracle Apps 11i & Database Cloning
- Unix Find Big Large Files
- Rapid Clone adcfgclone.pl Error
- Oracle Apps Autoconfig
- Oracle LDAP Error
PreviousNext» Data Migration Oracle E-Business Suite And SSO/OID
Leave a Comment- #2
Gaurav Bajaj
September 7, 2010 1:53 pmHi All,
I also encountered the same problem and observed that the directory which was specified for ‘UTL_FILE_DIR in v$parameter table’ did not exist in the system. Hence, I manually created it.
Now, I am not facing the above-mentioned issue.
Thanks
Gaurav Bajaj
Join the over 2,000 people who get free and fresh knowledge as soon as it’s published.
We respect your email privacy.
We promise never to rent, sell or share information we collect because that would be a violation of everything we stand for.
Period.
January 27, 2010 9:54 am
I encountered the same problem and our DBA found out that the issue was due to space issue. The report that
I am running is creating a large file so they increased the size from 2GB to a larger space. The issue did not occur again.