Logo Background

Oracle APPS.FND_FILE Error

  • By on May 31, 2009 | 2 Comments

    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: at

    This 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.

    Previous
    Next
    » Data Migration Oracle E-Business Suite And SSO/OID
  1. #1 Shee
    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.

    Post ReplyPost Reply
  1. #2 Gaurav Bajaj
    September 7, 2010 1:53 pm

    Hi 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

    Post ReplyPost Reply
Leave a Comment