Cause:  FDPSTP failed due to ORA-20100: File oxxxxxx.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 “APPS.FND_
Description:
This happens when APPS.FND_FILE package couldn’t write the temporary files in UTL_FILE_DIR.

Solution:
First you have to check the value of your UTL_FILE_DIR in v$parameter table.

Login to SQL-PLUS using APPS user account

SQL> SHOW PARAMETERS

utl_file_dir       string      /usr/tmp/XXprd,/usr/tmp
Once the value was identified, proceed to the Unix and check the status of the mount point
where the UTL_FILE_DIR.

Verify write permission for APPS user.