Error ORA-20100 .tmp Creation For FND_FILE Failed In FA Concurrent Requests

Error ORA-20100 .tmp Creation For FND_FILE Failed In FA Concurrent Requests

When attempting to run a concurrent request such as the 'Generate Asset Trace' program (FATRACE), the following error occurs in the log file:

ERROR

ORA-20100: File o0013319.tmp creation for FND_FILE failed.

You will find more information on the cause of the error in request log.

Error: function fa_asset_trace_pkg.save_output returned failure

Route Case

This error is caused by a concurrent manager setup and privilege related issue in the $APPLPTMP environment variable and UTL_FILE_DIR database parameter.

For example:

There could be one user for the Application Tier (applmgr in group applmgr) that is used by the Concurrent Manager, and one user for the database (oracle in group dba) that is used by the database.

The .tmp file is released by user oracle out by utl_file_dir, but the Concurrent Manager will try to access it with user applmgr.  As they are in different groups, this could be an issue on Linux/Unix environments.

Another environment problem could be that the utl_file_dir first directory is not $APPLPTMP.  Then the Concurrent Manager will check in a directory for a tmp and will not find it.

This error can also be seen in cases were there is more then one instance on the same server, and they share the same directory for $APPLPTMP or $UTL_FILE_DIR.  One instance can try to write to the same temporary file, which is locked by the other one.

SOLUTION

Please do the following:

1.  Change the UTL_FILE_DIR to have the same first value as the $APPLPTMP, ex: /usr/tmp

Change it in the initSID.ora and reboot the database after.

2.  Grant all users read/write permissions to that directory:

chmod 777 /usr/tmp