Error :
ORACLE error 20100 in FDPSTP
FDPSTP failed due to ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed.
Directory &FILE_DIR is invalid, contact your system administrator.
Action:
Check that the directory is a valid directory with wri06-APR-2016 14:48:29
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.
The value of this parameter is specified in the CONTEXT FILE of the application server.
[applprod@dbaarena01 ebsprod_dbaarena01]$ echo $APPLPTMP
/u01/app/oracle/product/11.2.0.3/dbhome_1/tmp
Applications also produces temporary PL/SQL output files used in concurrent processing. These files are written to a location on the database server node specified by the APPLPTMP environment setting. The APPLPTMP directory must be the same directory as specified by the utl_file_dir parameter in your database initialization file.
SQL> show parameter utl
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
create_stored_outlines string
utl_file_dir string /u01/app/oracle/tmp
Take backup of the current parameter file.
Edit the parameter file and change the value of the utl_file_dir parameter to a readable/writable directory (i.e. $APPLPTMP, '/u01/app/oracle/tmp')
Make sure that the value for APPLPTMP comes first in this listing for UTL_FILE_DIR, as this is the key to this solution.
alter system set utl_file_dir='/u01/app/oracle/product/11.2.0.3/dbhome_1/tmp','/u01/app/oracle/tmp' scope=spfile;
System altered.
Bounce the application and database.
SQL> show parameter utl
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
create_stored_outlines string
utl_file_dir string /u01/app/oracle/product/11.2.0.3/dbhome_1/tmp, /u01/app/oracle/tmp
Run the concurrent request and check again.