My Journey to the cloud…

Today support team sought a help for the issue they were encountering in the TEST instance.

Error as given by the support team

ErrBufORA-20100: File o7725967.tmp creation for FND_FILE failed.
You will find more information on the cause of the error in request log.

I tried a quick test to see if there is any issue with utl_file_dir

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

*
ERROR at line 1:
ORA-20100: File o7725970.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 "APPS.FND_FILE", line 517
ORA-06512: at line 1

Above test threw an error. Then I verified 2 more things

1) APPLPTMP directory should be the first one appearing when UTL_FILE_DIR parameter is queried – this looked Ok

SQL>show parameter utl_file

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
utl_file_dir string /d05/apptest/common/temp, /usr
/tmp, /d12/oratest/product/9.2.
0/appsutil/outbound/TEST, /d05/
apptest/11.5/xxbb/4.0.0/edi/ou
t, /d05/appltest/11.5/xxdd/4.0.
0/US/utl_file_dir, /d05/appltest
t/common/admin/log/TEST_host_name
, /d05/appltest/common/admi
n/out/TEST_host_name, /d05/ap
pltest/common/admin/log/TEST_host_name,
/d12/oratest/product/
9.2.0/ccr/hosts/host_name/st
ate, /d05/appltest/11.5/xxcal/s
mart, /d05/appltest/11.5/xxcal/
bartender

2)Missing permissions on APPLPTMP directory – I found that the permission was not correct. I gave the permission (777) to the directory and this resolved the issue.

To confirm, I ran the same procedure again and it returned the expected result.

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

PL/SQL procedure successfully completed.

Elapsed: 00:00:01.15

Other probable causes of error

3)APPLPTMP directory is missing &

4)APPLPTMP directory pointing to wrong location

Hope this helps.