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.