ORA-20100: Error: FND_FILE failure. ORA-06512: at "APPS.FND_FILE"
When attempting to run the following
SQL> l
1 Begin
2 for i in 1..791 loop
3 fnd_file.put_line(fnd_file.output,'this is test,this is test,this is test');
4 end loop;
5* end;
SQL> /
the following error occurs.
ERROR
-----------------------
*
ERROR at line 1:
ORA-20100: Error: FND_FILE failure. Unable to create file, o4191444.tmp in the directory, /usr/tmp.
You will find more information in the request log.
ORA-06512: at "APPS.FND_FILE", line 554
ORA-06512: at line 3
P.S.1 When the 'loop number' is (791), the file size is 31640,while the 'loop number' is (792), the file size is 63320.
P.S.2 However tried the same loop on other development server with the loop number 9999 it is working fine.