Temp Issues

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

Make sure the following are set up properly:

1) utl_file_dir parameter in v$parameter has the same value as $APPLPTMP, $APPLTMP and $REPORTS60_TMP ( Make sure they all set to first directory of utl_file_dir )
2) Permission on directory of utl_file_dir parameter shows 777 - full read/write

Wht happens if APPLTMP is not set to 1st dir of utl_file_dir ?

FND_FILE pkg write the file to 1st directory in utl_file_dir and application look for the file in APPLTMP location.
If both are different there comes the conflict.

APPLPTMP is a directory used only for PLSQL temporary files
FND_FILE uses the UTL_FILE which writes to utl_file_dir

SQL> exec FND_FILE.PUT_LINE(FND_FILE.LOG, 'Check it Out');

You should b able to c the file in APPLPTMP

Get the first dir in utl_file_dir

Ref Notes :

Concurrent Processing - Troubleshooting Concurrent Request ORA-20100 errors in the request logs [ID 261693.1]
Build Formula Package Fails: ORA-20100: File "*.tmp" creation for FND_FILE failed [ID 458742.1]



UR's Key Run ;-)