ORA-20100: 为 FND_FILE 创建文件 o0003167.tmp 失败

How To Resolve “ORA-20100: File {filename}.tmp creation for FND_FILE failed” errors (Doc ID 1523526.1)

• The directory does not exist
• The directory is full
• The directory does not have appropriate write permissions
• The UTL_FILE_DIR parameter is incorrect and is not pointing to the right directory
• The $APPLPTMP parameter does not match the UTL_FILE_DIR parameter
• event=’10946 trace name context forever, level 8454144′ #Event 10946 should be set as explained in Note 2525754.1

set serveroutput on
DECLARE
file_location VARCHAR2(256) := '/usr/tmp';
file_name VARCHAR2(256) := 'utlfile1.lst';
file_text VARCHAR2(256) := 'THIS IS A TEST';
file_id UTL_FILE.file_type;
BEGIN
file_id := UTL_FILE.fopen(file_Location, file_name, 'W');
UTL_FILE.put_line(file_id, file_text);
UTL_FILE.fclose(file_id);
EXCEPTION
WHEN UTL_FILE.INVALID_PATH
THEN dbms_output.put_line('Invalid path ' || SQLERRM);
WHEN OTHERS
THEN dbms_output.put_line('Others '|| SQLCODE || ' ' || SQLERRM);
END;
/

ORA-20100: 为 FND_FILE 创建文件 o0003167.tmp 失败

1.查看$APPLPTMP系统环境变量的值，一般是/usr/tmp，需要保证该文件夹是存在的;
2.查看utl_file_dir数据库参数，其第一个值也应该为/usr/tmp;
select* from v$parameter t where t.name=’utl_file_dir’;
3.查看该文件夹的权限，该文件夹必须为应用用户和数据库用户都具有读写权限;
4.通过exec FND_FILE.PUT_LINE(FND_FILE.LOG, ‘THIS IS A TEST’);进行测试;
5.如果仍然还有问题,请查看你的服务器上面是不是有多套ERP环境,如果有多个的话两个$APPLPTMP文件同时写会冲突当一台服务器上运行了多套环境时，不能使用/usr/tmp作为$APPLPTMP，须定义成各自的目录。且该目录须在数据库参数utl_file_dir中。

umask 0022

event=’10946 trace name context forever, level 8454144′ #19c db

Using UTL_FILE_DIR or Database Directories for PL/SQL File I/O in Oracle E-Business Suite Releases 12.1 and 12.2 (Doc ID 2525754.1)
Custom Concurrent Programs Fail with Error FDPSTP failed due to ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed (Doc ID 2723960.1)
19c Database with Oracle E-Business Suite R12 Known Issues & Solutions (Doc ID 2662860.1)
Concurrent Processing – Troubleshooting Concurrent Request ORA-20100 errors in the request logs (Doc ID 261693.1)