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
/home/pcp

Make sure you have the same entry in the utl_file_dir of your initSID.ora.

ALTER system SET utl_file_dir='/home/pcp','/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.

Share →
0 comments
Skip to toolbar