ORA-20100: File tmp
creation for FND_FILE failed
Error
Oracle error: 20100 in fdpstp
Cause: FDPSTP failed due to ORA-20100: File o5971050.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
Cause
The concurrent program was unable to write to the specified
temporary file because the virtual path assigned to the APPLPTMP environment
variable is not referenced in the UTL_FILE_DIR
Solution
check the location of the APPLPTMP on all application
servers.
echo $APPLPTMP
/share_R12_dev/DEV/DEV_TEMP
Make sure you have the same entry in the utl_file_dir of
your initSID.ora.
ALTER system SET utl_file_dir=' /share_R12_dev/DEV/DEV_TEMP','/usr/tmp','/prod01/app/oracle/db/10.2.0/appsutil/outbound/PROD_db01','/usr/tmp','/home/pcp'
scope=spfile;
Make sure that the
value for APPLPTMP comes first in this listing for UTL_FILE_DIR, as this is the
key to this solution.
