Friday, April 1, 2011

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

When attempting to run a concurrent request, 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
-------------------------------------------------------------------------------------------------------------
This error is caused by a concurrent manager setup and privilege related issue in the $APPLPTMP environment variable and UTL_FILE_DIR database parameter.

NOTE: 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.
-------------------------------------------------------------------------------------------------------------
Solution


Step 1 Make sure that APPLPTMP is set to a valid directory and that BOTH the applmgr user and the database user have read and write permissions on that directory (normally, it can be set to the same directory as APPLTMP).


Step 2 Make sure the directory pointed by APPLPTMP is the first entry on the utl_file_dir. Also, verify that all the entries on the utl_file_dir are valid and that the applmgr has read/write permissions.

Step 3 Check application user able to creat file in above directory if no then go to next step.

Step 4 Grant all users read/write permissions to that directory:

chmod 777 /usr/tmp

Step 5 Check DB user can write a file directly using FND_FILE, which is the package used by the Application. From sqlplus, connected as the apps user, run:


SQL> exec FND_FILE.PUT_LINE(FND_FILE.LOG, 'THIS IS A TEST');

This should dump a file on APPLPTMP.

No comments: